OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » helpme please

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

helpme please [message #61188]

Mon, 05 April 2004 00:06

gabriel garcia
Messages: 1
Registered: April 2004

Junior Member

aid to solve to the error 0ra-01033

Report message to a moderator

Re: helpme please [message #61189 is a reply to message #61188]

Mon, 05 April 2004 00:26

Anatol Ciolac
Messages: 113
Registered: December 2003

Senior Member

SQL>shutdown abort
SQL>startup
This is only way.

Report message to a moderator

Re: helpme please [message #61190 is a reply to message #61188]

Mon, 05 April 2004 00:27

sanu
Messages: 6
Registered: April 2004

Junior Member

You may be having a duplicate SID/SID mismatch in the listener file/Oracle Home. So check its entries in the listner file and Oracle Home.

You are getting this error as the listener process is trying to connect to oracle is not mounted properly.
Sanu

Report message to a moderator

Re: helpme please [message #61254 is a reply to message #61188]

Wed, 07 April 2004 22:51

rakesh
Messages: 25
Registered: March 2001

Junior Member

may be shutdown of database is in progress but some other user is logged in the databse or some process is going on which is taking time
as suggested by anatol
user options
sql> shutdown abort
sql>startup

Report message to a moderator

Re: helpme please [message #61255 is a reply to message #61254]

Wed, 07 April 2004 23:02

Anatol Ciolac
Messages: 113
Registered: December 2003

Senior Member

For preventing this situation in future stop your database with immediate option:
SQL>shutdown immediate

Report message to a moderator

Previous Topic:	dump-import
Next Topic:	Briefly explain Schema in oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 15 22:32:52 CST 2025