Hello Robert,
have you tried to specify NLS_LANG ?
I thing it is needed too?
Are you using sqlplus as the same user or wwwrun?
Can wwwrun read and execute the files in OraHome1?
Thursday, September 16, 2004, 3:45:37 PM, you wrote:
R> I have upgraded Oracle from 8.1.7 to 9.2, after changing to the
R> new Oracle environment when I run the cgi script which always used
R> to work in Oracle 8.1.7 to Oracle 9.2 is giving the following error.
R> Software error:
R> DBI connect('user1','user123',...) failed: ERROR OCIEnvInit at
R> /home/user1/www/cgi-bin/test.cgi line 260
R> For help, please send mail to this site's webmaster, giving
R> this error message and the time and date of the error.
R> I have changed the Oracle 9.2 environment in the cgi script (OraHome1 is the
Oracle 9.2 )
R> $ENV{ORACLE_HOME} = q[/ora1/u01/oracle/OraHome1];
R> $ENV{LD_LIBRARY_PATH} = qq[$ENV{ORACLE_HOME}/lib];
R> Tnsping is working and also I can connect to oracle using
R> sqlplus, is there any compatibility issue with
R> DBI-1.43/DBD-Oracle-1.15 and Oracle 9.2? .
HTH
Wieland mailto:[EMAIL PROTECTED]
