How to configure CA SiteMinder Report Server with Oracle Audit Database

Document created by Ujwol Shrestha Employee on Jun 20, 2014Last modified by kristen.palazzolo on Dec 17, 2016
Version 4Show Document
  • View in full screen mode
  1. Configure Policy Server to Audit Database Connection in Policy Server Management Console.

1.png

2.png

 

  2.  Configure WAMUI to Report Server Connection

3.png

 

  3.  Run report server configuration wizard and select correct audit database type.

4.png

4. Install 32 bit Oracle Net Client on the Report server and create a net service name to connect to the audit database. (Report Server is a 32 bit application so it needs 32 bit Oracle Net Client)

 

  Verify “tnsname.ora” file located at :  $Oracle Net Client home$\network\admin

  1. e.g.

    C:\app\Administrator\product\11.2\client_2\network\admin

 

    Here, Net Service Name = ORCL_NS & Service Name = orcl

5.png

 

5. Verify the connectivity from Report Server to Audit Database by running “tnsping <net_service_name>” command as below :

7.png

6. In WAMUI, create Audit report connection

 

Name = any connection name

DSN = “Net Service Name” configured in tnsname.ora file in Report Server host.

Service Name = “Service Name” configured in tnsname.ora file in Report Server host.

 

8.png

Note :

====

1. For oracle audit database, you need NOT create any ODBC connection on the report server

Attachments

    Outcomes