본문 바로가기

Oracle/admin

XDB,JVM install/unInstall

XDB Installation
SQL> CREATE TABLESPACE "XDB"
     LOGGING DATAFILE '/u10/app/oradata/MYDB/xdb01.dbf' SIZE 200M REUSE
     AUTOEXTEND ON   NEXT 50M   MAXSIZE 1500M
     EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;


The catqm.sql script requires the following parameters be passed to it when run:

 A. XDB user password
 B. XDB user default tablespace
       (Any tablespace other than SYSTEM, UNDO and TEMP can be specified.
        The specified tablespace must already exist prior to running the script.)
 C. XDB user temporary tablespace
 D. SecureFiles = YES or NO
       (If YES is specified, the XDB repository will use SecureFile storage.
        If NO is specified, LOBS will be used.
        To use SecureFiles, compatibility must be set to 11.2.
        The tablespace specified for the XDB repository must be using
        Automatic Segment Space Management (ASSM) for SecureFiles to be used.)

Therefore the syntax to run catqm.sql is the following:
 SQL> catqm.sql A B C D

 For Example:
 SQL> spool xdb_install.log
 SQL> set echo on;
 SQL> connect / as sysdba
 SQL> shutdown immediate;
 SQL> startup;
 SQL> @?/rdbms/admin/catqm.sql <XDB pwd> <XDB default tbs> <XDB temporary tbs> <SecureFiles = YES/NO>
 SQL> @?/rdbms/admin/utlrp.sql
-- Check status of XDB
SQL> select comp_name, version, status from dba_registry
     where comp_id = 'XDB';

-- Check for invalid objects owned by XDB
SQL> select owner, object_name, object_type, status from dba_objects
     where status = 'INVALID' and owner = 'XDB';
 SQL> spool off


XDB UnInstallation
SQL> shutdown immediate
SQL> startup
cd $ORACLE_HOME/rdbms/admin
SQL> connect / as sysdba
SQL> set echo on
SQL> spool xdb_removal.log
SQL> @catnoqm.sql
SQL> ALTER TABLESPACE <XDB_TS_NAME> offline;
SQL> DROP TABLESPACE <XDB_TS_NAME> including contents;
SQL>


JVM Installation

SQL> startup mount
SQL> alter system set "_system_trig_enabled" = false scope=memory;
SQL> alter database open;
SQL> @?/javavm/install/initjvm.sql
SQL> @?/xdk/admin/initxml.sql
SQL> @?/xdk/admin/xmlja.sql
SQL> @?/rdbms/admin/catjava.sql
SQL> shutdown immediate;

SQL> startup
SQL> @?/rdbms/admin/utlrp.sql
SQL> select comp_name, version, status from dba_registry;

JVM UnInstallation
SQL> startup mount;
SQL> alter system set "_system_trig_enabled" = false scope=memory;
SQL> alter system enable restricted session;
SQL> alter database open;
SQL> @?/rdbms/admin/catnojav.sql
SQL> @?/xdk/admin/rmxml.sql
SQL> @?/javavm/install/rmjvm.sql
SQL> truncate table java$jvm$status;


'Oracle > admin' 카테고리의 다른 글

Shrink Temporary Tablespace  (0) 2016.04.22
Shrink UNDO tablespace  (0) 2016.04.22
Oracle 11gR2 RAC 기동,중지  (0) 2016.04.19
SET SQLBLANKLINES ON  (0) 2016.04.07
Redo Log File 장애 case  (0) 2016.04.06