Re: Oracle 10g TAF Vs FAN

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@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • Re: virtual address (url) resolution for website
    ... as this defeats our load balancing solution. ... > want users to know which server they are logging into. ... involving configuration of your load-balanced servers, ... frame to display the page on the other server result in the URL in the ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: HELP in load balancing with citrix.
    ... The default load balancing rule uses the number of sessions. ... your version of Citrix. ... MCSE, CCEA, Microsoft MVP - Terminal Server ... Now I have another server with the same hardware configuration.. ...
    (microsoft.public.windows.terminal_services)
  • Help with connect control and server load balancing
    ... I'm trying to use the connect control module within FW1 to do server ... I've performed the following configuration: ... internal IP's of the real web servers and defined their external NAT ... external IP address to be used for load balancing facing the public ...
    (comp.security.firewalls)
  • Re: SBS SP 1 installation error
    ... Component Name: Microsoft Exchange Forest Preparation ... Component Name: Server Configuration ... Component Name: Windows Server 2003 Configuration ... Component Name: Networking Configuration ...
    (microsoft.public.windows.server.sbs)
  • RE: ceicw fails every time
    ... I'd like confirming CEICW steps with you to ensure there is not problem ... You have to rerun the CEICW to make sure your SBS 2003 server have right ... On the "Services Configuration" page, select all the items and then ... Calling CCertCommit::ValidatePropertyBag ...
    (microsoft.public.windows.server.sbs)