View my complete profile
Tuesday, March 9, 2010
INSTALL DATABASE COMPONENTS
INSTALL DATABASE COMPONENTS
To check which components are presently installed run this query.
SELECT comp_name || ' : '||version|| ' : '|| status FROM dba_registry;
SQL> SELECT comp_name || ' : '||version|| ' : '|| status FROM dba_registry;
COMP_NAME||':'||VERSION||':'||STATUS
--------------------------------------------------------------------------------
Oracle Database Catalog Views : 10.2.0.4.0 : VALID
Oracle Database Packages and Types : 10.2.0.4.0 : VALID
JServer JAVA Virtual Machine : 10.2.0.4.0 : VALID
Oracle XDK : 10.2.0.4.0 : VALID
Oracle Database Java Packages : 10.2.0.4.0 : VALID
Oracle Expression Filter : 10.2.0.4.0 : VALID
Oracle XML Database : 10.2.0.4.0 : VALID
----------------------------------------------------------------------------------------------------------------------------
install components missing:
===========================
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=472937.1
SQL> SELECT comp_name || ' : '||version|| ' : '|| status FROM dba_registry;
COMP_NAME||':'||VERSION||':'||STATUS
--------------------------------------------------------------------------------
Oracle Database Catalog Views : 10.2.0.4.0 : VALID
Oracle Database Packages and Types : 10.2.0.4.0 : VALID
JServer JAVA Virtual Machine : 10.2.0.4.0 : VALID
Oracle XDK : 10.2.0.4.0 : VALID
Oracle Database Java Packages : 10.2.0.4.0 : VALID
Oracle Expression Filter : 10.2.0.4.0 : VALID
Oracle XML Database : 10.2.0.4.0 : VALID
@?/javavm/install/initjvm.sql;
http://www.adp-gmbh.ch/ora/xml_db/install.html
Oracle XML Database (http://www.lorentzcenter.nl/awcourse/oracle/appdev.920/a96620/appaman.htm#637391)
===================
@?/rdbms/admin/catqm.sql change_on_install XDB TEMP
Reconnect to SYS again and run the following:
catxdbj.sql #Load xdb java library
@?/xdk/admin/initxml.sql;
@?/xdk/admin/xmlja.sql;
@?/rdbms/admin/catjava.sql;
@?/rdbms/admin/catexf.sql;
for installing [Oracle XML Database]
1) create tablespace XDB
2) @?/rdbms/admin/catqm xml_password xdb temp
--->[ eg: catqm
create tablespace XDB
datafile '/ora22/u01/oracle/str2/data/xdb.dbf' size 500M;
@?/rdbms/admin/catqm xml_passwd XDB temp
SQL> select username , password from dba_users where username='XDB';
USERNAME PASSWORD
------------------------------ ------------------------------
XDB FD6C945857807E3C
alter user xdb identified by values 'FD6C945857807E3C':
----------------
hanmant: @?/javavm/install/initjvm.sql;
@?/xdk/admin/initxml.sql;
@?/xdk/admin/xmlja.sql;
@?/rdbms/admin/catjava.sql;
@?/rdbms/admin/catexf.sql;
11:06:34 AM: hanmant: @?/rdbms/admin/catalog.sql;
@?/rdbms/admin/catblock.sql;
@?/rdbms/admin/catproc.sql;
@?/rdbms/admin/catoctk.sql;
@?/rdbms/admin/owminst.plb;
@?/sqlplus/admin/pupbld.sql;
@?/sqlplus/admin/help/hlpbld.sql
@?/sqlplus/admin/helphelpus.sql;
$ORACLE_HOME/dm/admin/dmuserld.sql
for installing ORACLE TEXT:
---------------------------
https://support.oracle.com/CSP/main/article?cmd=show&id=280713.1&type=NOT
SQL> connect SYS/password@tns_ as SYSDBA
SQL> spool text_install.txt
SQL> @?/ctx/admin/catctx.sql CTXSYS SYSAUX TEMP NOLOCK
for manually installing ORACLE DATA MINING:
-------------------------------------------
https://support.oracle.com/CSP/main/article?cmd=show&id=420791.1&type=NOT
For RDBMS 10.2.x
1. Set ORACLE_HOME and ORACLE_SID.
2. START SQLPlus and connect with SYS user as SYSDBA.
3. Execute the following commands:
Unix - Linux
SQL> run $ORACLE_HOME/rdbms/admin/dminst.sql SYSAUX TEMP
SQL> run $ORACLE_HOME/rdbms/admin/odmpatch.sql
SQL> run $ORACLE_HOME/rdbms/admin/utlrp.sql
Windows
SQL> start %ORACLE_HOME%\rdbms\admin\dminst.sql SYSAUX TEMP
SQL> start %ORACLE_HOME%\rdbms\admin\odmpatch.sql
SQL> start %ORACLE_HOME%\rdbms\admin\utlrp.sql
4. Ensure 'Oracle Data Mining' is at Valid status in dba_registry by executing the following query:
SQL> select COMP_NAME,VERSION,STATUS from dba_registry where COMP_NAME='Oracle Data Mining';
SQL> SELECT comp_name || ' : '||version|| ' : '|| status FROM dba_registry;
COMP_NAME||':'||VERSION||':'||STATUS
--------------------------------------------------------------------------------
Oracle Text : 10.2.0.3.0 : VALID
Oracle Workspace Manager : 10.2.0.1.0 : VALID
Oracle Data Mining : 10.2.0.3.0 : VALID
Oracle XML Database : 10.2.0.3.0 : VALID
Oracle Expression Filter : 10.2.0.3.0 : VALID
Oracle Database Catalog Views : 10.2.0.3.0 : VALID
Oracle Database Packages and Types : 10.2.0.3.0 : VALID
JServer JAVA Virtual Machine : 10.2.0.3.0 : VALID
Oracle XDK : 10.2.0.3.0 : VALID
Oracle Database Java Packages : 10.2.0.3.0 : VALID
10 rows selected.
No comments:
Post a Comment