Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DBD vs. Apache + Oracle

DBD vs. Apache + Oracle

From: <reichhoff_at_mediaworx.com>
Date: Thu, 11 Nov 1999 21:14:14 +0100
Message-ID: <382B2396.1680EC59@mediaworx.com>

        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:


-- > 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
Received on Thu Nov 11 1999 - 14:14:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US