If Oracle XML DB has thus been automatically installed, and if you want to use Oracle XML DB, then, after the upgrade operation, you must set the database compatibility to at least 12.1.0.1. You cannot uninstall it, and if Oracle XML DB is not already installed in your database prior to an upgrade to Oracle Database 12c Release 1 (12.1.0.1) or later, then it is automatically installed in tablespace SYSAUX during the upgrade. Oracle XML DB is now a mandatory component of Oracle Database. Shutdown - substitute the parameters with appropriate off # IMPORTANT: You must shutdown and restart the database between removal and reinstall # Therefore the syntax to run catqm.sql is the following: The tablespace specified for the XDB repository must be usingĪutomatic 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. The specified tablespace must already exist prior to running the script.Ĭreate tablespace xdb datafile ‘/oradata//xdb01.dbf’ size 350M autoextend on segment space management auto ) (Any tablespace other than SYSAUX, SYSTEM, UNDO and TEMP can be specified. The catqm.sql script requires the following parameters be passed to it when run: (Doc ID 1269470.1) XDB Deinstallation script catnoqm.sql leads to Invalid SYS Objects 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. ***The following is being referenced by Oracle Doc ID 1292089.1 ******
0 kommentar(er)
