Oracle 8i and 9i on the same unix server [message #50816] |
Tue, 09 April 2002 06:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Sharon
Messages: 10 Registered: February 2001
|
Junior Member |
|
|
Hi,
Can any one tell me how to automate the database start and shutdown for two different databases on the same server.
We have Oracle 8i and 9i on the same server(Sun Solaris) under two different unix users, with different ORACLE_HOMES. I am trying to set up dbstart and dbshut to work for both the databases from any user.
Any Clues ! would be most appreciated..
Thanks in advance.
Sharon
|
|
|
Re: Oracle 8i and 9i on the same unix server [message #50820 is a reply to message #50816] |
Tue, 09 April 2002 07:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
Never done that before. I have always used the same oracle user for all DB's and oracle homes. You might think about doing the same. It is a lot easier. But if you have to do it that way you could create your own startup/shutdown files (based on dbstart/dbstop) and getting ORACLE_HOME from you oratab file do something like:
if [[ "$ORACLE_HOME" = 'FULL_9i_HOME_PATH' ]] ; then
ORACLEUSER="oracle9"
su - $ORACLEUSER -c ...
fi
Good luck.
|
|
|