Home » RDBMS Server » Security » Getting Internal Error while doing Audit_Trail. (Oracle Version 10.2.0.3.0 Windows Server 2000)
Getting Internal Error while doing Audit_Trail. [message #475752] Fri, 17 September 2010 06:15
misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india
Senior Member

Hi, i created one policy to manage auditing of one table test_fga. I used handler_module parameter to record local
auditing information in one table.
Quote:

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
5 rows selected.


=> creating table and package
create table t1(A number)
/

CREATE OR REPLACE PACKAGE pkg_fga_audit IS
  PROCEDURE fga_audit (sname VARCHAR2, 
                       tname VARCHAR2, 
                       pname VARCHAR2);
END pkg_fga_audit;
/

CREATE OR REPLACE PACKAGE BODY pkg_fga_audit IS
  PROCEDURE fga_audit (sname VARCHAR2, 
                       tname VARCHAR2, 
                       pname VARCHAR2) IS
    PRAGMA AUTONOMOUS_TRANSACTION;
  BEGIN
    INSERT INTO fga_log(txt)
    VALUES (' sname=' || sname || ' tname=' || tname || ' pname='|| pname);
    COMMIT;
  END fga_audit;
END pkg_fga_audit;
/


=> creating policy

BEGIN
  dbms_fga.add_policy(
            object_schema => 'GOPAL',
            object_name => 'TEST_FGA',
            policy_name => 'TEST_FGA_ACCESS',
            audit_column => null,
            audit_condition => null,
            statement_types=> 'INSERT, DELETE, UPDATE',
            handler_module  =>'pkg_fga_audit.fga_audit');
end;
/

table sys.aud$ is having 0 count. because we implelemted only policies on specofic table.

Although it is recording suceessfully but at the same time giving internal error.

Re: ORA-00600: internal error code, arguments: [4412] (ORA-02002: error while writing to audit trail)

Some of sites are saying 'This is a bug report in metalink (5592308) with no solution'.

Please suggest if you guys had faced this earlier. or any suggestion.
Previous Topic: Logon Denied
Next Topic: How to get statement_type from procedure called in handler_module [DBMS_FGA]
Goto Forum:
  


Current Time: Mon Sep 27 23:25:55 CDT 2021