| Downgrade Oracle 9.2.0.6 to 9.2.0.1 error (ORA-00600) [message #151238] |
Tue, 13 December 2005 21:54  |
george.wei
Messages: 4
Registered: October 2005
|
Junior Member |
|
|
Dear all,
I've installed Oracle 9201 on a Windows 2000 Advanced Server. The target installation folder is D:\Oracle, all data files are stored in D:\Oracle\oradata. Then I tried to upgrade this installatiion to 9206. Before installing PatchSet 9206, I've stopped all Oracle NT services, then I've copied the whole directory tree of D:\Oracle to another place. After succeeded installing the patch set and upgrading the database, the I want to restore the test environment to the original status. These steps are
1.Stop all Oracle related NT services, succeeded
2.Restore all backed up files to their original place, succeeded
3.Start Oracle database instance service, succeeded
4.Start Oracle listener service, succeeded
5.Use sql plus connect to the database, FAILED
SQL> conn user/password@db_server
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
6.Use sql plus connect to the database as SYSDBA, succeeded
7.Use sql plus to SHUTDOWN the database, succeeded
8.Use sql plus to STARTUP the database, FAILED
SQL> startup
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [], [], [], []
What's the problem? Did I miss some necessary steps to backup the system before installing the patch set? What can I do to prevent this error when I restore the database if the upgrading process fails? Thanks for any help.
Regards,
George
|
|
|
|
| Re: Downgrade Oracle 9.2.0.6 to 9.2.0.1 error (ORA-00600) [message #151313 is a reply to message #151238] |
Wed, 14 December 2005 04:02  |
george.wei
Messages: 4
Registered: October 2005
|
Junior Member |
|
|
This error is fixed by recovering database:
SQL>conn / as sysdba
SQL> startup mount
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> recover database;
Media recovery completed.
SQL> alter database open;
Database altered.
SQL>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
