ORA-01033 Oracle initialisation or shutdown in progress Error

[thebull1]

Hi All.
Im running an Oracle Release 9.2.0.1.0 database on my PC. (Windows XP). It has been perfect for a long time, but now every time I try to log in I get the error "ORA-01033: ORACLE initialization or shutdown in progress", and I cannot log in.
Kindly assist. Situation getting desperate.

Thanks.

 

[thebull1]

Things get worse here!! I cannt oeven mount the database now.. Think something is wating my database at night....

SQL> startup mount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown abort
ORACLE instance shut down.
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
ORA-01991: invalid password file 'f:\oracle\ora92\DATABASE\PWDspms2.ORA'

 

[thebull1]

Things get worse here!! I cannt even mount the database now.. Think something is wating my database at night....

SQL> startup mount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown abort
ORACLE instance shut down.
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
ORA-01991: invalid password file 'f:\oracle\ora92\DATABASE\PWDspms2.ORA'

 

[SantaMufasa]

Bull,

To get past your current error:

1) cd f:\oracle\ora92\DATABASE
2) erase PWDspms2.ORA
3) f:\oracle\ora92\bin\orapwd file=PWDspms2.ora entries=2 password=<your password for SYS>
4) retry your "shutdown abort...startup..." sequence.

Post your results here.


Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[thebull1]

Bravo. I ahve now managed to bypass that previous hiccup, and gone back to what KenCunningham had proposed earlier. I wans only able to alter database backup controlfile using a .CTL file that did not exist (see script). After that I issued alter database open resetlogs which now has a new error. See attached script:-

SQL> alter database backup controlfile to 'F:\oracle\oradata\spms2\CONTROL02.CTL
';
alter database backup controlfile to 'F:\oracle\oradata\spms2\CONTROL02.CTL'
*
ERROR at line 1:
ORA-00222: operation would reuse name of a currently mounted controlfile
ORA-00202: controlfile: 'f:\oracle\oradata\spms2\CONTROL02.CTL'


SQL> alter database backup controlfile to 'F:\oracle\oradata\spms2\CONTROL03.CTL
';
alter database backup controlfile to 'F:\oracle\oradata\spms2\CONTROL03.CTL'
*
ERROR at line 1:
ORA-00222: operation would reuse name of a currently mounted controlfile
ORA-00202: controlfile: 'f:\oracle\oradata\spms2\CONTROL03.CTL'


SQL> alter database backup controlfile to 'F:\oracle\oradata\spms2\CONTROL04.CTL
';

Database altered.

SQL> SHUTDOWN ABORT
ORACLE instance shut down.
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> alter database open resetlogs ;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL>

 

[thebull1]

Thanks All for your kind assistance..
I have since extracted a previous copy fo the database from a dump,and am slowly reconstructing all the changes that I had made since the previous extraction.
Important lessons learn, and like Musafa advised, Iwas S.O.L. (Surely Out Of Luck). I will be creating a bcakup of any database I have, however small.

Thanks again guys. Im not a DBA, but I already feel like one now..