Oracle DBMS_REGISTRY_SERVER
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
Purpose Stand-alone header containing constants used to identify server components and the associated upgrade/downgrade/patch/reload scripts
AUTHID CURRENT_USER
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);
component CONSTANT component_table := component_table (
  'JAVAVM',
  'XML',
  'CATJAVA',
  'APS',
  'AMD',
  'OLS',
  'DV',
  'CONTEXT',
  'OWM',
  'MGW',
  'RAC',
  'XDB',
  'ORDIM',
  'SDO',
  'ODM',
  'WK',
  'EXF',
  'RUL',
  'XOQ');
END dbms_registry_server;
/
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
Built-in Functions
Built-in Packages
DBMS_REGISTRY
DBMS_REGISTRY_EXTENDED
DBMS_REGISTRY_SIMPLE
DBMS_REGISTRY_SYS
What's New In 21c
What's New In 23c

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