Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> DBD vs. Apache + Oracle
Hi there,
we´re trying to make a perl script connecting an oracle database ..
while this works fine on the local machine, the connection replies with
to the request
when executing the script as CGI.
A DSN other then ´´ (like ´DBI:Oracle:ORCL´) fails, because we cant get lsnctrl to start tnslsnr properly:Received on Thu Nov 11 1999 - 14:14:14 CST
-- > lsnctrl start
-- .....
-- Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
-- TNS-12224: TNS:no listener
-- TNS-12541: TNS:no listener
-- TNS-12560: TNS:protocol adapter error
-- TNS-00511: No listener
-- Linux Error: 111: Connection refused
-- Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=localhost))
-- STATUS of the LISTENER
-- ------------------------
-- Alias LISTENER
-- Version TNSLSNR for Linux: Version 8.0.5.0.0 -
Production
-- .....
its astonishing to get a status without a listener connected to oracle (tnslsnr is chown root and has its SUID set) NOW THE QUESTION(s): - does anybody know a workaround ? and/or - do we really need the listener when executing a CGI-bin ? and/or - somebody out there who could kill the 'TNS:protocol adapter error´ ? Our environment is: RedHat 6.0 - Oracle 8.0.5 - Apache 1.3.6 - DBD 1.0.3 A (nice) guy already compared his (working) listener.ora and tnsnames.ora with ours without finding major differences. Any suggestions are welcome tia -- Christian