Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Removing olap from CDB and all PDBs from default 19c EE installation

The Oracle database installation guide for Linux has a section for removing options that are installed by default on the Enterprise Edition database, one of them being olap. To remove olap the guide indicates the following commands:

srvctl stop database -d [DBName]

chopt disable olap

srvctl stop database -d [DBName]

There is a note that says after enabling or disabling OLAP you need to run sys.xoq_validate and sys.aps_validate to update the database registry.

I assume this means that in a CDB environment we need to use the catcon.pl perl script to update the CDB and all of the PDBs to update the registries. You can manually run the validate procedures on each CDB and PDB except for the pdb$seed database which is read only.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center