OraFAQ Forum: Server Administration » Shutdown Oracle the Instance

Home » RDBMS Server » Server Administration » Shutdown Oracle the Instance (10.2 sun solaries 10)

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

Shutdown Oracle the Instance [message #384092]

Mon, 02 February 2009 02:59

reddyvijay09
Messages: 3
Registered: October 2007
Location: kl

Junior Member

Hi

My question is i want to shutdown the oracle instance and it should kill the remote and long running should also
using the inbuilt scripts it will kill and down the database is there anything is exist ?

not to using shutdown immediate
iam aware of kill the all remote sessions and down the db
that is not my requirement

Thank you

Report message to a moderator

Re: Shutdown Oracle the Instance [message #384101 is a reply to message #384092]

Mon, 02 February 2009 03:12

Frank
Messages: 7901
Registered: March 2000

Senior Member

So you want to shutdown the database and kill the running sessions.
You know that there are two ways of doing that: kill the session or shutdown abort, but you don't want to use either.

Why?

Report message to a moderator

Re: Shutdown Oracle the Instance [message #384108 is a reply to message #384092]

Mon, 02 February 2009 03:26

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What do you exactly want to do in which case?
If you don't want long query, does not allow them, for instance setting profiles.

Regards
Michel

Report message to a moderator

Previous Topic:	ora errors tables? (merged)
Next Topic:	Capacity Planning!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 13:42:43 CST 2024