Home » RDBMS Server » Server Administration » 2 ORACLE_SID'S ON ONE MACHINE
icon5.gif  2 ORACLE_SID'S ON ONE MACHINE [message #123456] Mon, 13 June 2005 09:59 Go to next message
kagishom
Messages: 2
Registered: June 2005
Junior Member
I have installed two INSTANCES in one machine. On restarting the machine it can only start one instance that is defined in the enviromental variables. But because I cannot define two ORACLE_SID'S under enviromental variables I have to manually redefine it to the second instance before I can start it's emctl file. Can you please tell me how to set up Win 2003 Server to automaticly start two instances without redifining the second instance manuallY????
Re: 2 ORACLE_SID'S ON ONE MACHINE [message #123458 is a reply to message #123456] Mon, 13 June 2005 10:07 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Create seperate services for the instances using ORADIM.
after creating the services, goto control panel / services, select the services and set the properties to autostart.
http://orafaq.com/faqwinnt.htm#autostart
or
write a little script thingie that would manually bring the database up.
http://www.orafaq.com/faq/Operating_Systems/Windows/faq349.htm
http://orafaq.com/scripts/win/ntserv.txt
Previous Topic: Search in kdisti
Next Topic: oracle 10g
Goto Forum:
  


Current Time: Fri Jan 10 07:26:09 CST 2025