ORA-12154

[Robert]

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