My test working Environment;windows xp
current database:10.2.0.1
future database:11 release 1
same oracle sid;mytest
what I did;
1st Step
installed only software in 11g(there is no root.sh script pop up)
2nd Step
Run Script utlu111i.sql in current database.
there are a few warning message. i fixed some warning but
I leave WARNING: --> Database contains INVALID objects prior to upgrade.
WARNING: --> Database contains schemas with objects dependent on network
packages. I will fix it after posting upgrade
Applied patch p5731535_10203_WINNT for record new timzone.
3nd Step
move initmytest.ora and the password file from db_1/database in 10g to db_1/database in 11g
after that
$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Nov 3 09:29:49 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> startup upgrade pfile='C:\oracle\product\11.1.0\db_1\database\initmytest.ora'
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup upgrade pfile='C:\oracle\product\11.1.0\db_1\database\initmytest.or
a'
ORACLE instance started.
Total System Global Area 914358272 bytes
Fixed Size 1252160 bytes
Variable Size 230687936 bytes
Database Buffers 675282944 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
SQL> @c:\oracle\product\11.1.0\db_1\rdbms\admin\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.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
****login as / as sysdba check instance
SQL> select * from v$instance
2 /
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
1 mytest
JIMMY
10.2.0.1.0 03-NOV-10 OPEN MIGRATE NO 1 STOPPED
RESTRICTED NO ACTIVE PRIMARY_INSTANCE NORMAL NO
would you tell me what did i wrong?
Even log in as sysdba in 11g, still messaged is written,"Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options" still 10.2.0.1.0 not 11g release 1
ORA-01722: invalid number
sorry about insufficient information