Symantec Access Management

How to configure CA SiteMinder Report Server with Oracle Audit Database 

06-20-2014 01:00 AM

  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

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.