NOTE: This list does not take into account product dependencies that, when selected for de-install, remove required database software. Oracle Wallet Manager (Requires Advanced Security when using PKI and transparent encryption) Oracle Provisioning and Patch Automation Pack Requires additional License on Enterprise Edition: %ORACLE_HOME%/OPatch/opatch lsinventory –detail | more (Windows) $ORACLE_HOME/OPatch/opatch lsinventory –detail | more (UNIX) If any are installed and are not required or not licensed, this is a Finding. Review the list of installed products with the DBA and verify any installed products listed below are required and licensed. Use the Oracle Universal Installer or OPATCH utility to display the list of installed products. Therefore, thorough testing is required before removing components from a production server. However, dependencies exist among Oracle components that could result in the removal of an apparently unnecessary component interfering with the operation of a required component. By minimizing the services and applications installed on the system, the number of potential vulnerabilities is reduced. The syntax to run catqm.Unused, unnecessary DBMS components increase the attack surface for the DBMS by introducing additional targets for attack. ![]() * The tablespace specified for the XDB repository must be using Automatic Segment Space Management (ASSM) for SecureFiles to be used. * To use SecureFiles, compatibility must be set to 11.2. * If YES is specified, the XDB repository will use SecureFile storage. * A tablespace other than SYSAUX should be specified, especially if you expect Oracle XML DB Repository to contain a large amount of data.Įxtent management local uniform size 256K segment space management auto * The specified tablespace must already exist prior to running the script. * The SYSTEM, UNDO and TEMP tablespace cannot be specified. ![]() The catqm.sql script requires the following parameters be passed to it when run: Select count(*) from dba_objects where status = ‘INVALID’ - no rows Select COMP_ID, COMP_NAME, VERSION, STATUS from dba_registry ĬATALOG Oracle Database Catalog Views 11.2.0.2.0 VALIDĬATPROC Oracle Database Packages and Types 11.2.0.2.0 VALID update Data Pump related objects and KU$_ Check to verify that all components are valid To implement the solution, XDB dummy views and Data Pump related objects needs to be updated manually, please execute the following steps: These objects are marked INVALID because of the dependency over XDB. The cause of the problem with ALL_XML_SCHEMAS/ALL_XML_SCHEMAS2 invalid views has been identified in unpublished Bug 9892139, fixed in 11.2.0.3. Running “utlrp.sql” does not help to make these objects VALID. SQL> select OWNER, OBJECT_NAME, OBJECT_TYPE from dba_objects where status = ‘INVALID’ JAVAVM JServer JAVA Virtual Machine 11.2.0.2.0 VALIDĬATJAVA Oracle Database Java Packages 11.2.0.2.0 VALID ![]() RAC Oracle Real Application Clusters 11.2.0.2.0 VALID OWM Oracle Workspace Manager 11.2.0.2.0 VALIDĬATALOG Oracle Database Catalog Views 11.2.0.2.0 INVALIDĬATPROC Oracle Database Packages and Types 11.2.0.2.0 INVALID SQL> select COMP_ID, COMP_NAME, VERSION, STATUS from dba_registry ĮXF Oracle Expression Filter 11.2.0.2.0 VALID Removing XML DB database option manually with catnoqm.sql script there are invalid objects in SYS schema. XDB Deinstallation script catnoqm.sql leads to Invalid SYS Objects SYMPTOMS Please see the following document for cleaning up these objects: Also, the SYS.KU$_% views will become invalid. Some XDB related objects in the SYS schema are not dropped during the removal of XDB. Select owner, object_name, object_type, status from dba_objects where status = ‘INVALID’ and owner = ‘SYS’ Shutdown For Invalid “SYS” objects by following query: ![]() # IMPORTANT NOTE: You must shutdown and restart the database between removal and reinstall # Master Note for Oracle XML Database (XDB) Install / Deinstallįollowing method is used and tested for oracle version 11g ( 11.2) – XDB Removal and Reinstall on windows (same method can use for Linux just need to change oracle home path for sql script execution).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |