ORA-32101 reported due to incorrect Environment Variables

Phenomenon: database connection error: Error while trying to retrieve text for error ORA-32101

Background: if the program is executed in the installation directory or by adding an absolute path, there is no problem.

Question: If you want this program to be periodically executed in crontab?

The first time you use crontab to execute a script to call the C ++ program, you can directly edit it:

14,29, 44,59 *****/cjdata2/src/zongxianghulian/zxhlfile/starth <br/> 8 */cjdata2/src/users/zxhlfile/startl <br/>

Found the program has been reporting the error ORA-32101.

Script content:

#! /Usr/bin/KSh <br/> COUNT = 'ps-Ef | grep 'zxhlfile' | WC-l' <br/> If [$ count-GT 1] <br /> then <br/> echo "The program zxhlfile is running! "<Br/> else <br/> Cd/cjdata2/src/zongxianghulian/zxhlfile </P> <p>./zxhlfile-H <br/> fi

Test for a long time, find a lot of methods, just don't, last

Add a line in the script:

. $ Home/. Profile

Done.

Appendix:

ORA-32101:	Cannot create OCI Environment
Cause:	An OCI environment cocould not be created for occi
Action:	Insure that the parameters to the createnvironment method are valid

 

 

References:

Http://forums.oracle.com/forums/thread.jspa? Threadid = 521125