Re: Oracle 10g TAF Vs FAN

Hi Brian,

I need your valuable inputs to make the load balancing evenly distribute. I have pasted my tnsnames.ora and I believe there should be some configuration change to be made. Please have your feedback. I need to configure the same in my production system ASAP.

Thank You.

Ravip wrote:
>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)
> )
> )
>
>>> 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 - 26 lines]
>>etc.
>>Each one produces a different behavior.

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