Skip to Content
0
Former Member
Jun 19, 2011 at 12:47 PM

Error while performing Oracle 11g upgrade

209 Views

Hi,

I am facing error while performing an Oracle upgrade from 10.2.0.4 to 11.2.0.2.

DBUA was disconnected with error Ora 1092 Oracle instance terminated.

When tried to run manual upgrade it is showing the below error,

SQL> @catupgrd.sql

DOC>#######################################################################

DOC>#######################################################################

DOC>

DOC> The first time this script is run, there should be no error messages

DOC> generated; all normal upgrade error messages are suppressed.

DOC>

DOC> If this script is being re-run after correcting some problem, then

DOC> expect the following error which is not automatically suppressed:

DOC>

DOC> ORA-00001: unique constraint (<constraint_name>) violated

DOC> possibly in conjunction with

DOC> ORA-06512: at "<procedure/function name>", line NN

DOC>

DOC> These errors will automatically be suppressed by the Database Upgrade

DOC> Assistant (DBUA) when it re-runs an upgrade.

DOC>

DOC>#######################################################################

DOC>#######################################################################

DOC>#

DOC>######################################################################

DOC>######################################################################

DOC> The following statement will cause an "ORA-01722: invalid number"

DOC> error if the user running this script is not SYS. Disconnect

DOC> and reconnect with AS SYSDBA.

DOC>######################################################################

DOC>######################################################################

DOC>#

no rows selected

DOC>######################################################################

DOC>######################################################################

DOC> The following statement will cause an "ORA-01722: invalid number"

DOC> error if the database server version is not correct for this script.

DOC> Perform "ALTER SYSTEM CHECKPOINT" prior to "SHUTDOWN ABORT", and use

DOC> a different script or a different server.

DOC>######################################################################

DOC>######################################################################

DOC>#

SELECT TO_NUMBER('MUST_BE_11_2') FROM v$instance

*

ERROR at line 1:

ORA-01722: invalid number

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Please help ASAP as this is a production system.

Thanks,

Prabhakar

Edited by: prabhakaryc on Jun 19, 2011 2:47 PM