Home » RDBMS Server » Server Administration » how to remove an oracle instance where two instances are there (oracle 10g,win xp)  () 1 Vote
how to remove an oracle instance where two instances are there [message #420935] Thu, 03 September 2009 06:27 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
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.
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 Go to previous messageGo to next message
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
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 Go to previous message
BlackSwan
Messages: 24903
Registered: January 2009
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.
Previous Topic: Unable to extend table
Next Topic: problem after installing ASM instance
Goto Forum:
  


Current Time: Sat Sep 24 23:10:27 CDT 2016

Total time taken to generate the page: 0.13370 seconds