Solved

adbagent configuration for Oracle RAC

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
use lov values 2 50
Component is listed with a Protocol more than once 3 30
WinX Downloader fails to analyze. 10 40
Creation date for a PDB 5 22
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…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

809 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