Home » Infrastructure » Unix » Scripts to change environment
Scripts to change environment [message #240029] Wed, 23 May 2007 23:55 Go to next message
*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 #240289 is a reply to message #240029] Thu, 24 May 2007 09:50 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
by using editor of choice to acquire desired environmental values
Re: Scripts to change environment [message #240365 is a reply to message #240289] Thu, 24 May 2007 12:30 Go to previous message
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
Previous Topic: calling procedure in unix shell script-1
Next Topic: Steps for upgradation from 10.1.0.4 to 10.2.0.2
Goto Forum:
  


Current Time: Thu Mar 28 12:29:12 CDT 2024