This should be on the dbi-users list. Are you sure all of the environment variables are set? Can you show the code? The ORA-12154 is TNS error,
12154, 00000, "TNS:could not resolve service name" // *Cause: The service name specified is not defined correctly in the // TNSNAMES.ORA file. // *Action: Make the following checks and correct the error: // - Verify that a TNSNAMES.ORA file exists and is in the proper // place and accessible. See the operating system specific manual // for details on the required name and location. // - Check to see that the service name exists in one of the // TNSNAMES.ORA files and add it if necessary. // - Make sure there are no syntax errors anywhere in the file. // Particularly look for unmatched parentheses or stray characters. // Any error in a TNSNAMES.ORA file makes it unusable. See // Chapter 4 in the SQL*Net V2 Administrator's Guide. If // possible, regenerate the configuration files using the Oracle // Network Manager. ...in other words it doesn't know the db you are trying to connect to, which means the ORACLE_SID is not set or it is wrong in your connect statement. Posting the code would help. On Tue, 2004-08-03 at 15:51, Robert wrote: > Hi list > Command line script test2-cgi works fine but when I try from the browser it is > giving the following error > > DBI connect('db1','report',...) failed: Error while trying to retrieve text for > error ORA-12154 (DBD ERROR: OCIServerAttach) at /home/report/www/cgi-bin/test2-cgi > line 72 > > I have complete ORACLE environment set, I can connect using sqlplus and also can run > tnsping the database without any issues at command prompt. > > Anyone know how to fix this issue?. > > Thanks in advance > >