Ravip via DBMonster.com wrote:
> 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.
Please stop top posting or I will ignore all future posts.
This means scroll to the bottom to reply.
How did you create the RAC_DB service?
How are you determining the load balancing ... post your actual SQL
statement and results.
Also post your actual Oracle version number to four decimal places.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Sep 21 2007 - 11:33:56 CDT