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 | SQL Plan Management(SPM) - 2 DBMS_SPM.CONFIG로 필터링 | 명품관 | 2020.03.26 | 590 |
13 | SQL Plan Management(SPM) - 3 Manual Plan Capture | 명품관 | 2020.06.01 | 650 |
12 | OS 터미널 접속 없이 오라클 접속을 통해 OS CPU 사용율 모니터링 하기 [3] | 명품관 | 2020.12.22 | 813 |
11 | RECO 프로세스 트레이스 발생 하면서 ORA-02019 에러 발생시 | 명품관 | 2021.01.12 | 997 |
» | DB option Enable / Disable 정리 방법 - Mos 참고 | 우뽕 | 2021.01.31 | 1211 |
9 | Pga 메모리 설정관련 내용 [1] | 우뽕 | 2021.03.05 | 1786 |
8 | Schema password 재 사용 불가능 하게 하기 [1] | Talros | 2022.01.26 | 1287 |
7 | mbr(multi block read) 과 sbr(single block read) 사이에 과연 어떤 방식을 선택해야 할까요? [1] | 명품관 | 2022.09.16 | 342 |
6 | default 값을 포함한 컬럼 추가시 오라클 버전별 개선 사항 [1] | 명품관 | 2023.01.17 | 534 |
5 | ORA-3136 inbound connection time out & JDBC Io exception: Connection reset [1] | Talros | 2023.02.24 | 688 |
4 | ORA-28014: Cannot Drop Administrative Users 에러 현상 [1] | 명품관 | 2023.03.27 | 414 |
3 | 수집된 통계가 바로 반영되지 않고 원할 때 반영하도록 하는 방식 | 명품관 | 2023.04.04 | 268 |
2 | Python 을 이용해 파일 업로드 해 보기 [1] | Talros | 2023.04.19 | 577 |
1 | Windows 접속 에러 ORA-12638 [1] | Talros | 2024.02.14 | 97 |