Home » RDBMS Server » Server Administration » ORA-00201:While trying to mount DB
ORA-00201:While trying to mount DB [message #276414] Thu, 25 October 2007 02:09 Go to next message
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
Re: ORA-00201:While trying to mount DB [message #276425 is a reply to message #276414] Thu, 25 October 2007 02:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
SQL> create pfile from spfile;
SQL> shutdown
SQL> !vi <pfile> and change compatible
SQL> startup nomount pfile=...
SQL> create spfile from pfile;
SQL> shutdown
SQL> startup (connected as SYS)

Regards
Michel

Re: ORA-00201:While trying to mount DB [message #276428 is a reply to message #276414] Thu, 25 October 2007 02:25 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I was expecting this error from you after seeing a post in Streams section.
Previous Topic: ORA-12801 error
Next Topic: oracle startup and shutdown
Goto Forum:
  


Current Time: Sat Dec 14 16:01:23 CST 2024