Skip to Content
0
Former Member
Sep 13, 2011 at 05:31 AM

Oracle 11g upgrade

179 Views

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