Shell Programming and Scripting

Hi Ranjithpr,

Yes I am able to execute '/home/ivbbuild/tosh.sh' from any directory. Additionally I am able to execute:

Code:

/u01/app/oracle/product/9.0.1/bin/sqlplus -s xxxx/xxxx @/home/ivbbuild/rec.sql  > /home/ivbbuild/rech.txt

from anywhere.

Also I am cron tab entry is under root user not oracle. I thought thats why we put the environment variables right?

I have also added new variables:

Code:

export TNS_ADMIN=/u01/app/oracle/product/9.0.1/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib

Please advise. Thanks in advance.

Tosh.

---------- Post updated at 12:36 AM ---------- Previous update was at 12:35 AM ----------

Hi All,

Also

Code:

 /home/ivbbuild/rech.txt 2>&1

does not yield any error logs. The rech.txt simply wont generate.

regards,
Tosh.

Just as a sidenode: Even if you run it from the oracle crontab you would have to set up all environmental things like for example

Code:

. ./.profile
. ./someenv
export ...

When running a crontab, there will be no environmental stuff used like when you log in normal with that user.

If you run this script for testing purpose in the crontab of user oracle, including sourcing it's .profile and environment files, it would be interessting if it works.
If yes, then something in the environment of root might be still missing.

If the permission of file '$ORACLE_HOME/bin/oracle' is not set properly then 'sqlplus' won't work for non-oracle users.

Permission of this file must be like '-rwsr-s--x'.

Regards,

Jith

Hi Jith,


The permission of file '$ORACLE_HOME/bin/oracle' is set to '-rwsr-s--x' from the start.

Still no luck.

Has anyone ever run this before?

regards,
Santosh.

Hi Guys,

Any more suggestions?

regards,
Santosh.