Oracle 10g TAF Vs FAN

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ravip - 12 Sep 2007 05:32 GMT

Hi,

In the area of services configuration to get the maximum availability the TAF
/ FAN configuration by default it is TAF. Can any body help me to get the
difference between TAF and FAN.

Thanks in advance.

Reply to this Message

DA Morgan - 12 Sep 2007 06:09 GMT

> Hi,
>
[quoted text clipped - 3 lines]
>
> Thanks in advance.

The question you should be asking is TAF and FCF.

FAN is messaging ... essentially AQ technology being used to message
between various high availability components.

The two transparent failover technologies are TAF (Transparent
Application Failover) and FCF (Fast Connection Failover). You will
find the docs describing them if you go to www.psoug.org. Click on
Links and then follow the High Availability.

Signature

Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Reply to this Message

Ravip - 17 Sep 2007 05:07 GMT

>> Hi,
>>
[quoted text clipped - 11 lines]
>find the docs describing them if you go to www.psoug.org. Click on
>Links and then follow the High Availability.

My aim is to "evenly distribute the work load" to both nodes on my RAC. As of
now only 1 node is fully loaded and the other just 2% or 3%. To enable this
what configuration change should I make ?
I have configured the services based on TAF policy. The first node is
preferable and the second node is available.

Since I'm doing this for the first time, I need your expertise on this. I
would like to do the workload balancing between the nodes. I believe the
following areas configuration change to be made.

1. Listener configuration.
2. connection string of application provided in the middle tier.

Please give a birds eye view on this configuration part.

Thank You.

Reply to this Message

DA Morgan - 17 Sep 2007 07:50 GMT

>>> Hi,
>>>
[quoted text clipped - 15 lines]
> I have configured the services based on TAF policy. The first node is
> preferable and the second node is available.

You really need to read the documentation. TAF has absolutely nothing to
do with listener load balancing.

If you configure your TNSNAMES.ORA properly the nodes will load balance
themselves.

http://www.psoug.org/reference/rac.html
Look at the TNSNAMES.ORA

Signature

Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Reply to this Message

Ravip - 18 Sep 2007 05:35 GMT

My scenario is, I have a application server in between the front end and
database. During the service configuration the TNSNAMES.ORA is rightly
mentioned with the parameters that is mentioned in URL that you mentioned.

I have 2 node cluster and as of now only 1 of the node is having the full
load. I'm using Webspere as the middle tier. There are some occassions where
only 1 node in the RAC was fully loaded and the CPU reached 100% and
continued for 3-4 minutes, then it came down. Obvious reason for the load is
bad queries and some of them has been rectified.

But my doubt is, if the load balance is enabled or working fine, during the
100% CPU usage of Node 1, the load has to be distribute to the 2nd node -
right ? But it doesn't happen and at that time the 2 node load was just 2%.

To make this work load evenly distributed between 2 nodes, what configuration
should I check and change ?

Thank You.

>>>> Hi,
>>>>
[quoted text clipped - 10 lines]
>http://www.psoug.org/reference/rac.html
>Look at the TNSNAMES.ORA

Reply to this Message

DA Morgan - 18 Sep 2007 16:20 GMT

> 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.

Signature

Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Reply to this Message

Ravip - 20 Sep 2007 06:45 GMT

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.

Reply to this Message

Ravip - 21 Sep 2007 10:16 GMT

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.

>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.
[quoted text clipped - 73 lines]
>>etc.
>>Each one produces a different behavior.

Reply to this Message

DA Morgan - 21 Sep 2007 17:33 GMT

> Hi Brian,
>
[quoted text clipped - 82 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.

Signature

Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Reply to this Message

Ravip - 29 Sep 2007 06:08 GMT

Hi,

Any of your valuable feedback is highly appreciated.

Thank You.

>>>> Hi,
>>>>
[quoted text clipped - 10 lines]
>http://www.psoug.org/reference/rac.html
>Look at the TNSNAMES.ORA

Reply to this Message

kuassi.mensah@gmail.com - 12 Sep 2007 09:17 GMT

> Hi,
>
[quoted text clipped - 6 lines]
> --
> Message posted via DBMonster.comhttp://www.dbmonster.com/Uwe/Forums.aspx/oracle/200709/1

The following blog entry should help:http://db360.blogspot.com/2007/01/
is-your-java-application-failoverproof.html

Kuassi

Reply to this Message

Steve Howard - 12 Sep 2007 15:05 GMT

On Sep 12, 4:17 am, "kuassi.men...@gmail.com"
<kuassi.men...@gmail.com> wrote:

> > Hi,
>
[quoted text clipped - 11 lines]
>
> Kuassi

Your blog is always a wealth of information.

Thanks!

Reply to this Message

joeNOSPAM@BEA.com - 12 Sep 2007 18:09 GMT

Hi Steve!
Also search this group for a post "TAF and FCF together ?"

That thread points out how TAF may in typical use-cases
never really be able to deliver transparent application failover.
FCF does not promise as much, but does deliver what it
promises.

This URL points to it:

http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread
/df85fb057e98c22d/1beafd6382cf4829?lnk=gst&q=TAF+and+FCF+together&rnum=1#1beafd6
382cf4829

Joe Weinstein at BEA Systems

Reply to this Message

Ravip - 17 Sep 2007 06:06 GMT

>> Hi,
>>
[quoted text clipped - 6 lines]
>
>Kuassi

The mention blog URL - responded with Page Not Found.

Reply to this Message

joel garry - 18 Sep 2007 00:13 GMT

> kuassi.men...@gmail.com wrote:
> >> Hi,
[quoted text clipped - 9 lines]
>
> The mention blog URL - responded with Page Not Found.

The url is wrapped, you need to put it all together from http
to ...oof.html

Here's another try:
http://db360.blogspot.com/2007/01/is-your-java-application-failoverproof.html
if it doesn't work, you need to do it manually.

jg
--
@home.com is bogus.
"Your pores are like a negative planetarium projection." - Colbert

Reply to this Message