Is the listener running? You can check by doing a 'ps' or
by typing 'lsnrctl status' (this command works on solaris 2.7 with
oracle 8.1.5) If it is not running type 'lsnrctl start' and if it
doen't start you must install "sqlnet" or "net8" depending on which
version of Oracle you have. (Oracle8i calls it net8)
Also the 'tnsnames.ora' should have an alias to the database.
In article <3776e605.502862037_at_news.deakin.edu.au>,
tfischer_at_deakin.edu.au (Thomas Fischer) wrote:
> Hi,
>
> I want Perl to connect to Oracle8.0.5 on Linux RedHat6
> and I get the following message:
>
> ORA-12224: TNS:no listener (DBD: login failed) at ./new.pl line 4
>
> When I type 'services' on the lsnrctl prompt it says (which sounds
> pretty similar):
>
> Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=[deleted]))
> 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=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)(Host=[deleted])(Po
> rt=1521))
> 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
>
> This looks like an installation problem of the server to me but I have
> no Idea what to do. Any ideas?
>
> Thomas
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Wed Jun 30 1999 - 09:04:50 CDT
