Home » RDBMS Server » Server Administration » reg database UPGRADE...!!!!
reg database UPGRADE...!!!! [message #350988] Sun, 28 September 2008 17:52 Go to next message
dbareddy
Messages: 7
Registered: August 2008
Junior Member
Hi,
i'm upgrading my database from 1og--->11g, i checked for any INVALID objects, installed 11g software, ran UPGRADE utility utlu111i.sql and gathered statistics on oracle 10g database.
And by setting environmental settings oracle_home and sid I connected to oracle 11g database and started the database in STARTUP UPGRADE mode.And when i run,
SQL>@?/rdbms/admin/catupgrd.sql, i got the err:

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> Shutdown ABORT and use a different script or a different server.
DOC>######################################################################
DOC>######################################################################
DOC>#
SELECT TO_NUMBER('MUST_BE_11_1') FROM v$instance
*
ERROR at line 1:
ORA-01722: invalid number


Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

please help me out, reg. this issue.
Thanks in advance
Re: reg database UPGRADE...!!!! [message #350989 is a reply to message #350988] Sun, 28 September 2008 18:57 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Are you sure you set the ORACLE_HOME to the 11g home? What is the output of the following:

env | grep ORA
Previous Topic: To find which session has high usage for a specific database
Next Topic: ORA-00600
Goto Forum:
  


Current Time: Thu Dec 08 22:31:58 CST 2016

Total time taken to generate the page: 0.11092 seconds