In previous post - Schedule Java application through crontab, I mentioned that the process of scheduling other application is same as Java application.
To accomplish this, you have to set at least two environment variables. The first one is obviously the PATH. The other is ORACLE_HOME. You need to set ORACLE_SID if you want to use a database as default or if you don't have permission in tnsnames.ora file.
PATH=/usr/local/oracle/product/11.2.0/dbhome_1/bin
ORACLE_HOME=/usr/local/oracle/product/11.2.0/dbhome_1
export PATH
export ORACLE_HOME
These should be sufficient if you have permission in tnsnames.ora. Otherwise, the database should be installed in your workstation and ORACLE_SID should be settled to database service name.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment