Skip to Content
1
Jan 21, 2022 at 08:29 AM

bi 4.3 Audit DB Oracle RAC

158 Views Last edit Jan 21, 2022 at 08:30 AM 2 rev

Hello, Auditing and monitoring are being configured.

1. Refer to https://launchpad.support.sap.com/#/notes/1768678

Complete JDBC settings such as modifying oracle.sbo and adding ojdbc6.jar file

2. CMC > Audit > Change to the connection name of the ADS database (ip,port,SERVICE_NAME)

audit.png

The audit database is configured as RAC.

So I was wondering how to set the connection name of the ADS database to RAC in Audit.


[environment]

BIP 4.3 SP1 Patch6

AIX 7.2 TL5

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 RAC

[TNSNAME.ORA]

RAC =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.1)(PORT = 1536))

(ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.2)(PORT = 1536))

(LOAD_BALANCE = NO)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = RAC)

(FAILOVER_MODE =

(TYPE = SELECT)

(METHOD = BASIC)

(RETRIES = 180)

(DELAY = 5)

)

)

[oracle.sbo JDBC syntax]

캡처.png

Attachments

audit.png (13.1 kB)