Hi,
I have a unix machine that hosts 5 oracle databases.
Each database has its own "ORACLE_HOME" with is actualy an oracle software .
Each software is installed in its own directory.
For example :
/u01/app/oracle/product/11.2.0/TERP11gR2
/u01/app/oracle/product/11.2.0/QERP11gR2
/u01/app/oracle/product/11.2.0/LERP11gR2
and so one.
On each software , i also have perl as part of the software in the following location :
/u01/app/oracle/product/11.2.0/TERP11gR2/perl/bin
/u01/app/oracle/product/11.2.0/QERP11gR2/perl/bin
and so on.
The question is as followed:
I have a generic script called test.pl which is running from the crontab
In order to run the script againt the "right" database i need to set in the first line of the perl script :
#!/u01/app/oracle/product/11.2.0/TERP11gR2/perl/bin/perl
or
#!/u01/app/oracle/product/11.2.0/QERP11gR2/perl/bin/perl
or
#!/u01/app/oracle/product/11.2.0/LERP11gR2/perl/bin/perl
Since i have 5 database , i had to duplicate the script test.pl 5 times.
The script is the same , and the only change is this first line.
Please advice how change it , in order to have just one script and not five .....
Thanks