Home » Developer & Programmer » Precompilers, OCI & OCCI » Error ORA-12154
Error ORA-12154 [message #94573] Tue, 15 February 2005 19:26 Go to next message
Hafizzul
Messages: 2
Registered: February 2005
Junior Member
Hi..

I have a program written in Pro*C. It running well if I just type the program name.

But I want to schedule so that it will run on 15th day every month using crontab.

But..problem arise when I use crontab, I got error ORA-12154.

Can anybody help me?

TQ
Re: Error ORA-12154 [message #94574 is a reply to message #94573] Tue, 15 February 2005 21:13 Go to previous messageGo to next message
Hafizzul
Messages: 2
Registered: February 2005
Junior Member
Additional info:

I also try tnsping HOST_NAME, and the result is OK.

But when i try tnsping HOST_NAME using crontab, i got error:
TNS Ping Utility for Solaris: Version 8.1.7.0.0 - Production on 16-FEB-2005 12:43:00

(c) Copyright 1997 Oracle Corporation. All rights reserved.

TNS-03505: Message 3505 not found; No message file for product=network, facility=TNS
Re: Error ORA-12154 [message #121839 is a reply to message #94574] Wed, 01 June 2005 06:08 Go to previous messageGo to next message
gnanavelou
Messages: 2
Registered: February 2005
Junior Member
Hi,

have u got any solun? for this error.
b.coz i am also facing the same problem.

pls let me know if got the soln.

regards
Velou.
Re: Error ORA-12154 [message #121962 is a reply to message #94573] Thu, 02 June 2005 00:37 Go to previous messageGo to next message
bobbie_ch
Messages: 2
Registered: June 2005
Junior Member
i think it is because when you are calling it from a cronjob, it is not gettting the oracle environment variables. try to call the pro*c from a shell script. in the shell script, set the oracle environment variables, and call the shell script in the crontab.
Re: Error ORA-12154 [message #122186 is a reply to message #121962] Fri, 03 June 2005 10:59 Go to previous message
Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...
Senior Member

For example


--cut
if [ OSTYPE="linux-gnu" ]
then
. ~/.bash_profile
else
. ~/.profile
fi

# which database to use
export ORACLE_SID=$1
export ORAENV_ASK=NO
. oraenv
export ORAENV_ASK=YES
sqlplus un/pw @script.sql
--cut
Previous Topic: Help needed - re-compilation of C programs under Oracle 9i
Next Topic: how cobol program can run in oracle
Goto Forum:
  


Current Time: Thu Mar 28 20:08:41 CDT 2024