| ORA-00201:While trying to mount DB [message #276414] |
Thu, 25 October 2007 02:09  |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
Dear All,
Oracle Version: 10.1.0.2.0
Operating System: Windows Server 2003
i made a mistake by changing the parametrer COMPATIBLE='9.2.0' in oracle version 10.1.0.2.0
ALTER SYSTEM SET COMPATIBLE='9.2.0' SCOPE=SPFILE;
after restarting DB SERVER, i m getting the following error
SQL> conn sys/gateway@testdb as sysdba
Connected.
SQL> conn scott/tiger@testdb
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Warning: You are no longer connected to ORACLE.
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00201: controlfile version 10.0.0.0.0 incompatible with ORACLE version
9.2.0.0.0
ORA-00202: controlfile: 'D:\ORACLE\ORADATA\TESTDB\CONTROL01.CTL'
i think i have to recreate spfile by first starting the DB by using pfile
Can anybody give me some suggestions for that?
thanx in advance
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
