topic Re: TNS listener problem in Operating System - HP-UX

TNS listener problem

ATHANASOPOULOS PANAGIOT — Thu, 24 Feb 2005 04:44:25 GMT

We have installed RAC (9iR2) on 2 nodes, with HP-UX 11.11 on them.
We have 2 dbs, a test and a real one.
We set up the test listeners to listen on the 1521 port and the real listeners on the 1525 port, in the listener.ora files (one for each node).
When we try to connect to the the real db through the Oracle Enterprise Manager Console we get the msg: TNS:no listener.
I run the lsnrctl start and then the lsnrctl status and I get:
Connecting to ...(PORT=1521))
STATUS of the LISTENER
----------------------
Alias LISTENER
...
The listener supports no services
The command completed successfully

Is there another way to start the listener of the real db?

Re: TNS listener problem

Simon Hargrave — Thu, 24 Feb 2005 05:25:35 GMT

Do you have one listener with 2 tcp ports such as: -

LISTENER =
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS = (PROTOCOL = TCP)...1521
( ADDRESS = (PROTOCOL = TCP)...1525
)
)

etc, or do you have 2 separate listeners defined eg: -

LISTENER_TEST =
( DESCRIPTION =
...1521
....

LISTENER_LIVE =
( DESCRIPTION =
...1525

etc? If the latter then you'll have to start the listeners separately.

lsnrctl start by default starts a listener called "LISTENER". If you have one called eg LISTENER_LIVE you'll need to do

lsnrctl start LISTENER_LIVE

If that's not the problem, check for listnening TCP ports: -

netstat -an | grep LISTEN | grep -e 1521 -e 1525

You should get 2 lines, otherwise you have a problem with your listener.ora and we can't help more unless you post it.

Re: TNS listener problem

Jean-Luc Oudart — Thu, 24 Feb 2005 06:50:58 GMT

If you have 2 listeners when you run the command "ps -ef | grep [t]ns" you should have 2 processes , one for each listener.

Regards
Jean-Luc

Re: TNS listener problem

ATHANASOPOULOS PANAGIOT — Thu, 24 Feb 2005 07:32:50 GMT

Thanks for your answers.
I have 2 seperate listeners and I used
the lsnrctl start listener_name command.