Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
Internal support for Management Packs and Real Application Testing (RAT)
AUTHID
DEFINER
Dependencies
DBMS_ADVISOR
DBMS_RAT_MASK_INTERNAL
PRVTEMX_ADMIN
DBMS_ASH_INTERNAL
DBMS_SQLPA
PRVTEMX_CELL
DBMS_KEG_LIB
DBMS_SQLTUNE
PRVT_ADVISOR
DBMS_MANAGEMENT_PACKS
DBMS_SYS_ERROR
PRVT_AWR_VIEWER
DBMS_PERF
DBMS_WRR_PROTECTED
PRVT_HDM
Documented
No
Exceptions
Error Code
Reason
ORA-13722
invalid input value
for procedure argument PACK_NAME
Completes successfully if the named pack is enabled
prvt_smgutil.check_pack_enabled(pack_name IN VARCHAR2);
exec prvt_smgutil.check_pack_enabled('RAT');
BEGIN prvt_smgutil.check_pack_enabled('RAT'); END;
*
ERROR at line 1:
ORA-13722: invalid input value for procedure argument PACK_NAME
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.PRVT_SMGUTIL", line 41
ORA-06512: at line 1
Completes successfully if the named pack is enabled
prvt_smgutil.is_pack_enabled(pack_name IN VARCHAR2) RETURN BOOLEAN;
BEGIN
IF prvt_smgutil.is_pack_enabled('DIAGNOSTIC') THEN
dbms_output.put_line('Enabled');
ELSE
dbms_output.put_line('Disabled');
END IF;
END;
/ Enabled
prvt_smgutil.validate_arg_len(
p_value IN VARCHAR2,
p_name IN VARCHAR2,
p_len IN NUMBER);
exec prvt_smgutil.validate_arg_len('TEST', 'MORGAN', 1);
BEGIN prvt_smgutil.validate_arg_len('TEST', 'MORGAN', 1); END;
*
ERROR at line 1:
ORA-13723: input value for procedure argument MORGAN exceeds maximum allowed length of 1
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.PRVT_SMGUTIL", line 137
ORA-06512: at line 1
-- note that the following is also a violation of ORA-13723
-- likely an invalid exception message as a P_LEN of 3 also fails