ORU-10027: buffer overflow, limit of bytes


This is caused by the value of the 'serveroutput' setting in SQL*Plus. 

The same error can be seen directly in SQL*Plus as follows:

SQL> set serveroutput on size 2000
SQL>
[...]
12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890
begin
*
ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 32
ORA-06512: at "SYS.DBMS_OUTPUT", line 97
ORA-06512: at "SYS.DBMS_OUTPUT", line 112
ORA-06512: at line 3

SOLUTION
Increase the value for the "serveroutput" parameter:
  1. Before starting MRCA:
    a) Ensure no environment variable is pointing to another older version of SQL*Plus.
         e.g. PATH/LD_LIBRARY_PATH/ORACLE_HOME, etc.
    b) Check the SQL*Plus version:
        e.g. Execute command: which sqlplus
              It should  returns a value linked to SQL*Plus 10.2.0.3.
  2. In the ORACLE_HOME instance used to run the installation, modify the following file in SQL*Plus:
    cd $ORACLE_HOME/sqlplus/admin
    vi glogin.sql
    At the end of this sql script, add:
    SET SERVEROUTPUT ON SIZE 10000
  3. Try in SQL*plus if it works:
    sqlplus system/xxxx@sid
    SQL>exec dbms_output.put_line('hello');
    
    If you see 'hello', it means that the setting is set up properly, since SERVEROUTPUT is off by default.
    
    
  4. Re-start the install and check that that the ORA-20000: ORU-10027 errors do not appear anymore.
  5. If the errors  still occur, try making the suggested  'serveroutput' setting changes to the SQL*Plus installations in both the MRCA Oracle Home and the Database Oracle Home, and test that the following  SQL code works:
    SQL> set serveroutput on
            begin
             for i in 1..1000 loop
             dbms_output.put_line('12345678901234567890123456789012345678901234567890');
            end loop;
            end;
    
    
  6. Attempt the install again with this configuration.
MOS id: ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes' (Doc ID 555831.1)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: