OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-1033 error.

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

ORA-1033 error. [message #58971]

Sun, 19 October 2003 20:58

Sonali
Messages: 3
Registered: May 2002

Junior Member

We have oracle 9i installed on windows 2000
at our work place.
Today i got the Message
ORA-1033 oracle logon or shut down in Progress
I then took a shutdown of the server but unable to logon oracle.
Pl suggest what do i do ?
Will my Data get lost?

Report message to a moderator

Re: ORA-1033 error. [message #58973 is a reply to message #58971]

Mon, 20 October 2003 02:01

Maaher
Messages: 7065
Registered: December 2001

Senior Member

If you shut down your Oracle, it is normal that you can't log on.

Open SQL*Plus and connect sys as sysdba and start the database up again.

Your data will not get lost.

Or you could start the Oracle services yourself.

Right click on My Computer and select "manage". In the MMC select "Services". The Oracle Listener should be running, as well as the Oracle Agent and the Oracleservice that contains the SID of your database.

MHE

Report message to a moderator

Re: ORA-1033 error. [message #61074 is a reply to message #58971]

Thu, 25 March 2004 19:34

Janaka
Messages: 2
Registered: March 2004

Junior Member

Check the listner connectivity.
Restore u'r last backup and then check.

Report message to a moderator

Previous Topic:	OCI files missing
Next Topic:	URGENT - Fatal NI Connection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 21:25:19 CST 2025