Can Sat Central Agent configured with Oracle Data Guard/RAC?
Oracle Data Guard is new with Oracle 11g. Also, it is similar to Oracle RAC.
WORKAROUND:
Configuring Oracle Data Guard / RAC Environments
If Stat is running on a Oracle Data Guard / RAC environment, you will need to manually edit
<STAT_HOME>/app/server/default/deploy/stat-ds.xml.
1. If you haven’t already done so, stop the Stat Central Agent.
2. Open <STAT_HOME>/app/server/default/deploy/stat-ds.xml.
The beginning of the file will look like this but with your database information in
it:
<?xml version="1.0" encoding="UTF-8"?>
<!--
$Revision: 1.4 $ $Id: stat-ds.xml,v 1.4 2007/01/30 21:30:38 vrahimi Exp $
Basic Template for repository datasource definition
Only one of these should be active; i.e., one datasource
called 'StatDataSource'
-->
<datasources>
<local-tx-datasource>
<jndi-name>StatDataSource</jndi-name>
<connection-url>jdbc:oracle:thin:@//alvsupl04v.quest.com:1521/st560</
connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<application-managed-security/>
<security-domain>EncryptedDBPassword</security-domain>
<check-valid-connection-sql>SELECT STAT_DB_VERSION FROM SYSTEM_TBL</
check-valid-connection-sql>
<connection-property name="v$session.program">Stat-Agent</connectionproperty>
<min-pool-size>2</min-pool-size>
<max-pool-size>50</max-pool-size>
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
<!-- Connection info examples -->
3. Edit this line only:
<connection-url>jdbc:oracle:thin:@//alvsupl04v.quest.com:1521/st560</
connection-url>
4. Starting from the @ symbol, paste the TNS entry without carriage returns or line
feeds.
It will look something like this:
<connection-url>jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL =
TCP)(HOST = alvsupl04v.quest.com)(PORT = 1521))(ADDRESS = (PROTOCOL =
TCP)(HOST = Alvsupl11v.quest.com)(PORT = 1521))(LOAD_BALANCE =
no)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = st560)))
5. In context, the file will look like this:
<datasources>
<local-tx-datasource>
<jndi-name>StatDataSource</jndi-name>
<connection-url>jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL =
TCP)(HOST = alvsupl04v.quest.com)(PORT = 1521))(ADDRESS = (PROTOCOL =
TCP)(HOST = Alvsupl11v.quest.com)(PORT = 1521))(LOAD_BALANCE =
no)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = st542)))
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<application-managed-security/>
<security-domain>EncryptedDBPassword</security-domain>
<check-valid-connection-sql>SELECT STAT_DB_VERSION FROM SYSTEM_TBL</
check-valid-connection-sql>
<connection-property name="v$session.program">Stat-Agent</connectionproperty>
<min-pool-size>2</min-pool-size>
<max-pool-size>50</max-pool-size>
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
6. Save and close the file.
Oracle Data Guard is new with Oracle 11g. Also, it is similar to Oracle RAC.
