Home » RDBMS Server » Server Administration » upgrade from 9.2 to 10.2 failed. how do i downgrade and then make sure it upgrades properly next tim (SUN solaris; 9i to 10g.)
upgrade from 9.2 to 10.2 failed. how do i downgrade and then make sure it upgrades properly next tim [message #302074] Sat, 23 February 2008 00:49 Go to next message
geeklol
Messages: 59
Registered: March 2005
Member
on sun solaris, i was manually upgrading oracle db from 9.2 to 10.2.
i already have the 10g binaries installed. i have the new init file with all the required parameters like,
session_max_open_files=20
compatible=10.2.0
log_archive_format='arch_%t_%s.arc'
streams_pool_size=50331648

comment out deprecated parameters:
LOG_ARCHIVE_START
MAX_ENABLED_ROLES
UNDO_SUPPRESS_ERRORS
LOG_PARALLELISM


then i create the sysaux tablespace, i upgraded the db using @catupgrd.sql.

The spool never finished because towards the end it said, not connected to the database and it asked me value for xlb... or something like that (like i said the spool never finished) and then the upgrade process stopped.

when i run the following, it says upgrade incomplete.
Any idea's?? first of, how do i go back to 9i? and then what do i do different the next time to make sure that it upgrades properly? should i use dbua instead?

SQL> @utlu102s
.
.
Oracle Database 10.2 Upgrade Status Utility 02-22-2008 22:36:28
.
Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.1.0 00:37:06
JServer JAVA Virtual Machine VALID 10.2.0.1.0 00:15:39
Oracle XDK VALID 10.2.0.1.0 00:01:29
Oracle Database Java Packages VALID 10.2.0.1.0 00:01:07
Oracle Text VALID 10.2.0.1.0 00:01:29
Upgrade Incomplete
Re: upgrade from 9.2 to 10.2 failed. how do i downgrade and then make sure it upgrades properly next [message #302078 is a reply to message #302074] Sat, 23 February 2008 01:05 Go to previous messageGo to next message
geeklol
Messages: 59
Registered: March 2005
Member
when i try to downgrade, do i need to make changes to the init file? which init file do i use(9i ot 10g) when i do STARTUP DOWNGRADE pfile= ?? when i use the 10g init file, it gives me the following error.

SQL> startup downgrade pfile=/usr/local/oracle/10.2.0/dbs/initlcecqa05.ora
ORACLE instance started.

Total System Global Area 889192448 bytes
Fixed Size 1982736 bytes
Variable Size 465575664 bytes
Database Buffers 419430400 bytes
Redo Buffers 2203648 bytes
Database mounted.
Database opened.
SQL> @catdwgrd.sql

PL/SQL procedure successfully completed.

Function created.
Function dropped.

DECLARE
*
ERROR at line 1:
ORA-39707: compatibile parameter 10.2.0 too high for downgrade to 9.2.0
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at line 14


-----------------------------------------

when i use the 9i init file, it gives me the following error?

SQL> connect / as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> shutdown downgrade pfile=/usr/local/oracle/9.2.0/dbs/initlcecqa05.ora
SP2-0717: illegal SHUTDOWN option
SQL> startup downgrade pfile=/usr/local/oracle/9.2.0/dbs/initlcecqa05.ora
ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated
ORA-32006: MAX_ENABLED_ROLES initialization parameter has been deprecated
ORA-25138: UNDO_SUPPRESS_ERRORS initialization parameter has been made obsolete
ORACLE instance started.

Total System Global Area 838860800 bytes
Fixed Size 1982352 bytes
Variable Size 415236208 bytes
Database Buffers 419430400 bytes
Redo Buffers 2211840 bytes
ORA-00600: internal error code, arguments: [kccrhd_csq], [13238827], [0], [],
[], [], [], []
Re: upgrade from 9.2 to 10.2 failed. how do i downgrade and then make sure it upgrades properly next [message #302081 is a reply to message #302074] Sat, 23 February 2008 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't downgrade below the highest value of COMPATIBLE you ever set.
Here you can't downgrade below 10.2.
Nothing to do but restart from a backup.

Regards
Michel
Re: upgrade from 9.2 to 10.2 failed. how do i downgrade and then make sure it upgrades properly next [message #302110 is a reply to message #302074] Sat, 23 February 2008 11:58 Go to previous messageGo to next message
geeklol
Messages: 59
Registered: March 2005
Member
Is there anyway, i can make the 10.2 instance work?

meaning, make this valid?

Oracle Database Server INVALID 10.2.0.1.0 00:37:06
Re: upgrade from 9.2 to 10.2 failed. how do i downgrade and then make sure it upgrades properly next [message #302111 is a reply to message #302110] Sat, 23 February 2008 12:07 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Analyze the spool you have.
You have not, restart from a backup, spool the upgrade and analyze why there are errors (if there are).
Above all, strictly follow the prerequisites before the upgrade.

Regards
Michel
Previous Topic: want to upgrade Oracle9i Enterprise Edition Release 9.0.1.1.1
Next Topic: ORA-00054: resource busy and acquire with NOWAIT specified.
Goto Forum:
  


Current Time: Fri Dec 09 00:28:46 CST 2016

Total time taken to generate the page: 0.09716 seconds