OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » database shutdown

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

database shutdown [message #146528]

Thu, 10 November 2005 22:25

nitin_228
Messages: 29
Registered: May 2005
Location: RICHMOND, VA

Junior Member

Hi I had a database up and running in single user
environment . I shutdown the database with the
shutdown option.

I did not do any shutdown immediate or shutdown abort.
It has stuck for ever. I believe it has some uncommitted
transaction.

Now i guess with that the database would never shutdown.
I can't log onto the database by opening another session
as it says database shutdown in progress.

What should i do??

Thanks,
Nitin

Report message to a moderator

Re: database shutdown [message #146536 is a reply to message #146528]

Thu, 10 November 2005 23:12

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Didnt mention the OS version,

if using Windows ---

Close window service related to oracle and start again ,
then try to start the database.

if using *Unix --

kill all the processes related to Oracle and then try to start again.

Report message to a moderator

Re: database shutdown [message #146546 is a reply to message #146528]

Thu, 10 November 2005 23:59

nitin_228
Messages: 29
Registered: May 2005
Location: RICHMOND, VA

Junior Member

Thanks for the reply . I killed the oracle process. But after that i am not able to log on. It says

ERROR:
ORA-12500: TNS:listener failed to start a dedicated server process

I am on windows xp and oracle 9i

Thanks,
Nitin

Report message to a moderator

Re: database shutdown [message #146547 is a reply to message #146546]

Fri, 11 November 2005 00:04

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Did u restart the service again?

Are you using Net service to login?

Is listener up and running?

check and post again.

Report message to a moderator

Re: database shutdown [message #146602 is a reply to message #146547]

Fri, 11 November 2005 07:04

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

hai tarun ... tell nitin to restart his xp machine on which oracle database is present ... i think he is very new to oracle database.... as he had killed process of oracle from his machine .. It will be better for him to restart his xp machine on which database is present.. and after restart of machine if his service is not started (i.e. it is not in automatic mode) then nitin has to start the service related to his database from his control pannel.

Regards
Always Friend Sunilkumar

Report message to a moderator

Re: database shutdown [message #146607 is a reply to message #146602]

Fri, 11 November 2005 07:28

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Sunil_V_Mishra wrote:
>>hai tarun ... tell nitin to ....

Was that an intended 'private message' ?
If so, i am sorry, I read it.
Just kidding.

Laughing

Report message to a moderator

Previous Topic:	ora-00980 urgent thanks
Next Topic:	Its on Clonning...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 12:44:17 CST 2025