Hi,
I tried using the cron wrapper.
I setup a file with the following in it:
su - oracle <<eof_su
/library/file_transfer/scripts/OraclePing.sh
eof_su
and used the following in the crontab
5,10,15,20,25,30,35,40,45,50,55,0 * * * * /library/file_transfer/scripts/OraclePing.crn
now the script...
I've run a few more tests and I have found a way around the tnsname I believe. However, there is still a problem as tnsping still fails. The script runs fine outside of crontab so I assume its an environment problem?
08/03/05 19:15:00 - TNS Ping Utility for IBM/AIX RISC System/6000: Version...
Hi,
I am trying to create a script that does a tnsping on an oracle DB every 5 minutes by a crontab.
I know my problem relates to the crontab not being able to convert the Oracle service name.
In the crontab I have:
5,10,15,20,25,30,35,40,45,50,55,0 * * * *...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.