![]() Oracle Enterprise Manager Grid Control: If you have Oracle Enterprise Manager installed, you can use Grid Control to manage Oracle Automatic Storage Management functions such as migrating an existing database to Oracle Automatic Storage Management, checking the status of the Oracle Automatic Storage Management instance, checking the performance of the Oracle Automatic Storage Management disk groups, creating or dropping Oracle Automatic Storage Management disk groups, and so on. It also enables you to create and configure disk groups, Oracle Automatic Storage Management volumes and Oracle Automatic Storage Management File Systems (ASMFS). Oracle Automatic Storage Management Configuration Assistant: Oracle Automatic Storage Management Configuration Assistant (ASMCA) is an interactive utility that enables you to create an Oracle Automatic Storage Management instance or upgrade existing Oracle Automatic Storage Management instances. To manage Oracle Automatic Storage Management, you can use the following tools:Īsmcmd: This command-line tool lets you manage Oracle Automatic Storage Management disk group files and directories.Īsmtool: This command-line tool is required to stamp the disks to create or modify disk groups later on after the database installation. The syntax to run catqm.6.3.2 Oracle Automatic Storage Management Utilities * 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. |