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;
/