I am trying to execute a perl script on 2 different unix servers. On
both servers, the perl is called from a bourne shell script. Any
changes required to reflect the different environments are made in the
shell script in order to help keep the perl pure from taint. Basically,
the perl script is EXACTLY THE SAME on both servers. The perl makes a
connection to a database (the same database, regardless of where the
perl is running). One server is running Solaris 5.6, the other is
running Solaris 5.8. the database resides on a completely different
server from the ones running the perl script and is oracle 8i.
When I run the script on the 5.6 box, I have absolutely no problems.
However, when I run the script on the 5.8 box, I get the following
error:
DBI->connect(host=gobi;sid=eandd) failed: ERROR OCIEnvInit at
epay_rejects.pl line 393
Database connection not made: ERROR OCIEnvInit
I've seen posts similar to this, but none seem to answer the question of
how to resolve it. Some suggestions were to make sure that a connection
could be made to the database through some other tool. I can connect
through other tools.and in fact connect with the exact same code, just
on a different unix box. One thought occurred to me that the DBD
package may possibly need to be re-installed.
Does anyone have any ideas for a possible solution?
Thanks for your help!
