Oracle DBMS_REGISTRY_SERVER
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
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 None
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_SYS
Packages

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-2014 Daniel A. Morgan All Rights Reserved