OraFAQ Forum: Server Administration » oracle database login error

Home » RDBMS Server » Server Administration » oracle database login error (oracle 10g server (10.2.0), win XP sp-2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle database login error [message #554508]

Tue, 15 May 2012 00:54

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.

Report message to a moderator

Re: oracle database login error [message #554509 is a reply to message #554508]

Tue, 15 May 2012 01:00

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: oracle database login error [message #554540 is a reply to message #554508]

Tue, 15 May 2012 05:59

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

Report message to a moderator

Re: oracle database login error [message #554541 is a reply to message #554509]

Tue, 15 May 2012 06:00

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.

Report message to a moderator

Re: oracle database login error [message #554543 is a reply to message #554540]

Tue, 15 May 2012 06:10

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

Report message to a moderator

Re: oracle database login error [message #554545 is a reply to message #554543]

Tue, 15 May 2012 07:12

Michel Cadot
Messages: 68641
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

Report message to a moderator

Previous Topic:	insufficient privileges
Next Topic:	block corruption, segment not found

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 03:56:39 CDT 2024