I am trying to upgrade from 10gXE to 11gXE;
I logon to SQL Plus "conn sys as sysdba", and execute the gen_inst.sql procedure.
Quote: Connect to 10.2 XE database as SYS user and run gen_inst.sql. This will generate install.sql, gen_apps.sql and other .sql files. The files will be generated in the folder containing gen_inst.sql. End Quote.
However the procedure completes immediately, and does not generate any of the files described.
If I execute @(folder path)\fred.sql (where fred.sql does not exist, I get a message that the sql proc is not found, so I know that it finds the procedure when I try and execute it.
The following is a copy of the command window.
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 14 11:24:06 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> @c:\temp\gen_inst.sql
SQL> @c:\temp\fred.sql
SP2-0310: unable to open file "c:\temp\fred.sql"
SQL>
None of the defined files , "install.sql, gen_apps.sql and other .sql files" are created.
If it try and run gen_inst.sql from within SQLDeveloper (2.1.1.64), after haveing connected as sys/sysdba, the procedure runs for several minutes, and creates some of the listed output files, before it finally crashes with :
Error report:
ORA-20000: ORU-10027: buffer overflow, limit of 1000000 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 5
20000. 00000 - "%s"
*Cause: The stored procedure 'raise_application_error'
was called which causes this error to be generated.
*Action: Correct the problem as described in the error message or contact
the application administrator or DBA for more information.
How do I get the script to run correctly in SQL Plus?
Edited by: Ian Mc on Jan 14, 2012 2:00 AM