Just in case you didn't get the meaning behind Tim's comment, if you upgrade your version of Oracle, you then always need to rebuild DBD::Oracle. DBD::Oracle needs to be built _after_ installing any version of Oracle.
>>> Tim Bunce <[EMAIL PROTECTED]> 09/17/04 06:21AM >>> Rebuild DBD::Oracle. Tim. On Thu, Sep 16, 2004 at 07:45:37AM -0700, Robert wrote: > > I have upgraded Oracle from 8.1.7 to 9.2, after changing to the new Oracle environment when I run the cgi script which always used to work in Oracle 8.1.7 to Oracle 9.2 is giving the following error. > Software error: > DBI connect('user1','user123',...) failed: ERROR OCIEnvInit at /home/user1/www/cgi-bin/test.cgi line 260 > > For help, please send mail to this site's webmaster, giving this error message and the time and date of the error. > > > > I have changed the Oracle 9.2 environment in the cgi script (OraHome1 is the Oracle 9.2 ) > > $ENV{ORACLE_HOME} = q[/ora1/u01/oracle/OraHome1]; > $ENV{LD_LIBRARY_PATH} = qq[$ENV{ORACLE_HOME}/lib]; > > > > Tnsping is working and also I can connect to oracle using sqlplus, is there any compatibility issue with DBI-1.43/DBD-Oracle-1.15 and Oracle 9.2? . > > > > Thanks in advance > > > > > > > > > > --------------------------------- > Do you Yahoo!? > vote.yahoo.com - Register online to vote today!