Scripts to change environment [message #240029] |
Wed, 23 May 2007 23:55 |
*Jess*
Messages: 48 Registered: December 2005 Location: Penang, Malaysia
|
Member |
|
|
Hi,
We have 2 instance under the same ORACLE_HOME. Whenever we login, we can choose from .oraenv command.
How to configure shutdown and startup database scripts to point to the correct instance?
Thanks.
|
|
|
|
Re: Scripts to change environment [message #240365 is a reply to message #240289] |
Thu, 24 May 2007 12:30 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
just see what environment variables .oraenv is setting and include those in your scripts for the 2 databases.
After running .oraenv, check your environment and compare for the 2 different databases. ORACLE_SID may be the only one changing.
do for each database:
.oraenv
env | sort > db_1.env.log
then just do a diff on db_1.env.log and db_2.env.log
|
|
|