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
Increase the value for the "serveroutput" parameter:
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.
In the ORACLE_HOME instance used to run the installation, modify the following file in SQL*Plus:
At the end of this sql script, add:
SET SERVEROUTPUT ON SIZE 10000
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.
Re-start the install and check that that the ORA-20000: ORU-10027 errors do not appear anymore.
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;
Attempt the install again with this configuration.
MOS id: ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes' (Doc ID 555831.1)