Database Networking (MOSC)

MOSC Banner

problem of connecting rac

edited Aug 12, 2011 2:01AM in Database Networking (MOSC) 3 commentsAnswered
 I have oracle 11g rac on two Linux nodes.

Listener is configured as listner.ora file

===================node 1===================

LISTENER_1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname1-v)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xx.y)(PORT = 1521)(IP = FIRST))
    )
  )
==================node 2 = ====================

LISTENER_2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname2-v)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xx.z)(PORT = 1521)(IP = FIRST))
    )
  )
================================================

sid is tes1 and test2

client is tnsnames.ora

===================

test.world =
(DESCRIPTION=
 (FAILOVER=ON)
 (LOAD_BALANCE=ON)
 (ADDRESS=
   (PROTOCOL=TCP)
   (HOST=hostname1-v.domain)
   (PORT=1521))
 (ADDRESS=
   (PROTOCOL=TCP)
   (HOST=hostname2-v.domain)
   (PORT=1521))
 (CONNECT_DATA=

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