Using FQDN SCAN IP connection failed for JDBC url ORA-12520, TNS:listener
Hi All,
Please help me on this
FQDN SCANIP is working in tnsnames.ora
ORA112DB=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SCAN-RAC-PSR.rpc.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORA112DB)
)
)
But its not working in JDBC url
ORA-12520, TNS:listener could not find available handler for requested type of server
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SCAN-RAC-PSR.rpc.com)(PORT=1521))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORA112DB))(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5)))
We need to use SCAN-RAC-PSR as scanip . EX..
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SCAN-RAC-PSR)(PORT=1521))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORA112DB))(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5)))