Oracle DB option Disable /Enable 하는 문서 공유 합니다.
필요할때 발생 시 버전에 맞게 수행 하시면 됩니다.
For Database version 11g Release 2 (11.2.x).
On both Unix and Windows we use the chopt tool (available in 11.2) to disable Oracle Data Mining in the database.
- On Linux/Unix platform as below:
$ cd $ORACLE_HOME/bin
$ srvctl stop database -d myDb
$ chopt disable dm
$ srvctl start database -d myDb
- On Windows platform as below:
1. Shut down the database with srvctl or SQL*Plus:
srvctl stop database -d myDb2. Stop the database service, OracleServiceSID, using the Services program in Control Panel.
3. Run the following commands:cd %ORACLE_HOME%/bin
chopt disable dm4. Start the database service, OracleServiceSID, using the Services program in Control Panel.
5. Start up the database:
srvctl start database -d myDb
For Database version 12c (12.1.x)
CHOPT can be used as per Oracle Document: Enabling and Disabling Database Options
The following example shows how to use the chopt tool to enable and disable the Oracle Data Mining option in an Oracle Database called Sales:
cd $ORACLE_HOME/bin
srvctl stop database -d Sales
chopt [ enable | disable] dmsrvctl start database -d Sales
For Database version 12.2
ODM is part of Oracle Advanced Analytics (OAA).To disable ODM:chopt disable oaa
https://docs.oracle.com/database/121/LADBI/post_inst_task.htm#LADBI5600
8.3.6 Enabling and Disabling Database Options
When you install Oracle Database, some options are enabled and others are disabled. To enable or disable a particular database feature for an Oracle home, shut down the database and use the chopt
tool. See Example 8-1.
The chopt
tool is a command-line utility that is located in the ORACLE_HOME/
bin
directory. The syntax for chopt
is:
chopt [ enable | disable] db_option
The possible values for db_option
are described in the following table:
Value | Description |
---|---|
dm |
Oracle Data Mining RDBMS Files |
olap |
Oracle OLAP |
partitioning |
Oracle Partitioning |
rat |
Oracle Real Application Testing |
Example 8-1 Complete Example of Running the Chopt Tool
To enable the Oracle Data Mining option in your Oracle binary files, use the following command:
cd $ORACLE_HOME/bin srvctl stop database -d myDb chopt enable dm srvctl start database -d myDb
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
14 | Schema Password 복사 하기 | Talros | 2016.10.05 | 3290 |
13 | Block Cleanout(블럭 클린아웃) | 명품관 | 2016.09.23 | 1520 |
12 | Fixed Table에 대한 권한은 직접적으로 부여되지 않는다. | 명품관 | 2016.08.26 | 2699 |
11 | Oracle Archive log 사용량 확인(GV$ARCHIVED_LOG) [1] | 에밀리오 | 2016.08.04 | 11253 |
10 | Oracle Resource Limit를 이용한 간단한 Parameter Check (GV$RESOURCE_LIMIT) | 에밀리오 | 2016.07.15 | 2263 |
9 | Oracle VMSTAT을 이용한 CPU 사용량 활용법 | 에밀리오 | 2016.07.14 | 910 |
8 | Kill Session Script (GV$SESSION) | 에밀리오 | 2016.07.12 | 2145 |
7 | Active Session History를 이용한 TOP SQL 분석 (GV$ACTIVE_SESSION_HISTORY) | 에밀리오 | 2016.07.12 | 1211 |
6 | DB에 생성된 ROLE의 생성 정보 확인 [2] | 명품관 | 2016.05.31 | 928 |
5 | 내가 돌린 SQL ID 찾기 [1] | Talros | 2016.05.12 | 8821 |
4 | 테이블 컬럼의 Default 값에 대한 흔적은 Dictionary에 계속 남게 된다. | 명품관 | 2016.04.05 | 1590 |
3 | Result Cache(oracle11g NF) [6] | ocm10gr2 | 2016.03.14 | 273 |
2 | Alert Log를 SQL 사용하여 보기 (X$DBGALERTEXT) [1] | 에밀리오 | 2016.01.28 | 2045 |
1 | Partition 추가의 계절 - Range Partition 추가시 알아 두어야할 부분 [1] | 명품관 | 2015.12.03 | 2230 |