Need help in Rac

From: arun chakrapani rao <arunrao_oradba_at_yahoo.co.in>
Date: Tue, 6 Apr 2004 23:29:40 +0100 (BST)
Message-ID: <20040406222940.9574.qmail@web8305.mail.in.yahoo.com>

Hi Gurus,
I have a test rac configured on a linux machine which has 3 instances running.
I am trying to test the TAF by crashing one of the instance but client comes up with saying end of communication channel
down below is the configuration I am using Can somebody please let me know as to where I have gone wrong

Listener configuration

LISTENER_ORCL2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =
linuxtest2pub)(PORT = 1523))
  )

SID_LIST_LISTENER_ORCL2 =
  (SID_LIST =
    (SID_DESC =
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(SID_NAME = ORCL2)

    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =
linuxtest2pub)(PORT = 1521))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(SID_NAME = ORCL1)

    )
  )

LISTENER_ORCL3 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =
linuxtest2pub)(PORT = 1524))
  )

SID_LIST_LISTENER_ORCL3 =
  (SID_LIST =
    (SID_DESC =
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(SID_NAME = ORCL3)

    )
  )

Tnsnames

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
linuxtest2pub)(PORT = 1523))

(ADDRESS = (PROTOCOL = TCP)(HOST =
linuxtest2pub)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST =
linuxtest2pub)(PORT = 1524))

(LOAD_BALANCE = yes)

)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
(failover_mode=

        (type=select)
        (mode=basic)
        (retries=20)
        (delay=10)
      )

)
)

Init parameter entries

orcl1.local_listener="(address=(protocol=tcp)(host=linuxtest2)(port=1521))" orcl1.remote_listener=
"(address=(protocol=tcp)(host=linuxtest2)(port=1521))" orcl2.local_listener="(address=(protocol=tcp)(host=linuxtest2)(port=1523))" orcl2.remote_listener=
"(address=(protocol=tcp)(host=linuxtest2)(port=1524))" orcl3.local_listener="(address=(protocol=tcp)(host=linuxtest2)(port=1524))" orcl3.remote_listener="(address=(protocol=tcp)(host=linuxtest2)(port=1523))"

The TAF works fine when I use only two instances dont know where I have gone wrong.
Thanks in advance.
Arun

Yahoo! India Insurance Special: Be informed on the best policies, services, tools and more. Go to: http://in.insurance.yahoo.com/licspecial/index.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Apr 06 2004 - 17:26:06 CDT