ORA-12514: TNS:listener... (via SCAN)
Hi All,
When connecting to newly installed database I am receiving the following message:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
So far I have verified the following:
Database parameters
SQL> show parameter listener (on both instances)
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=server1-vip)(PORT=1521))))
remote_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=cluster-scan.domain.com)(PORT=1521))))
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=server2-vip)(PORT=1521))))
remote_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=cluster-scan.domain.com)(PORT=1521))))
Verified name resolution is correct using LDAP:
bash-3.2$ tnsping cluster
TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 05-OCT-2010 10:23:46
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/oracle/product/11.2.0/network/admin/sqlnet.ora
Used LDAP adapter to resolve the alias
Attempting to contact (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=cluster-scan.domain.com)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=cluster)))
OK (30 msec)
bash-3.2$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node server2
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node server1
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node server1
bash-3.2$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): server1,server2
bash-3.2$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node server2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node server1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node server1
bash-3.2$ nslookup cluster-scan.domain.com
Server: 10.1.130.15
Address: 10.1.130.15#53
Name: cluster-scan.domain.com
Address: 10.1.1.32
Name: cluster-scan.domain.com
Address: 10.1.1.33
Name: cluster-scan.domain.com
Address: 10.1.1.34
bash-3.2$ srvctl config scan
SCAN name: cluster-scan.domain.com, Network: 1/10.1.1.0/255.255.255.0/en10
SCAN VIP name: scan1, IP: /cluster-scan.domain.com/10.1.1.32
SCAN VIP name: scan2, IP: /cluster-scan.domain.com/10.1.1.33
SCAN VIP name: scan3, IP: /cluster-scan.domain.com/10.1.1.34
However, while trying to connect via sqlplus we receive the ORA-12514 error:
bash-3.2$ sqlplus sys/aaa@cluster
SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 5 10:24:08 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor