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:
Operating System: Windows Server 2003

i made a mistake by changing the parametrer COMPATIBLE='9.2.0' in oracle version

after restarting DB SERVER, i m getting the following error
SQL> conn sys/gateway@testdb as sysdba

SQL> conn scott/tiger@testdb
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 incompatible with ORACLE version

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: 65155
Registered: March 2007
Location: Nanterre, France, http://...
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)


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
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: oracle startup and shutdown
Next Topic: How release space on tablespace PERFSTAT
Goto Forum:

Current Time: Wed Aug 23 22:11:43 CDT 2017

Total time taken to generate the page: 0.05849 seconds