Possible Causes
The Oracle database has been hardened and its common permissions have been modified through the maintenance tool.
Procedure
Log in to the server as the oracle user.
Connect to the database.
> sqlplus / as sysdba
Run the following commands:
@$ORACLE_HOME/rdbms/admin/catsnmp.sql;
grant execute on UTL_FILE to APEX_030200;
grant execute on UTL_FILE to ORACLE_OCM;
grant execute on UTL_FILE to ORDPLUGINS;
grant execute on UTL_FILE to ORDSYS;
grant execute on UTL_FILE to WMSYS;
grant execute on UTL_FILE to XDB;
grant execute on UTL_HTTP to APEX_030200;
grant execute on UTL_HTTP to ORDPLUGINS;
grant execute on UTL_SMTP to APEX_030200;
grant execute on DBMS_OBFUSCATION_TOOLKIT to APEX_030200;
grant execute on DBMS_OBFUSCATION_TOOLKIT to DBSNMP;
grant execute on DBMS_OBFUSCATION_TOOLKIT to SYSMAN;
GRANT EXECUTE ON DBMS_LOB TO PUBLIC;
GRANT EXECUTE ON DBMS_RANDOM TO PUBLIC;
GRANT EXECUTE ON EXFSYS.DBMS_EXPFIL TO PUBLIC;
GRANT execute on DBMS_LDAP TO public;
GRANT execute on DBMS_JOB TO public;
GRANT execute on UTL_FILE TO public;
GRANT create procedure TO resource;
GRANT SELECT ANY DICTIONARY TO DBSNMP;
GRANT SELECT ANY DICTIONARY TO SYSMAN;
GRANT SELECT_CATALOG_ROLE TO SYSMAN;
GRANT OEM_MONITOR TO DBSNMP;
@$ORACLE_HOME/rdbms/admin/catsnmp.sql;
Use the MainAst to perform Oracle hardening rollback again.
