Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Silver_1
Regular Advisor

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

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
8 REPLIES
Silver_1
Regular Advisor

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

How can we check the port 1522 is listening or opened on the server ?
James A. Donovan
Honored Contributor

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

$ 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
Remember, wherever you go, there you are...
Steven E. Protter
Exalted Contributor

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

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Sandman!
Honored Contributor

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

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
Honored Contributor

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

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
Never give up, Keep Trying
Silver_1
Regular Advisor

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

Where the file which has the port mappings. I forgot the name of the file.
Tx.
Hein van den Heuvel
Honored Contributor

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

/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
Regular Advisor

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

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.