Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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;
/