Oracle DBMS_REGISTRY_SERVER
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Stand-alone header containing constants used to identify server components and the associated upgrade/downgrade/patch/reload scripts
AUTHID Not Applicable
Constants
Name Data Type Value
Miscellaneous
nothing_script VARCHAR2(50) '?/rdbms/admin/nothing.sql'
Option Names
APEX_option VARCHAR2(30) NULL
APS_option VARCHAR2(30) 'OLAP'
CATJAVA_option VARCHAR2(30) NULL
CONTEXT_option VARCHAR2(30) NULL
DV_option VARCHAR2(30) NULL
EM_option VARCHAR2(30) NULL
EXF_option VARCHAR2(30) NULL
JAVAVM_option VARCHAR2(30) 'Java'
MGW_option VARCHAR2(30) NULL
ODM_option VARCHAR2(30) 'Data Mining'
OLS_option VARCHAR2(30) NULL
ORDIM_option VARCHAR2(30) NULL
OWM_option VARCHAR2(30) NULL
MGW_option VARCHAR2(30) NULL
RUL_option VARCHAR2(30) NULL
SDO_option VARCHAR2(30) 'Spatial
WK_option VARCHAR2(30) NULL
XDB_option VARCHAR2(30) NULL
XML_option VARCHAR2(30) NULL
XOQ_option VARCHAR2(30) 'OLAP'
Path Names
APEX_path VARCHAR2(50) '?/apex/'
APS_path VARCHAR2(50) '?/olap/admin/'
CATJAVA_path VARCHAR2(50) '?/rdbms/admin/'
CONTEXT_path VARCHAR2(50) '?/ctx/admin/'
DV_path VARCHAR2(50) '?/rdbms/admin/'
EM_path VARCHAR2(50) '?/sysman/admin/emdrep/sql/'
EXF_path VARCHAR2(50) '?/rdbms/admin/'
JAVAVM_path VARCHAR2(50) '?/javavm/install/'
MGW_path VARCHAR2(50) '?/mgw/admin/'
ODM_path VARCHAR2(50) '?/rdbms/admin/'
OLS_path VARCHAR2(50) '?/rdbms/admin/'
ORDIM_path VARCHAR2(50) '?/ord/im/admin/'
OWM_path VARCHAR2(50) '?/rdbms/admin/'
RAC_path VARCHAR2(50) '?/rdbms/admin/'
RUL_path VARCHAR2(50) '?/rdbms/admin/'
SDO_path VARCHAR2(50) '?/md/admin/'
WK_path VARCHAR2(50) '?/rdbms/admin/'
XDB_path VARCHAR2(50) '?/rdbms/admin/'
XML_path VARCHAR2(50) '?/xdk/admin/'
XOQ_path VARCHAR2(50) '?/olap/admin/'
Prefixes
APEX_prefix VARCHAR2(3) 'apx'
APS_prefix VARCHAR2(3) 'aps'
CATJAVA_prefix VARCHAR2(3) 'jav'
CONTEXT_prefix VARCHAR2(3) 'ctx'
DV_prefix VARCHAR2(3) 'dv'
EM_prefix VARCHAR2(3) 'em'
EXF_prefix VARCHAR2(3) 'exf'
JAVAVM_prefix VARCHAR2(3) 'jvm'
MGW_prefix VARCHAR2(3) 'mgw'
ODM_prefix VARCHAR2(3) 'odm'
OLS_prefix VARCHAR2(3) 'ols'
ORDIM_prefix VARCHAR2(3) 'im'
OWM_prefix VARCHAR2(3) 'owm'
RAC_prefix VARCHAR2(3) NULL
RUL_prefix VARCHAR2(3) 'rul'
SDO_prefix VARCHAR2(3) 'sdo'
WK_prefix VARCHAR2(3) 'wk'
XDB_prefix VARCHAR2(3) 'xdb'
XML_prefix VARCHAR2(3) 'xml'
XOQ_prefix VARCHAR2(3) 'xoq'
Data Types TYPE component_table IS TABLE OF VARCHAR2(30);
/
Dependencies STANDARD only
Documented No
First Available Unknown
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/catcrsc.sql
 
Demo
?/rdbms/admin/cmpdbmig.sql Rem =====================================================================
Rem Upgrade Intermedia
Rem =====================================================================

SELECT dbms_registry_sys.dbupg_script('ORDIM') AS dbmig_name
FROM DUAL;
@&dbmig_file

Rem If Spatial upgrade,
Rem first install ORDIM if it is not loaded
BEGIN
  IF dbms_registry.is_loaded('ORDIM') IS NULL AND
    dbms_registry.is_loaded('SDO') IS NOT NULL THEN
    :dbinst_name := dbms_registry_server.ORDIM_path || 'imupins.sql';

    EXECUTE IMMEDIATE 'CREATE USER si_informtn_schema IDENTIFIED BY
    ordsys ' || 'ACCOUNT LOCK PASSWORD EXPIRE ' || 'DEFAULT TABLESPACE
    SYSAUX';
  ELSE
    :dbinst_name := dbms_registry.nothing_script;
  END IF;
END;
/

Related Topics
DBMS_REGISTRY
DBMS_REGISTRY_EXTENDED
DBMS_REGISTRY_SIMPLE
DBMS_REGISTRY_SYS
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved