Solved

adbagent configuration for Oracle RAC

Posted on 2011-09-12
3
1,089 Views
Last Modified: 2013-12-19
Am trying to use ADB Agent with Oracle RAC 10.2.0.4

 

odbc.ini configuration is as follows:

 

[tib_oracle]

Driver=/opt/tibco/adapter/adadb/5.3/odbc/lib/TIora22.so

Description=DataDirect 5.2 Oracle Wire Protocol

AlternateServers=

ApplicationUsingThreads=1

ArraySize=60000

CachedCursorLimit=32

CachedDescLimit=0

CatalogIncludesSynonyms=1

CatalogOptions=0

ConnectionRetryCount=-1

ConnectionRetryDelay=60000

DefaultLongDataBuffLen=1024

DescribeAtPrepare=0

EnableDescribeParam=0

EnableNcharSupport=0

EnableScrollableCursors=1

EnableStaticCursorsForLongData=0

EnableTimestampWithTimeZone=0

HostName=

LoadBalancing=1

LocalTimeZoneOffset=

LockTimeOut=-1

LogonID=

Password=

PortNumber=

ProcedureRetResults=0

ReportCodePageConversionErrors=0

ReportRecycleBin=0

ServerName=ABCD

ServerType=0

ServiceName=

SID=

TimestampeEscapeMapping=0

TNSNamesFile=/opt/tibco/adapter/adadb/5.3/odbc/tnsnames.ora

UseCurrentSchema=1

WireProtocolMode=1

 

& tnsnames.ora is configured as follows

 

ABCD =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))

      (LOAD_BALANCE=yes)

      (FAILOVER=yes)

    )

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = db_service_name)

    )

  )

 

In normal situation, adb agent is working fine, as expected. But if one of the DB instance to which adb agent is connected goes down, adb agent is crashing. If I restart adb agent again, it gets connected to the other DB instance and then it continues to work fine.

 

May I know, why it is not automatically connecting to the other DB instance, please ?

 

If I have to make any changes to the configuration, please let me know.
0
Comment
Question by:prak_seafarer
  • 2
3 Comments
 
LVL 6

Expert Comment

by:Javier Morales
Comment Utility
Is the driver prepared for RAC failover? does it have implemented FCF, RLB and else?

what's your ONS configuration?

Remember that's the driver that performs the "reconnection" and provides taf...

Many drivers doesn't support RAC features... please, check the vendor's specifications of it.

Read the following documentation for how to implement these RAC features in the connection driver

http://download.oracle.com/docs/cd/B28359_01/java.111/e10788/rac.htm#CHDHIBJE
0
 
LVL 3

Accepted Solution

by:
prak_seafarer earned 0 total points
Comment Utility
Issue resolved by adding custom variable for LD_LIBRARY_PATH in adbagent.tra for tibco.
0
 
LVL 3

Author Closing Comment

by:prak_seafarer
Comment Utility
updated adbagent.tra
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
A list of useful business intelligence software.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now