OraFAQ Forum: Unix » oracle

Home » Infrastructure » Unix » oracle_home error (AIX 5.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle_home error [message #312358]

Tue, 08 April 2008 11:55

talashil
Messages: 8
Registered: April 2008

Junior Member

I have symbolic link as oracle_home --> /opt/oracle/10.2

and in the ora_env.sh to check for verion , I have code like this

if [ "$version" = "" ]; then
ORACLE_HOME=/opt/oracle/oracle_home;
else
ORACLE_HOME=$version
fi
export ORACLE_HOME

when I run cron job , it is taking oracle home as /opt/oracle/oracle_home ?

any ideas .

Thanks

Report message to a moderator

Re: oracle_home error [message #312359 is a reply to message #312358]

Tue, 08 April 2008 12:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when cron invokes the script, $version is not set.

at the top of any script you can add the following line

env | sort -o /tmp/my.env

after the script runs you can look at the contents of /tmp/my.env
to see which environmental variables exist & to what value they are set.

Report message to a moderator

Re: oracle_home error [message #312361 is a reply to message #312358]

Tue, 08 April 2008 12:22

talashil
Messages: 8
Registered: April 2008

Junior Member

hey Thanks for the reply.

My question is when cron job is running ,why ism't taking symbolic value into /opt/oracle/oracle_home

if I do :

echo $ORACLE_HOME
/opt/oracle/10.2

and cron value is showing as ,

ORACLE_HOME=/opt/oracle/oracle_home

Thanks

Report message to a moderator

Re: oracle_home error [message #312362 is a reply to message #312358]

Tue, 08 April 2008 12:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I have symbolic link as oracle_home --> /opt/oracle/10.2
This statement makes NO sense.

a symbolic (soft) link is created by

ln -s <real_file> <pseudo_name>

Oracle does NOT know or care about your symbolic link.
cron does NOT invoke .bash_profile or similar file automatically.
In a script invoked by cron, if you want your environmental variables establish source in the appropriate file to do so.

Report message to a moderator

Previous Topic:	Tail Command
Next Topic:	Performance Issue on Sun Sloaris - Maybe Unix or Hardware Option ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 30 15:28:39 CDT 2023