on 06-19-2011 1:47 PM
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
Hi Prabhakar,
Check whether, you executed "catupgrd.sql" with the correct ORACLE_HOME directory.
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Orkun Gedik,
Thank you for your quick reply.
Yes i am running this on windows and i have set with correct ORACLE_HOME (11202 directory)
Do you think any other reason ?
I have seen this error log inside of catupgrd.sql and it seems to be very known error but i am not finding the solution anywhere ?
Your quick reply helps me a lot.
Thanks,
Prabhakar
Hi Orkun Gedik,
>
> Thank you for your quick reply.
>
> Yes i am running this on windows and i have set with correct ORACLE_HOME (11202 directory)
>
> Do you think any other reason ?
>
> I have seen this error log inside of catupgrd.sql and it seems to be very known error but i am not finding the solution anywhere ?
>
> Your quick reply helps me a lot.
>
> Thanks,
> Prabhakar
Hi Prabhakar,
>> DBUA was disconnected with error Ora 1092 Oracle instance terminated.
But, as far as I understand that you didn't completed DB upgrade succesfully. Under this circumstance, you shouldn't change ORACLE_HOME variable to 11.2.0.2. I suggest you that complete Oracle upgrade (restart DBUA) and do not execute upgrade procedures, manually.
Best regards,
Orkun Gedik
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.