unable to connect to database via service name
Hello team,
I have 2 node RAc configuration.below are my listener.ora,tnsnames.ora conf file,listener service status . While connecting the database with service service it is showing the error: Please let me know how i solve this issue
=================================================================================================================================================
Enter user-name: sys/oracle@rac1
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
[oracle@rac3 ~]$ echo $ORACLE_SID
rac1
[oracle@rac3 ~]$
==============================================
[oracle@rac3 ~]$ lsnrctl service listener_rac1
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 20-FEB-2014 00:27:35
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_RAC1)))
Services Summary...
Service "rac1" has 1 instance(s).
Instance "rac1", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "rac2" has 1 instance(s).
Instance "rac2", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
==============================================
[oracle@rac3 admin]$ more listener.ora
LISTENER_RAC1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_RA
C1)))) # line added by Agent
SID_LIST_LISTENER_RAC1=
(SID_LIST =
(SID_DESC =
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
(SID_NAME=rac1)
)
(SID_DESC=
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
(SID_NAME=rac2)
)
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_RAC1=ON # line added by Agent
[oracle@rac3 admin]$
==========================================
RAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac.localdomain)
)
)
RAC2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.111)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rac2.rac.localdomain)
)
)
RAC1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rac1.rac.localdomain)
)
)
================================================
Regards,