OraFAQ Forum: Server Administration » how to remove an oracle instance where two instances are there

Home » RDBMS Server » Server Administration » how to remove an oracle instance where two instances are there (oracle 10g,win xp) (

) 1 Vote

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

how to remove an oracle instance where two instances are there [message #420935]

Thu, 03 September 2009 06:27

rajasekhar857
Messages: 500
Registered: December 2008

Senior Member

hi iam having two instances where orcl and orcl1 available in oracle 10g,windows xp.now orcl is causing some problems and is not working with exception "oracle initialisation or shutdown in progress".now i dont want that instance as i can able to do operations with orcl1.how can i remove the instance orcl which is causing problems for me.suggest me please

[Updated on: Thu, 03 September 2009 06:28]

Report message to a moderator

Re: how to remove an oracle instance where two instances are there [message #420937 is a reply to message #420935]

Thu, 03 September 2009 06:45

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

Senior Member
Account Moderator

set your ORACLE_SID.
Login as sys.
Shutdown.
If required remove all the associated datafiles/controlfiles/logfiles etc.

Report message to a moderator

Re: how to remove an oracle instance where two instances are there [message #421984 is a reply to message #420937]

Sat, 12 September 2009 12:40

oragun
Messages: 2
Registered: September 2009

Junior Member

hey mahesh can you please detail it a little bit more.
Me having the same trouble.
I'm new to this
Regards

Report message to a moderator

Re: how to remove an oracle instance where two instances are there [message #421986 is a reply to message #421984]

Sat, 12 September 2009 12:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Your answers are just a few clicks beyond the URL below.
http://tahiti.oracle.com
Let us know when you have found your answer.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

Report message to a moderator

Previous Topic:	Unable to extend table
Next Topic:	problem after installing ASM instance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 17:02:59 CST 2024