DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, October 4, 2016

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;

1 comment:

Sridevi Koduru (Oracleappstechnical.com) said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.