Home » Infrastructure » Unix » How do i run 2 databases on one Host in Unix platform
How do i run 2 databases on one Host in Unix platform [message #98019] Tue, 11 November 2003 23:37 Go to next message
Messages: 2
Registered: November 2003
Junior Member
Hi everybody,

The problem is when i start running two Databases
on one host machine in unix enviornment(linux),
it will restrict the second database to run,saying
the database instance is already start-running in progress.The second database unable to start on same
machine in linux environment.
But if i do the same excercise on NT platform,it will be done successfully.What should i do in unix platform?
Please let me know the solution,that would be appreciated.

Regards......ALI (DBA)
e-mail itpkdoc2003@yahoo.com
Re: How do i run 2 databases on one Host in Unix platform [message #98021 is a reply to message #98019] Wed, 12 November 2003 05:43 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
in unix,
to startup / shutdown multiple database in the same box, you have to set ORACLE_SID, ORALCE_HOME everytime and do the startup shutdown.
to avoid this pain, oracle for unix installations will carry a file called oratab.
just edit the file to add the appropriate entries in oratab, set ur TNS_ADMIN .
this oratab will be called from $ORACLE_HOME/bin/dbstart and $ORACLE_HOME/bin/dbshut scripts which will startup and shutdown all the oracle databases that have an entry in oratab file.

Previous Topic: Installing Oracle 9i on unix box
Next Topic: Oracle 9iAS is using Port 8080
Goto Forum:

Current Time: Sat Jan 16 12:11:35 CST 2021