Home » Server Options » RAC & Failsafe » can not connect to Service (Oracle 10g R2, RHEL Server 5)
can not connect to Service [message #308933] Wed, 26 March 2008 00:34 Go to next message
dba110
Messages: 25
Registered: December 2007
Junior Member
hi everyone,
I have setup Oracle RAC on VMWare Server using RHEL Server 5 and Oracle 10gr2 on 2 nodes. I have created a TAF service named by CRM. the problem is that, when I try to connect the service CRM with the commond.
SQL>connect system/password@CRM
I get the following error:
error: TNS: no listener

I haved started the listener with the commond: lsnrctl start
and get the following message

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1.uffaq.com)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 26-MAR-2008 09:41:51
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1.uffaq.com)(PORT=1521)))
The listener supports no services
The command completed successfully

the message is saying that "listener supports no services", although I created CRM at the time of Database creation. but now when I try to connect to the TAF service, I always get the message of no listener. please guide me how to resolve this issue.
Re: can not connect to Service [message #310546 is a reply to message #308933] Tue, 01 April 2008 10:15 Go to previous message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
After creation have you started that service? It's there in listener.ora?
Previous Topic: install 10gr2 active/passive
Next Topic: Unable to connect to CM in non-RAC
Goto Forum:
  


Current Time: Thu Mar 28 07:23:55 CDT 2024