适用于:
Oracle Server - Enterprise Edition - Version: 10.2.0.3 to 10.2.0.4 - Release: 10.2 to 10.2
Information in this document applies to any platform.
***Checked for relevance on 15-Jun-2010***
目的:
当通过使用DBMS_AUDIT_MGMT包审计跟踪管理和清楚时,ORA-46250 to ORA-46264其中之一的错误,描述之下将会发生。这个文档的目的是描述一个错误,一个由错误并且这个动作是为了诊断支个错误。
运用范围:
这个文档只适用于如果DBMS_AUDIT_MGMT包在特殊的RDBMS版本/补丁中是可得到的。这个文档可以用于关联错误的意义。
Description of Error Messages Encountered While Managing The Audit Trail with DBMS_AUDIT_MGMT
The following section lists the possible errors that can occur during Audit Trail Cleanup or Management, when using DBMS_AUDIT_MGMT PL/SQL package.
接下来的选项列出了,当使用DBMS_AUDIT_MGMT包是,在审计跟踪清楚或者管理期间引起的可能的错误。
46250, 00000, "Invalid value for argument '%s'"
// *Cause: Input value was not valid for the procedure.
// *Action: Use a valid option.
Note: See section "DBMS_AUDIT_MGMT constants" below for list of allowed values for the API arguments.
46251, 00000, "Value for argument '%s' out of range"
// *Cause: Input value was out of range.
// *Action: Use a value within allowed range.
Note: See section "DBMS_AUDIT_MGMT constants" below for range allowed for the API arguments.
46252, 00000, "Cannot complete the operation, overlapping job already exists"
// *Cause: Cleanup job already existed which spanned the given audit trail type.
// *Action: Drop the existing job.
46253, 00000, "Cannot complete the operation, overlapping property already exists"
// *Cause: The property already exists which spans the given audit trail type.
// *Action: Clear the existing property.
46254, 00000, "'%s' already exists"
// *Cause: The value being set already existed.
// *Action: Delete the existing entry.
46255, 00000, "Incorrect job name specified"
// *Cause: The job did not exist or was not created by DBMS_AUDIT_MGMT package.
// *Action: Create the job using DBMS_AUDIT_MGMT package.
46256, 00000, "Internal error: Audit Table not partitioned"
// *Cause: Invalid operation on a non partitioned table.
// *Action: Contact Oracle Support Services.
46257, 00000, "Property '%s' cannot be cleared"
// *Cause: The property could not be cleared.
// *Action: None. The property can only be set or reset.
46258, 00000, "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.
46260, 00000, "Error during audit trail cleanup"
// *Cause: The audit trail cleanup operation could not be completed.
// *Action: Check the UNIX error number for a possible operating system error.
// If there is no error, contact Oracle Support Services.
46261, 00000, "Error during audit trail cleanup, internal error"
// *Cause: The audit trail cleanup could not be completed because of an internal error.
// *Action: Contact Oracle Support Services.
46262, 00000, "Audit table(s) cannot be moved to '%s' tablespace"
// *Cause: The tablespace was either unavailable or did not have enough space
// to accomodate the audit table being moved.
// *Action: Make sure that the tablespace is online and has enough space
// for the audit tables being moved.
注意:你可以通过设置调试级别来打开跟踪
DBMS_AUDIT_MGMT.TRACE_LEVEL_DEBUG using DBMS_AUDIT_MGMT.SET_DEBUG_LEVEL API to investigate on the size required for the operation
46263, 00000, "The audit trail is already initialized for cleanup"
// *Cause: DBMS_AUDIT_MGMT.INIT_CLEANUP was already invoked for the audit trail
// type.
// *Action: None.
46264, 00000, "Error during DBMS_AUDIT_MGMT operation"
// *Cause: Could not complete the operation.
// *Action: Check the PL/SQL error stack for a possible error.
// If there is no error, contact Oracle Support Services.
DBMS_AUDIT_MGMT 包含:
审计跟踪类型:
AUDIT_TRAIL_ALL - All audit trail types. This includes the standard database audit trail (SYS.AUD$ and SYS.FGA_LOG$ tables), operating system (OS) audit trail, and XML audit trail.
AUDIT_TRAIL_AUD_STD - Standard database audit records in the SYS.AUD$ table
AUDIT_TRAIL_DB_STD - Both standard audit (SYS.AUD$) and FGA audit(SYS.FGA_LOG$) records
AUDIT_TRAIL_FGA_STD - Standard database fine-grained auditing (FGA) records in the SYS.FGA_LOG$ table
AUDIT_TRAIL_FILES - Both operating system (OS) and XML audit trails
AUDIT_TRAIL_OS - Operating system audit trail. This refers to the audit records stored in operating system files.
AUDIT_TRAIL_XML - XML audit trail. This refers to the audit records stored in XML files.
审计跟踪参数:
CLEAN_UP_INTERVAL - Interval, in hours, after which the cleanup job is called to clear audit records in the specified audit trail. Minimum value is 1 hour and the maximum is 999 hours.
DB_DELETE_BATCH_SIZE - Specifies the batch size to be used for deleting audit records in database audit tables. The audit records are deleted in batches of size equal to DB_DELETE_BATCH_SIZE. Minimum value is 100 and the maximum is 1000000.
OS_FILE_MAX_AGE - Specifies the maximum number of days for which an operating system (OS) or XML audit file can be kept open before a new audit file gets created. Minimum value is 1 day and the maximum is 497 days.
OS_FILE_MAX_SIZE - Specifies the maximum size to which an operating system (OS) or XML audit file can grow before a new file is opened. Minimum value is 1 KB and the maximum is 2000000 KB.
清楚工作状态:
PURGE_JOB_DISABLE - Disables a purge job
PURGE_JOB_ENABLE - Enables a purge job
Trace Level Values:
TRACE_LEVEL_DEBUG - Logs detailed debug messages
TRACE_LEVEL_ERROR - Logs only error messages