TNS listener problem

[ATHANASOPOULOS PANAGIOT]

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?

[Simon Hargrave]

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]

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

[ATHANASOPOULOS PANAGIOT]

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