Re: Oracle 10g TAF Vs FAN

From: Ravip via DBMonster.com <u36659_at_uwe>
Date: Thu, 20 Sep 2007 05:45:24 GMT
Message-ID: <787c3a6061724@uwe>

I will correct myself to read from top. Please find the tnsnames.ora below pasted. Obviously yes I'm using service names to connect to DB.

---

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

RAC_DB2 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = iims_db2_vip)(PORT = 1521))
(CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = RAC_DB)
      (INSTANCE_NAME = RAC_DB2)

    )
  )

RAC_DB1 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = iims_db1_vip)(PORT = 1521))
(CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = RAC_DB)
      (INSTANCE_NAME = RAC_DB1)

    )
  )

LISTENERS_RAC_DB =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = iims_db1_vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = iims_db2_vip)(PORT = 1521))
  )

RAC_DB =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = iims_db1_vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = iims_db2_vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = RAC_DB)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )

    )
  )

RACDB =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = iims_db1_vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = iims_db2_vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME =RACDB)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))     )
(CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

    )
  )

DA Morgan wrote:

>> My scenario is, I have a application server in between the front end and
>> database. During the service configuration the TNSNAMES.ORA is rightly
>[quoted text clipped - 28 lines]
>>> http://www.psoug.org/reference/rac.html
>>> Look at the TNSNAMES.ORA
>
>People read from top to bottom. Please do not top post or you will be
>ignored by most. Scroll to the bottom to reply.
>
>You wrote:
>" I have 2 node cluster and as of now only 1 of the node is having the 
>full load."
>
>Which is a clear indication that while you may or may not have a RAC
>cluster you definitely do not have it configured properly. Post your
>tnsnames.ora file. Also validate that your login is to the service
>and not to an instance.
>
>Take a look at this page again:
>http://www.psoug.org/reference/rac.html
>Scroll down to the listing:
>"TNSNAMES.ORA 10.2.0.1 RedHat Linux AS 4 U2"
>
>Note that the same cluster can addressed as:
>TSTA.TAF ... the TAF service
>TSTA
>TSTA1
>TSTA2
>etc.
>Each one produces a different behavior.

-- 
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/oracle/200709/1

Received on Thu Sep 20 2007 - 00:45:24 CDT