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.

1 comment:

rajeesh said...

Hi Javeed,

I red your document on installing database componenets.It is very much informative.
I want clear step by step of installing oracle xml db in oracle databaes server.
My db version is 10g.
Can you please give me these details it will great help for me.

Thanks,
Raj