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 Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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], [],
[], [], [], []
|
|
|
|
|
|