Please verify things got installed correctly. 1. /app1/oracle/admin/pwrdev/audit must be listed in UTL_FILE_DIR parameter To check run SELECT * FROM v$parameter WHERE name = 'UTL_FILE_DIR' 2. P_AUDIT_FILE_HANDLER packege is installed and valid SELECT OWNER, OBJECT_TYPE, OBJECT_NAME, STATUS FROM DBA_OBJECTS WHERE OBJECT_NAME='P_AUDIT_FILE_HANDLER' 3. Associated Java stored procedures are installed and valid SELECT OWNER, OBJECT_TYPE, OBJECT_NAME, STATUS FROM DBA_OBJECTS WHERE OBJECT_NAME='AUDITFILEHANDLER' 4. DB_AUDIT user got permissions to run Java files and access files outside of db CALL DBMS_JAVA.GRANT_PERMISSION('DB_AUDIT', 'java.io.FilePermission', ' >', 'read, delete'); CALL DBMS_JAVA.GRANT_PERMISSION('DB_AUDIT', 'SYS:java.lang.RuntimePermission', 'readFileDescriptor', ''); GRANT JAVAUSERPRIV TO DB_AUDIT; GRANT EXECUTE ON UTL_FILE TO DB_AUDIT; GRANT SELECT ON sys.v_$instance TO db_audit; GRANT SELECT ON sys.v_$process TO db_audit; : Thanks - I've done these steps & I now see that this : procedure is set up to run in dba_jobs and has failed on : every attempt & is broken. : This is what is scheduled : db_audit.sp_aud_file_loader('/app1/oracle/admin/pwrdev/audit', '/'); : This is the correct location where I have pointed audit files to : it is running under user SYS - is that correct? : I have granted execute prvs on both the procedure : and the package under db_audit but : When I try to run it manually - this is the error i get : Error: ORA-29540: class AuditFileHandler does not exist ORA-06512: at line 1, : Batch 1 Line 1 Col 1 : I receive the same error when running it as DB_AUDIT user. : I have installed jvm in the database - looks like the java classes : that your package uses are not loaded. : I have also attempted to uninstall & reinstall. This is a unix system. : Thanks for you help
|