cancel
Showing results for 
Search instead for 
Did you mean: 

TNS listener problem

TNS listener problem

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?

3 REPLIES
Simon Hargrave
Honored Contributor

Re: TNS listener problem

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.
Jean-Luc Oudart
Honored Contributor

Re: TNS listener problem

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
fiat lux

Re: TNS listener problem

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