• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 684
  • Last Modified:

oracle 10 aih ora 46258

oracle 10.2.05 on aix
audit trail set to db
executing
BEGIN
DBMS_AUDIT_MGMT.set_audit_trail_location(
audit_trail_type =>DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
audit_trail_location_value => 'AUDIT_TS');
END;
/
error at line 1
ORA 46258: Cleanup not initialized for the audit trail

I have set this up in 3 other database - they are 11g with no issue - this database is 10g
is there a way to fix this?

thanks
0
bkreynolds48
Asked:
bkreynolds48
  • 2
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
Not a lot of information on that package in the 10g docs.  My guess is that package was new to 10g.  My other guess is that in 11g, it does tings for you that 10g didn't.

Never used that package but based on the error message (in the 11g docs):
http://docs.oracle.com/cd/E11882_01/server.112/e17766/e46000.htm

ORA-46258: Cleanup not initialized for the audit trail
    Cause: DBMS_AUDIT_MGMT.INIT_CLEANUP was not called for the erroring audit trail.
    Action: Invoke the procedure, DBMS_AUDIT_MGMT.INIT_CLEANUP.

I was able to find the description of innit_cleanup in the 10g docs:
http://docs.oracle.com/cd/E11062_01/admin.1023/e11059/avadm_app_d_audit_mgmt.htm#BABFHEFH
0
 
bkreynolds48Author Commented:
when running the cleanup

BEGIN
DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(
   audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_DB,
   use_last_arch_timestamp => TRUE);
END;
/

get error at line, column 37
PLS 302 component "AUDIT_TRAIL_DB' must be declared
0
 
slightwv (䄆 Netminder) Commented:
Are you looking at the 10g docs?  Use what you ind on the Internet as a good starting point but refer to the online docs for your specific version for the final say.

From them, they post the valid values for audit_trail_type:

http://docs.oracle.com/cd/E11062_01/admin.1023/e11059/avadm_app_d_audit_mgmt.htm#BABIDGEA
0
 
bkreynolds48Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now