Database - RAC/Scalability (MOSC)

MOSC Banner

Connecting to 11g R2 RAC without using SCAN

edited Oct 7, 2010 2:04AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered
 
hi

We have a 10g R2 client and we need to connect to the 11g R2 database without using SCAN entry and instead use the VIPs

when we try to execute tnsping <11gRACDB> , we get TNS-12541 - No Listener

We have the following in our tnsnames.ora


PRODTST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.31)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.33)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = prodtst)
      (FAILOVER_MODE =
              (TYPE = SELECT)
              (METHOD = BASIC)
              (RETRIES = 180)
              (DELAY = 5)
      )
    )
  )


In above, the 2 IPs are the VIPs

what we could be missing here?

How can we verify if the listeners are listening on port 1521 for both the VIPs?

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