Database - RAC/Scalability (MOSC)

MOSC Banner

Using FQDN SCAN IP connection failed for JDBC url ORA-12520, TNS:listener

edited Oct 1, 2014 1:20PM in Database - RAC/Scalability (MOSC) 2 commentsAnswered

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)))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center