| reg database UPGRADE...!!!! [message #350988] |
Sun, 28 September 2008 17:52  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
