Oracle® Fusion Middleware OES-11g Release 2 (11.1.2.2.0) - Steps to Setup Auditing for OES

Oracle® Fusion Middleware OES-11g Release 2 (11.1.2.2.0) - Steps to Setup Auditing for OES

1Create an Oracle database for Audit purposes

2Run ./rcu to load the OES Audit schema, in database created in step number 1 Make sure to Select "AS Common Schema -> Audit Services for OES" set prefix -> AUDIT (important for next step)

3-Start APM domain and open weblogic console -> http://host:7001/console Create a JDBC connection, setting values according to your database Under JDBC, click the Data Sources link Create new jdbc Data Source JNDI Name -> jdbc/AuditDB user is the prefix set in RCU process + _IAUOES -> AUDIT_IAUOES  

password set during RCU -> welcome1

Make sure "Test Connection" is successful

4-Stop APM domain

5-Edit Oracle/Middleware/user-projects/domains/APM/config/fmwconfig/jps-config.xml,

Set Audit properties as follows

<serviceInstance name="audit" provider="audit.provider"> 

<property name="audit.filterPreset" value="All"/> 

<property name="audit.maxDirSize" value ="500000"/> 

<property name="audit.maxFileSize" value ="50000"/> 

<property name="audit.loader.jndi" value="jdbc/AuditDB"/>

 <property name="audit.loader.interval" value="15" /> 

<property name="audit.loader.repositoryType" value="Db" /> 

</serviceInstance>

6-Start APM Domain

7-Go to your Audit schema, and check the information stored Connect based your user info, for example -> ./sqlplus audit_iauoes/welcome1 run a sql to test, 

SELECT * FROM IAU_BASE WHERE ROWNUM<2, 

to check a couple of records where the information was stored

For more information on Audit schema refer to the  following documentation link in Oracle Fusion Middleware Application Security Guide (12.5 Advanced Management of Database Store):

8.) Ensure that your jps-config.xml is configured accurately as follows

<?xml version="1.0" encoding="UTF-8" standalone='yes'?>

<jpsConfig xmlns="http://xmlns.oracle.com/oracleas/schema/11/jps-config-11_1.xsd" 

          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 

 xsi:schemaLocation="http://xmlns.oracle.com/oracleas/schema/11/jps-config-11_1.xsd" 

 schema-major-version="11" schema-minor-version="1">

    <serviceProviders>

     <serviceProvider name="audit.provider" type="AUDIT" class="oracle.security.jps.internal.audit.AuditProvider">

     </serviceProvider>

    </serviceProviders>

  <serviceInstances>

   <serviceInstance name="audit" provider="audit.provider">

      <property name="audit.filterPreset" value="Low"/>

      <property name="audit.specialUsers" value ="admin, fmwadmin" />

      <property name="audit.customEvents" value ="JPS:CheckAuthorization, CreateCredential; OIF:UserLogin"/>

      <property name="audit.loader.jndi" value="jdbc/AuditDB"/>

      <property name="audit.loader.interval" value="15" />

      <property name="audit.maxDirSize" value="102400" />

      <property name="audit.maxFileSize" value="10240" />      

      <property name=" audit.loader.repositoryType " value="Db" />      

   </serviceInstance>

  </serviceInstances>

    <jpsContexts default="default">

        <jpsContext name="default">

            <serviceInstanceRef ref="audit"/>

        </jpsContext>

    </jpsContexts>

</jpsConfig>