테스트 환경 :
DB : 12.1.0.2
OS : CentOS 6.7
바이너리 레벨에서 키고 끌수 있는 옵션 리스트 입니다.
| Product/Component | Short Name |
|---|---|
| Automated Storage Management | ASM |
| Context Management Text | CTX |
| Oracle Data Mining | DM |
| Database Vault | DV |
| Oracle OLAP | OLAP |
| Oracle Label Security | OLS |
| Oracle Partitioning | PART |
| Real Application Cluster | RAC |
| Real Application Testing | RAT |
11g 부터 사용 가능 한 chopt 툴을 이용해 옵션은 enable/disable 해보 겠습니다.
일단 현재 바이너리의 상태를 확인 해야 합니다.
| Automatic Storage Mgt ON=kfon.o Automatic Storage Mgt OFF=kfoff.o Context Management Text ON=kciwcx.o <<CTX is always enabled and cannot be disabled. Oracle Data Mining ON=dmwdm.o Oracle Data Mining OFF=dmndm.o Oracle Database Vault ON=kzvidv.o Oracle Database Vault OFF=kzvndv.o Oracle OLAP ON=xsyeolap.o Oracle OLAP OFF=xsnoolap.o Oracle Label Security ON= kzlilbac.o Oracle Label Security OFF= kzlnlbac.o Oracle Partitioning ON=kkpoban.o Oracle Partitioning OFF=ksnkkpo.o Real Application Cluster ON=kcsm.o Real Application Cluster OFF=ksnkcs.o Oracle Real Application Testing ON=kecwr.o Oracle Real Application Testing OFF=kecnr.o |
아래 명령어로 조회를 하명 위의 옵션 상태를 알수 있는 정보를 확인 할수 있습니다.
testora.localdomain@oracle:testdb:/etc> cd $ORACLE_HOME/rdbms/lib testora.localdomain@oracle:testdb:/home/oracle/app/oracle/product/12.1.0/rdbms/lib> ar -tv libknlopt.a rw-rw-r-- 94110/42424 5664 Jul 7 18:13 2014 kfoff.o rw-rw-r-- 94110/42424 56600 Jul 7 18:30 2014 ktd.o rw-r--r-- 502/503 22112 Jul 7 02:44 2014 kxmwsd.o rw-r--r-- 502/503 53528 Jul 7 02:46 2014 kciwcx.o rw-rw-r-- 94110/42424 4712 Jul 7 18:27 2014 kprnts.o rw-rw-r-- 94110/42424 4720 Jul 7 18:12 2014 kdzof.o rw-rw-r-- 94110/42424 6360 Jul 7 18:16 2014 kbrsdis.o rw-rw-r-- 94110/42424 4848 Jul 7 18:21 2014 kzanang.o rw-rw-r-- 94110/42424 4720 Jul 7 18:12 2014 kdmof.o rw-rw-r-- 94110/42424 1566824 Jul 7 18:27 2014 jox.o rw-r--r-- 502/503 6128 Jul 7 02:13 2014 ksnkcs.o rw-r--r-- 502/503 4712 Jul 7 02:24 2014 kkpoban.o rw-r--r-- 502/503 4672 Jul 7 02:40 2014 dmwdm.o rw-r--r-- 502/503 10104 Jul 7 02:38 2014 xsyeolap.o rw-r--r-- 502/503 4704 Jul 7 02:17 2014 kecwr.o For IBM AIX $ cd $ORACLE_HOME/rdbms/lib $ ar -X64 -tv libknlopt.a
RAT 옵션을 disable 해보도록 하겠습니다.
rw-r--r-- 502/503 4704 Jul 7 02:17 2014 kecwr.o
지금은 옵션이 켜 있는 것을 확인 할수 있습니다.
% 주의 할 점은 옵션 변경시 DB는 다운된 상태로 진행을 해야 합니다. %
testora.localdomain@oracle:testdb:/home/oracle> chopt disable rat Writing to /home/oracle/app/oracle/product/12.1.0/install/disable_rat.log... /usr/bin/make -f /home/oracle/app/oracle/product/12.1.0/rdbms/lib/ins_rdbms.mk rat_off ORACLE_HOME=/home/oracle/app/oracle/product/12.1.0 /usr/bin/make -f /home/oracle/app/oracle/product/12.1.0/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/home/oracle/app/oracle/product/12.1.0 testora.localdomain@oracle:testdb:/home/oracle> sqlplus / as sysdba sys@testdb> select * from v$option; PARAMETER VALUE CON_ID --------------------------------------------- ---------------------------------------- ---------- Partitioning TRUE 0 Objects TRUE 0 Real Application Clusters FALSE 0 Advanced replication TRUE 0 Bit-mapped indexes TRUE 0 Connection multiplexing TRUE 0 Connection pooling TRUE 0 Database queuing TRUE 0 Incremental backup and recovery TRUE 0 Instead-of triggers TRUE 0 Parallel backup and recovery TRUE 0 Parallel execution TRUE 0 Parallel load TRUE 0 Point-in-time tablespace recovery TRUE 0 Fine-grained access control TRUE 0 Proxy authentication/authorization TRUE 0 Change Data Capture TRUE 0 Plan Stability TRUE 0 Online Index Build TRUE 0 Coalesce Index TRUE 0 Managed Standby TRUE 0 Materialized view rewrite TRUE 0 Database resource manager TRUE 0 Spatial TRUE 0 Automatic Storage Management TRUE 0 Export transportable tablespaces TRUE 0 Transparent Application Failover TRUE 0 Fast-Start Fault Recovery TRUE 0 Sample Scan TRUE 0 Duplexed backups TRUE 0 Java TRUE 0 OLAP Window Functions TRUE 0 Block Media Recovery TRUE 0 Fine-grained Auditing TRUE 0 Application Role TRUE 0 Enterprise User Security TRUE 0 Oracle Data Guard TRUE 0 Oracle Label Security FALSE 0 OLAP TRUE 0 Basic Compression TRUE 0 Join index TRUE 0 Trial Recovery TRUE 0 Advanced Analytics TRUE 0 Online Redefinition TRUE 0 Streams Capture TRUE 0 File Mapping TRUE 0 Block Change Tracking TRUE 0 Flashback Table TRUE 0 Flashback Database TRUE 0 Transparent Data Encryption TRUE 0 Backup Encryption TRUE 0 Unused Block Compression TRUE 0 Oracle Database Vault FALSE 0 Result Cache TRUE 0 SQL Plan Management TRUE 0 SecureFiles Encryption TRUE 0 Real Application Testing FALSE 0 Flashback Data Archive TRUE 0 DICOM TRUE 0 Active Data Guard TRUE 0 Server Flash Cache TRUE 0 Advanced Compression TRUE 0 XStream TRUE 0 Deferred Segment Creation TRUE 0 Unified Auditing FALSE 0 Management Database FALSE 0 I/O Server FALSE 0 ASM Proxy Instance FALSE 0 Exadata Discovery TRUE 0 Data Mining TRUE 0 Global Data Services TRUE 0 Adaptive Execution Plans TRUE 0 Table Clustering TRUE 0 Zone Maps TRUE 0 Real Application Security TRUE 0 Privilege Analysis TRUE 0 Data Redaction TRUE 0 Cross Transportable Backups TRUE 0 Cache Fusion Lock Accelerator TRUE 0 Snapshot time recovery TRUE 0 Heat Map TRUE 0 Automatic Data Optimization TRUE 0 Transparent Sensitive Data Protection TRUE 0 In-Memory Column Store TRUE 0 Advanced Index Compression TRUE 0 In-Memory Aggregation TRUE 0 86 rows selected. testora.localdomain@oracle:testdb:/home/oracle/app/oracle/product/12.1.0/rdbms/lib> ar -tv libknlopt.a rw-rw-r-- 94110/42424 5664 Jul 7 18:13 2014 kfoff.o rw-rw-r-- 94110/42424 56600 Jul 7 18:30 2014 ktd.o rw-r--r-- 502/503 22112 Jul 7 02:44 2014 kxmwsd.o rw-r--r-- 502/503 53528 Jul 7 02:46 2014 kciwcx.o rw-rw-r-- 94110/42424 4712 Jul 7 18:27 2014 kprnts.o rw-rw-r-- 94110/42424 4720 Jul 7 18:12 2014 kdzof.o rw-rw-r-- 94110/42424 6360 Jul 7 18:16 2014 kbrsdis.o rw-rw-r-- 94110/42424 4848 Jul 7 18:21 2014 kzanang.o rw-rw-r-- 94110/42424 4720 Jul 7 18:12 2014 kdmof.o rw-rw-r-- 94110/42424 1566824 Jul 7 18:27 2014 jox.o rw-r--r-- 502/503 6128 Jul 7 02:13 2014 ksnkcs.o rw-r--r-- 502/503 4712 Jul 7 02:24 2014 kkpoban.o rw-r--r-- 502/503 4672 Jul 7 02:40 2014 dmwdm.o rw-r--r-- 502/503 10104 Jul 7 02:38 2014 xsyeolap.o rw-r--r-- 502/503 4816 Jul 7 02:17 2014 kecnr.o
rw-r--r-- 502/503 4816 Jul 7 02:17 2014 kecnr.o
뷰에서 본 옵션 과 Rat 관련 파일이 disable 된 것을 확인 할 수 있다.
testora.localdomain@oracle:testdb:/home/oracle/12.1.0/grid/bin> chopt enable rat Writing to /home/oracle/app/oracle/product/12.1.0/install/enable_rat.log... /usr/bin/make -f /home/oracle/app/oracle/product/12.1.0/rdbms/lib/ins_rdbms.mk rat_on ORACLE_HOME=/home/oracle/app/oracle/product/12.1.0 /usr/bin/make -f /home/oracle/app/oracle/product/12.1.0/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/home/oracle/app/oracle/product/12.1.0 testora.localdomain@oracle:testdb:/home/oracle/12.1.0/grid/bin> testora.localdomain@oracle:testdb:/home/oracle/12.1.0/grid/bin> ./srvctl start database -db testdb testora.localdomain@oracle:testdb:/home/oracle/12.1.0/grid/bin> sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 3 15:36:19 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options Loading login.sql file... sys@testdb> select * from v$option; PARAMETER VALUE CON_ID --------------------------------------------- ---------------------------------------- ---------- Partitioning TRUE 0 Objects TRUE 0 Real Application Clusters FALSE 0 Advanced replication TRUE 0 Bit-mapped indexes TRUE 0 Connection multiplexing TRUE 0 Connection pooling TRUE 0 Database queuing TRUE 0 Incremental backup and recovery TRUE 0 Instead-of triggers TRUE 0 Parallel backup and recovery TRUE 0 Parallel execution TRUE 0 Parallel load TRUE 0 Point-in-time tablespace recovery TRUE 0 Fine-grained access control TRUE 0 Proxy authentication/authorization TRUE 0 Change Data Capture TRUE 0 Plan Stability TRUE 0 Online Index Build TRUE 0 Coalesce Index TRUE 0 Managed Standby TRUE 0 Materialized view rewrite TRUE 0 Database resource manager TRUE 0 Spatial TRUE 0 Automatic Storage Management TRUE 0 Export transportable tablespaces TRUE 0 Transparent Application Failover TRUE 0 Fast-Start Fault Recovery TRUE 0 Sample Scan TRUE 0 Duplexed backups TRUE 0 Java TRUE 0 OLAP Window Functions TRUE 0 Block Media Recovery TRUE 0 Fine-grained Auditing TRUE 0 Application Role TRUE 0 Enterprise User Security TRUE 0 Oracle Data Guard TRUE 0 Oracle Label Security FALSE 0 OLAP TRUE 0 Basic Compression TRUE 0 Join index TRUE 0 Trial Recovery TRUE 0 Advanced Analytics TRUE 0 Online Redefinition TRUE 0 Streams Capture TRUE 0 File Mapping TRUE 0 Block Change Tracking TRUE 0 Flashback Table TRUE 0 Flashback Database TRUE 0 Transparent Data Encryption TRUE 0 Backup Encryption TRUE 0 Unused Block Compression TRUE 0 Oracle Database Vault FALSE 0 Result Cache TRUE 0 SQL Plan Management TRUE 0 SecureFiles Encryption TRUE 0 Real Application Testing TRUE 0 Flashback Data Archive TRUE 0 DICOM TRUE 0 Active Data Guard TRUE 0 Server Flash Cache TRUE 0 Advanced Compression TRUE 0 XStream TRUE 0 Deferred Segment Creation TRUE 0 Unified Auditing FALSE 0 Management Database FALSE 0 I/O Server FALSE 0 ASM Proxy Instance FALSE 0 Exadata Discovery TRUE 0 Data Mining TRUE 0 Global Data Services TRUE 0 Adaptive Execution Plans TRUE 0 Table Clustering TRUE 0 Zone Maps TRUE 0 Real Application Security TRUE 0 Privilege Analysis TRUE 0 Data Redaction TRUE 0 Cross Transportable Backups TRUE 0 Cache Fusion Lock Accelerator TRUE 0 Snapshot time recovery TRUE 0 Heat Map TRUE 0 Automatic Data Optimization TRUE 0 Transparent Sensitive Data Protection TRUE 0 In-Memory Column Store TRUE 0 Advanced Index Compression TRUE 0 In-Memory Aggregation TRUE 0 86 rows selected. sys@testdb> exit testora.localdomain@oracle:testdb:/home/oracle/app/oracle/product/12.1.0/rdbms/lib> chopt enable rat Writing to /home/oracle/app/oracle/product/12.1.0/install/enable_rat.log... /usr/bin/make -f /home/oracle/app/oracle/product/12.1.0/rdbms/lib/ins_rdbms.mk rat_on ORACLE_HOME=/home/oracle/app/oracle/product/12.1.0 /usr/bin/make -f /home/oracle/app/oracle/product/12.1.0/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/home/oracle/app/oracle/product/12.1.0 testora.localdomain@oracle:testdb:/home/oracle/app/oracle/product/12.1.0/rdbms/lib> ar -tv libknlopt.a rw-rw-r-- 94110/42424 5664 Jul 7 18:13 2014 kfoff.o rw-rw-r-- 94110/42424 56600 Jul 7 18:30 2014 ktd.o rw-r--r-- 502/503 22112 Jul 7 02:44 2014 kxmwsd.o rw-r--r-- 502/503 53528 Jul 7 02:46 2014 kciwcx.o rw-rw-r-- 94110/42424 4712 Jul 7 18:27 2014 kprnts.o rw-rw-r-- 94110/42424 4720 Jul 7 18:12 2014 kdzof.o rw-rw-r-- 94110/42424 6360 Jul 7 18:16 2014 kbrsdis.o rw-rw-r-- 94110/42424 4848 Jul 7 18:21 2014 kzanang.o rw-rw-r-- 94110/42424 4720 Jul 7 18:12 2014 kdmof.o rw-rw-r-- 94110/42424 1566824 Jul 7 18:27 2014 jox.o rw-r--r-- 502/503 6128 Jul 7 02:13 2014 ksnkcs.o rw-r--r-- 502/503 4712 Jul 7 02:24 2014 kkpoban.o rw-r--r-- 502/503 4672 Jul 7 02:40 2014 dmwdm.o rw-r--r-- 502/503 10104 Jul 7 02:38 2014 xsyeolap.o rw-r--r-- 502/503 4704 Jul 7 02:17 2014 kecwr.o testora.localdomain@oracle:testdb:/home/oracle/app/oracle/product/12.1.0/rdbms/lib>
rw-r--r-- 502/503 4704 Jul 7 02:17 2014 kecwr.o
다시 enable 된 파일을 확인 할 수 있습니다.
동작 자체는 10g 까지 사용된 make 를 이용한 ins_rdbms.mk 를 이용한 로그를 확인 할 수 있습니다.
수작업으로 했던 일련의 작업을 tool 로써 지원이 되니 11g 이상 DB 에서는 간편하게 사용이 가능 할거 같습니다.
참고 : 948061.1
유용한 정보 감사합니다.~~