We are using our corporate scheduling tool to call a webfocus procedure. When i try to run the edastart -x command on the command line, it works fine. However when i try the same inside a shell script i was thrown error due to enviorment variables not set properly.
(FOC1261) PHYSICAL INTERFACE NOT FOUND FOR SUFFIX SQLORA. MODULE NAME : OR8PS10 (FOC1262) THE FOLLOWING NATIVE ERROR MESSAGE(S) CAPTURED : (FOC1260) libclntsh.so.10.1: cannot open shared object file: No such file or directory (FOC1263) THE CURRENT ENVIRONMENT VARIABLES FOR SUFFIX SQLORA ARE : (FOC1260) ORACLE_SID : orac (FOC1260) NLS_LANG : AMERICAN (FOC1260) ORACLE_HOME : /opt/oracle/product/10.2.0/client_1 (FOC1260) LD_LIBRARY_PATH : /opt/ibi/srv77/home/bin (FOC1260) /home/marasigana/installs/jdk1.6.0_17/jre/lib/i386/client (FOC1260) /home/marasigana/installs/jdk1.6.0_17/jre/bin (FOC1260) /opt/oracle/product/10.2.0/client_1/lib (FOC1260) /opt/jdk1.6.0_22/jre/lib (FOC1260) /opt/jdk1.6.0_22/lib (FOC1260) /opt/jdk1.6.0_22/jre/lib/i386/server (FOC1260) /opt/jdk1.6.0_22/jre/lib/i386/native_threads (FOC1260) /opt/jdk1.6.0_22/jre/lib/i386 (FOC1260) /lib (FOC1260) /usr/lib (FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF) (FOC1488) SQL INTERFACE HAS NOT BEEN INSTALLED OR COULD NOT BE INITIALIZED (FOC1479) ERROR CONNECTING TO SQL DATABASEThis message has been edited. Last edited by: Kerry,
Release : 7.7.02 OS : Linux App Server : Tomcat all output
June 02, 2011, 01:45 PM
Saravanan J
Sorry everyone. It was a small mistake i made in my script. I had set my $ORACLE_HOME incorrectly. I changed it and it is working fine.
Release : 7.7.02 OS : Linux App Server : Tomcat all output
June 06, 2011, 02:54 AM
<JG>
Saravanan,
Thanks for the update.
So often there is no feed back, so you never know the solution.
You fixed this yourself, It's the telling how that is important.