Database Networking (MOSC)

MOSC Banner

What in detail does tnsping checks ?

edited Jan 10, 2012 7:57PM in Database Networking (MOSC) 5 commentsAnswered
Hi Community,

I have a question concerning functionality of "tnsping" command.

I have a 11gR2 RAC Cluster with an Oracle 11gR2 database running.

Entry in "/u01/app/11.2.0/grid/network/admin/tnsnames.ora:

---snip---

I99 =
  (DESCRIPTION =
    (FAILOVER = yes)
    (ADDRESS = (PROTOCOL = TCP)(HOST = scan1.ora.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = I99)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
      )
    )
  )

I991 =

  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.ora.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = I99)
      (INSTANCE_NAME = I991)
    )
  )

I992 =

  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.ora.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = I99)
      (INSTANCE_NAME = I992)

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