Installing various Database Components

col COMP_ID for a20
col VERSION for a15
col STATUS for a10
col COMP_NAME for a40
select COMP_ID, COMP_NAME, VERSION, STATUS from DBA_REGISTRY order by STATUS ;

 @?/rdbms/admin/utlrp

col OWNER for a30
col OBJECT_NAME for a30
select owner, object_name, object_type from dba_objects where status=’INVALID’ order by object_name;

connect / as sysdba
@?/ord/im/admin/iminst.sql;
connect / as SYSDBA
revoke AQ_ADMINISTRATOR_ROLE from ODM;

connect / as SYSDBA
@?/javavm/install/initjvm.sql;
@?/xdk/admin/initxml.sql;
@?/xdk/admin/xmlja.sql;
@?/rdbms/admin/catjava.sql;
@?/rdbms/admin/catexf.sql;

connect / as SYSDBA
@?/rdbms/admin/catqm.sql change_on_install SYSAUX TEMP;
@?/rdbms/admin/catxdbj.sql;
@?/rdbms/admin/catrul.sql;

connect / as SYSDBA
@?/ctx/admin/catctx change_on_install SYSAUX TEMP NOLOCK;
connect “CTXSYS”/”change_on_install”
@?/ctx/admin/defaults/dr0defin.sql “AMERICAN”;

@?/rdbms/admin/catqm.sql change_on_install SYSAUX TEMP;
@?/rdbms/admin/catxdbj.sql;
@?/rdbms/admin/catrul.sql;

@?/rdbms/admin/catproc.sql;                                                                      
@?/rdbms/admin/catoctk.sql;                                                                    
@?/rdbms/admin/owminst.plb;
@?/rdbms/admin/catldap.sql;

connect / as SYSDBA
@?/olap/admin/olap.sql SYSAUX TEMP;

  • October 4, 2016 | 14 views