메뉴 건너뛰기

Korea Oracle User Group

Install/Configuration

How to Enable/Disable Oracle Binary Option

Talros 2016.03.09 11:45 조회 수 : 8620

 

 테스트 환경 :

  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

 

 

 

번호 제목 글쓴이 날짜 조회 수
40 Oracle Database 19c Patch Update(단일 인스턴스 오라클 DB 19.3 에서 19.9로 RU Update) 명품관 2020.11.24 34923
39 New version of our Hands-On Lab available for download "Upgrade/Migrate/Consolidate to Oracle 12c" HOL 명품관 2015.12.22 8992
» How to Enable/Disable Oracle Binary Option [1] Talros 2016.03.09 8620
37 19c RAC OJVM 패치작업 우뽕 2020.04.22 5209
36 Oracle RAC RU rolling patching from 19.3 to 19.9.0.0.201020(Patch 31750108) [1] file 명품관 2020.12.08 5152
35 Oracle 19c RAC 설치 with Oracle Linux 8.2 - 2 (Grid Infrastructure) file 명품관 2020.11.19 4933
34 Oracle 19c RAC 설치 with Oracle Linux 8.2 - 1 (OS 및 스토리지 설정) 명품관 2020.11.14 4741
33 ASM 에 spfile 등록 및 삭제 하기 우뽕 2020.07.27 4432
32 오라클 21c RAC 설치 with Oracle Linux 8.2 - 1 (OS 및 스토리지 설정) 명품관 2021.12.01 2986
31 Oracle 19c RAC 설치 with Oracle Linux 8.2 - 5 (DBCA로 Database 생성) file 명품관 2020.11.19 2805
30 19c RAC 2Node 설치 -1 [ 환경 ,OS 세팅 ] file 우뽕 2020.04.14 2647
29 19c RAC - Manual Patch 적용방법 우뽕 2020.05.05 2334
28 Oracle EM(Enterprise Manager) 13.4 설치 및 구성 - 2(EM 설치) file 명품관 2020.11.27 2241
27 Oracle 19c RAC 설치 with Oracle Linux 8.2 - 3 (사용할 Disk Group 생성) file 명품관 2020.11.19 1478
26 DBCA/DBUA 사용시 마지막 단계 Finish 버튼 클릭 후 행 현상 발생 시 체크 사항 명품관 2015.12.17 1460
25 19c RAC 2Node 설치-8 [ Patch ] 우뽕 2020.04.22 1396
24 19c RAC 2Node 삭제 하기 file 우뽕 2020.04.22 1336
23 메뉴얼하게 DB 추가 작업 - GRID 리소스에 DB 추가 작업 우뽕 2020.07.27 1250
22 Oracle EM(Enterprise Manager) 13.4 설치 및 구성 - 1(Repository DB 설치) file 명품관 2020.11.23 1146
21 Automatic Storage Management (ASM) 사용시 고려해야 할 사항 [2] 우뽕 2020.02.06 1041
위로