Solved

adbagent configuration for Oracle RAC

Posted on 2011-09-12
3
1,104 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Read some really old .pic files??? 18 84
PDF into Powerpoint - Free 1 34
JVM error from eclipse 1 26
Intel® Setup and Configuration Software (Intel® SCS) 5 39
Let’s list some of the technologies that enable smooth teleworking. 
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

739 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