CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_REGISTRY_SERVER
Version 11.1
 
General
Contains constants used to identify server components and the associated upgrade/downgrade/patch/reload scripts.
Source {ORACLE_HOME}/rdbms/admin/catcrsc.sql

Pathname Constants
Name Data Type Value
AMD_path VARCHAR2(50) '?/olap/admin/';
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) '?/ultrasearch/admin/';
XDB_path VARCHAR2(50)  '?/rdbms/admin/';
XML_path VARCHAR2(50)  '?/xdk/admin/';
XOQ_path VARCHAR2(50) '?/olap/admin/';

Prefix Constants
Name Data Type Value
AMD_prefix VARCHAR2(3) 'amd';
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';

Required Option Names
Name Data Type Value
AMD_option VARCHAR2(30) 'OLAP';
APEX_option VARCHAR2(30) NULL;
APS_option VARCHAR2(30) 'OLAP';
CATJAVA_option VARCHAR2(30) NULL;
CONTEXT_option VARCHAR2(30) NULL;
DV_option VARCHAR2(30) 'Oracle Label Security';
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) 'Oracle Label Security';
ORDIM_option VARCHAR2(30) NULL;
OWM_option VARCHAR2(30) NULL;
RAC_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';
Data Type TYPE component_table IS TABLE OF VARCHAR2(30);
/
Dependencies STANDARD
Security Model Execute is not granted
 
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
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [185 users online]    © 2010 psoug.org