Oracle Database Discussions

Hi All,

When I try to connect it says no listener. Trying to setup the rman for the 2 nodes.

SQL> conn system/welcome@host1 as sysdba
ERROR:
ORA-12541: TNS:no listener

-----same result if I try host0-------




host0:oratest 55> lsnrctl status LISTENER_TEST_host0

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 29-JAN-2010 15:45:30

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host0.cat.com)(PORT=1527)(IP=FIRST)))
STATUS of the LISTENER
------------------------
Alias LISTENER_TEST_host0
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 27-JAN-2010 16:07:13
Uptime 1 days 23 hr. 38 min. 17 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/TEST/102_64/network/admin/listener.ora
Listener Log File /oracle/TEST/102_64/network/log/listener_TEST_host0.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.243)(PORT=1527)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.247)(PORT=1527)))
Services Summary...
Service "TEST.WORLD" has 2 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
Instance "TEST2", status READY, has 1 handler(s) for this service...
Service "TEST1" has 1 instance(s).
Instance "TEST1", status UNKNOWN, has 1 handler(s) for this service...
Service "TEST1.WORLD" has 1 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
Service "TEST2.WORLD" has 1 instance(s).
Instance "TEST2", status READY, has 1 handler(s) for this service...
Service "TEST_SERVICEA.WORLD" has 1 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
Service "TEST_XPT.WORLD" has 2 instance(s).
Instance "TEST1", status READY, has 1 handler(s) for this service...
Instance "TEST2", status READY, has 1 handler(s) for this service...
The command completed successfully

Thanks

Naren