Dear Friends,
Thanks for yours valuable help for my all queries.
I am upgrading Oracle 11g on my APO test server.
Previously It was on HP-UX 11 i v2 and Oracle 10.2.0.2.
Now We have upgraded OS 11i v3 and Oracle 10.2.0.4. SAP application is runing fine.
Now I have started to upgrade Oracle 11g from Oracle 10.2.0.4. I have installed Oracle 11g software and new Oralce home /oracle/DVP/11202 has been created and I have strted upgrade and getting the error below.
jkeccbc:oradvp 2> setenv ORACLE_HOME /oracle/DVP/11202
jkeccbc:oradvp 3> setenv ORACLE_SID DVP
jkeccbc:oradvp 4> setenv PATH /oracle/DVP/11202/bin:$PATH
jkeccbc:oradvp 5> setenv TNS_ADMIN /oracle/DVP/11202/network/admin
jkeccbc:oradvp 6>
SQL> startup upgrade
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area
5845950464 bytes
Fixed Size
2191760 bytes
Variable Size
2936016496 bytes
Database Buffers
2902458368 bytes
Redo Buffers
5283840 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL>
SQL> spool patch.log
SQL> @/oracle/DVP/11202/rdbms\admin\catupgrd.sql
SP2-0310: unable to open file "/oracle/DVP/11202/rdbmsadmincatupgrd.sql"
SQL> @/oracle/DVP/11202/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> Perform "ALTER SYSTEM CHECKPOINT" prior to "SHUTDOWN ABORT", and use
DOC> a different script or a different server.
DOC>######################################################################
DOC>######################################################################
DOC>#
no rows selected
DOC>#######################################################################
DOC>#######################################################################
DOC> The following statement will cause an "ORA-01722: invalid number"
DOC> error if the database has not been opened for UPGRADE.
DOC>
DOC> Perform "ALTER SYSTEM CHECKPOINT" prior to "SHUTDOWN ABORT", and
DOC> restart using UPGRADE.
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SELECT TO_NUMBER('MUST_BE_OPEN_UPGRADE') FROM v$instance
*
ERROR at line 1:
ORA-01722: invalid number
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
jkeccbc:oradvp 7> spool off
spool: Command not found.
jkeccbc:oradvp 8> sqlplus "/as sysdba'
Unmatched ".
jkeccbc:oradvp 9> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 13 10:30:21 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> spool off
not spooling currently
SQL> shutdown
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area
5845950464 bytes
Fixed Size
2191760 bytes
Variable Size
2936016496 bytes
Database Buffers
2902458368 bytes
Redo Buffers
5283840 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL>
Regards
Ganesh Datt Tiwari