Listener unable to start on HP UX 11.23/Oracle 10.2.

[Silver_1]

Hi,

While starting the listener, following error appears.


LSNRCTL for HPUX: Version 10.2.0.1.0 - Production on 27-MAR-2006 14:37:04

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /u01/app/oracle/product/10.2.0.1/db_1/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0.1/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0.1/db_1/network/log/listener_testdb.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hp01.test.net)(PORT=1522)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
HPUX Error: 13: Permission denied

[Silver_1]

How can we check the port 1522 is listening or opened on the server ?

[James A. Donovan]

$ oerr ora 12545
12545, 00000, "Connect failed because target host or object does not exist"
// *Cause: The address specified is not valid, or the program being
// connected to does not exist.
// *Action: Ensure the ADDRESS parameters have been entered correctly; the
// most likely incorrect parameter is the node name. Ensure that the
// executable for the server exists (perhaps "oracle" is missing.)
// If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the
// host name to a numeric IP address and try again.

First try the above...then

If the listener process is running, you can use:
ps -ef|grep tns or,
lsnrctl status
tnsping

[Steven E. Protter]

Shalom,

This is probably a listener.ora or tnsnames.ora problem. Its always a good idea prior to trying to start the listener to verify the oracle network connectivity with the tnsping utility.

All the hosts in those files also need to be pingable via normal networking. To avoid these issues, I generally set my oracle configuration files with ip addresses back in my dba days.

The permission denied message implies that something the oracle user needs to start the listener, be it shared memory or a binary is not owned by the user starting the listener.

SEP

[Sandman!]

Hi,

You could use either lsof or netstat to find out if port 1522 is in use, however as James points out this maybe an issue with an incorrect hostname in the Oracle tnsnames.ora file.

# lsof -i:1522
or
# netstat -an | awk '{if(z[split($4,z,".")]==1522) print $0}'

[Indira Aramandla]

Hi Silver,

TNS-12545: Connect failed because target host or object does not exist. The cause for this would be te address specified is not valid, or the program being connected to does not exist. Check that the ADDRESS parameters have been entered correctly; the most likely incorrect parameter is the node name. Ensure that the executable for the server exists. If the protocol is TCP/IP, edit the "TNSNAMES.ORA" file to change the host name to a numeric IP address and try again.

TNS-12560: TNS:protocol adapter error. This means a generic protocol adapter error occurred. Check addresses used for proper protocol specification.

TNS-00515: Connect failed because target host or object does not exist. This means a protocol specific ADDRESS parameter cannot be resolved. Ensure the ADDRESS parameters have been entered correctly; the most likely incorrect parameter is the node name.

HPUX Error: 13: Permission denied, UNIX error 13 is Permission Denied. Check the permissions on your TNS_ADMIN directory and the tnsnames.ora and listener.ora files.


Indira A

[Silver_1]

Where the file which has the port mappings. I forgot the name of the file.
Tx.

[Hein van den Heuvel]

/etc/services

I assume you already made user node naming is correct (/etc/hosts? networkds?) through a simple ping?
ping hp01.test.net

Hein.

[Silver_1]

Thanks Guys.

I was having some permission problems. Somebody had run some commands and i have taken some time to catch it.

When similar problem on 3 machines, was unable to think where is the actual problem.