ORA-01033 ORACLE error

[jcck2003]

Hi All:

I cannot get into Oralce 9i we have using SQLplus this morning, its tell me I have a

ORA-01033 ORACLE initialization or shutdown in progress in 9i

error, how to even trouble shoot this if I can't get into the command ?

Thanks
J

 

[Turkbear]

Hi,
First, connect 'AS SYSDBA' ( the 9i way of connecting internal) - try a shutdown abort, followed by startup restricted, shutdown immediate, startup...)
If that will not work:
Depending on your OS, execute whatever command is needed to stop the Oracle service(s)..( If Windows, use the services manager, if Unix-flavored use a Kill command after a ps to find the Oracle ones)..

Then try a startup again...
( If Windows-based, do a reboot between stop and restart)

 

[acct98]

Can someone please explain this:

( If Windows-based, do a reboot between stop and restart)

 

[avjoshi]

If the database is on Microsoft Windows based system (Windows NT/2000) reboot your windows server after initial database shutdown. This is just to make sure that there are no zombie processes or uncleared memory segments.

Hope this helps.

Anand.

 

[acct98]

I tried that and I am estill getting the ora-01033 error.

It will not let me connect to the database

Any Ideas?

 

[acct98]

I did a little research:

Can anyone tell me how to create a password file?
Create password file again...

Follow the steps:

set oracle_sid=sid
net stop oracleservicesid
del c:\oracle\ora81\database\pwdsid.ora
orapwd file=c:\oracle\ora81\database\pwdsid.ora password=..... entries=5
net start oracleservicesid

 

[acct98]

Here is the verdict:

Version of Oracle: 9I
Operating System: Windows XP
Database: External HD

I could not log into the database. I restored [START>PROGRAMS>ACCESSORIES>SYSTEM TOOLS>SYSTEM RESTORE] the system to a previous date an now the problem has been corrected. GO FIGURE!

I hope this!