Showing posts with label Oracle add-ons and built-in schemas. Show all posts
Showing posts with label Oracle add-ons and built-in schemas. Show all posts
Friday, March 29, 2019

How to remove the schema OWF_MGR from a database

›
Applicable for Oracle version 12.1.0.2.0. Workflow manager is a component used for Orchestrating of Oracle Warehouse Builder (OWB). If y...
Tuesday, February 27, 2018

How to install APEX in an existing database

›
I have based my receipe on Tim Hall's instructions found at www.oracle-base.com , and I do not want to take credit for this. But the in...
1 comment:
Wednesday, July 12, 2017

How to check if Database Vault is enabled or disabled

›
To check whether or not the Database Vault option is enabled in your database, run the following query as a privileged user: SELECT paramet...
Wednesday, December 21, 2016

How to remove the APEX option from the database

›
cd $ORACLE_HOME/apex sqlplus / as sysdba @apxremov.sql drop public synonym htmldb_system; drop PACKAGE HTMLDB_SYSTEM; If you have older A...
Friday, May 20, 2016

How to handle message "Expected XDB Resources are not there" when OLAP API is invalid after an upgrade

›
Background: After an upgrade, you have invalid components in you registry. To fix the OLAP components you have followed "Oracle Olap ...
Sunday, April 3, 2016

What are the two options XDK and XML in DBA_REGISTRY anyway?

›
What are the two options XDK and XML in DBA_REGISTRY anyway? You see them amongst other components in the DBA_REGISTRY view: select comp_...
Wednesday, March 16, 2016

How to remove a non-used option marked as INVALID in dba_registry

›
If you have invalid components in your database table dba_registry, and those options are not used, you should mark them as removed to avoid...

How to fix error ORA-04063: package body "OLAPSYS.CWM2_OLAP_METADATA_REFRESH" has errors when installing OLAP into a 11g database

›
You are installing OLAP. You receive the following error at the end of the olap.sql script: SQL> @?/olap/admin/olap.sql SYSAUX TEMP; S...
Tuesday, March 8, 2016

How to check for existence of and installation of Data Mining in the database,

›
In this short article, I am following the document "How To Manually Install Data Mining In Oracle 11g? (Doc ID 818314.1)" select...
Friday, December 4, 2015

How to enable OLAP in an Oracle 11gR2 database

›
First, check that the prerequisites are fulfilled. The components below must be installed and valid before proceeding. select comp_id, com...

How to check if the OLAP option is installed in the database

›
select comp_name, version, status from dba_registry where comp_name like '%OLAP%' order by 1 DESC; Typical output if OLAP is insta...
2 comments:
Monday, November 9, 2015

How to install and deinstall Oracle Spatial and Oracle Multimedia

›
The following advice is an excerpt from a Service Request with Oracle support services, on how to administer Spatial and Multimedia: To re...
1 comment:

How to check if spatial and multimedia is installed in the database

›
The following advice was given to me by Oracle Support services, to determine if either of these components are being used in the database: ...
Thursday, October 9, 2014

How to install Oracle Text

›
Based on "Manual Installation, Deinstallation and Verification of Oracle Text 11gR2 (Doc ID 970473.1)" from My Oracle Support 1....