OraFAQ Forum: Server Administration » Out of 2 Database only one is running

Home » RDBMS Server » Server Administration » Out of 2 Database only one is running

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

Out of 2 Database only one is running [message #173258]

Sun, 21 May 2006 02:47

mkp123
Messages: 2
Registered: May 2005

Junior Member

Hi All,
I am having two database TOSDB , PRDNDB.
After startup only TOSDB is running.
While trying to enter PRDNDB its giving error.
ORA-01033 : Oracle initialization or shutdown in progress

Need help with steps.

Thanks

Report message to a moderator

Re: Out of 2 Database only one is running [message #173281 is a reply to message #173258]

Sun, 21 May 2006 06:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> CONNECT AS / AS SYSDBA
SQL> SHUTDOWN ABORT
SQL> STARTUP

Report message to a moderator

Re: Out of 2 Database only one is running [message #173295 is a reply to message #173281]

Sun, 21 May 2006 10:20

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Just to avoid "it won't work" post ... this would be correct syntax:

SQL> CONNECT / AS SYSDBA

Report message to a moderator

Re: Out of 2 Database only one is running [message #173318 is a reply to message #173258]

Sun, 21 May 2006 16:20

itman73
Messages: 6
Registered: May 2006
Location: Dallas, Texas, USA

Junior Member

If you are indicating that after a server reboot, only one of two databases started up, check the problematic database's alert.log for the specific reason. There's always a reason ...

Report message to a moderator

Re: Out of 2 Database only one is running [message #173336 is a reply to message #173258]

Sun, 21 May 2006 23:18

chidellanr
Messages: 5
Registered: April 2006
Location: Hyderabad, India

Junior Member

Dear Pal
which OS are you working in Plse mention clearly.
if you are working in?

Report message to a moderator

Re: Out of 2 Database only one is running [message #179292 is a reply to message #173258]

Mon, 26 June 2006 14:55

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

If it is afte a reboot...check your oratab also.

on UNIX system

/etc/oratab

and make sure they are set to Y and u have 2 entries.

--
Sanjay

[Updated on: Mon, 26 June 2006 14:57]

Report message to a moderator

Previous Topic:	More DB on the same instance...
Next Topic:	ORA-27100: shared memory realm already exists

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:27:42 CDT 2024