Solved

adbagent configuration for Oracle RAC

Posted on 2011-09-12
3
1,113 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 7

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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

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…
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

632 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