Solved

adbagent configuration for Oracle RAC

Posted on 2011-09-12
3
1,093 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
ID: 36529044
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
ID: 36540823
Issue resolved by adding custom variable for LD_LIBRARY_PATH in adbagent.tra for tibco.
0
 
LVL 3

Author Closing Comment

by:prak_seafarer
ID: 36558852
updated adbagent.tra
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

910 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

23 Experts available now in Live!

Get 1:1 Help Now