Home » RDBMS Server » Server Administration » oracle database login error (oracle 10g server (10.2.0), win XP sp-2)
oracle database login error [message #554508] Tue, 15 May 2012 00:54 Go to next message
pradhan12march
Messages: 3
Registered: February 2012
Junior Member
Hello Sir

I have installed oracle 10g server (10.2.0) standard. My OS is win xp sp-2.

when I run sqlplus or toad,
Error Message comes ORA-01033: ORACLE initialization or shutdown in progress.

I have done below steps

in command prompt: C:\sqlplus/nolog

sql:> connect system/admin (this is my database username/pass)
Error
ORA-01033: ORACLE initialization or shutdown in progress

sql:> shutdown immediate
not connected
database closed
notconnected
database dismounted
ORA-01012 not logged on

sql:> Startup
01031: insufficient privilegs

not success. till error message comes

if any solution pls mail me. How to recovery my database.
Re: oracle database login error [message #554509 is a reply to message #554508] Tue, 15 May 2012 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Connect "/ as sysdba" and query v$database and v$instance.
SYS is the only account that can connect when database is not open.

Regards
Michel
Re: oracle database login error [message #554540 is a reply to message #554508] Tue, 15 May 2012 05:59 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Login as /as syssdba and then startup force.

If you are facing any issues check the logfile to see why the startup/shutdown is hanging?

Thanks
Ridhi
Re: oracle database login error [message #554541 is a reply to message #554509] Tue, 15 May 2012 06:00 Go to previous messageGo to next message
pradhan12march
Messages: 3
Registered: February 2012
Junior Member
thanks for reply mr michel,
after connect as sysdba,
what i done i can't understand through your post,
pleas help me.
Re: oracle database login error [message #554543 is a reply to message #554540] Tue, 15 May 2012 06:10 Go to previous messageGo to next message
pradhan12march
Messages: 3
Registered: February 2012
Junior Member
thanks for reply
after connect as sysdba we got a error-message
lrm-00109 could not open parameter
Re: oracle database login error [message #554545 is a reply to message #554543] Tue, 15 May 2012 07:12 Go to previous message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read and watch
Database 2 Day DBA
Oracle DBA Lite

You must know the basic before managing an Oracle database.

Regards
Michel
Previous Topic: insufficient privileges
Next Topic: block corruption, segment not found
Goto Forum:
  


Current Time: Wed Apr 14 18:33:00 CDT 2021