No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

eSight V300R009C00 Single-Node System Software Installation Guide (SUSE Linux) 09

Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
Failure to Roll Back the Oracle Hardening

Failure to Roll Back the Oracle Hardening

Symptom

During Oracle database hardening rollback through the maintenance tool, the rollback fails. Log information similar to the following is displayed:

Post-processing failure. Rollback failure: revoke execute on DBMS_OBFUSCATION_TOOLKIT from DBSNMP;(user or role 'DBSNMP' does not exist)
Post-processing failure. Rollback failure: revoke execute on UTL_FILE from APEX_030200;(cannot REVOKE privileges you did not grant)

Possible Causes

The Oracle database has been hardened and its common permissions have been modified through the maintenance tool.

Procedure

  1. Log in to the server as the oracle user.
  2. Connect to the database.

    > sqlplus / as sysdba

  3. 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;     

  4. Use the MainAst to perform Oracle hardening rollback again.
Download
Updated: 2019-05-17

Document ID: EDOC1100011860

Views: 92691

Downloads: 138

Average rating:
This Document Applies to these Products
Related Documents
Related Version
Share
Previous Next