| can not connect to Service [message #308933] |
Wed, 26 March 2008 00:34  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
