다른 명령
svrctl 명령어
DB 시작 / 종료
DB start
emoji_objects SYNTAX - START DB
srvctl start database -d db_name [-o start_options] where start_option is nomount/mount/open(default)
srvctl start database -d PRODB -o nomount srvctl start database -d PRODB -o mount srvctl start database -d PRODB -o open
DB stop
emoji_objects SYNTAX - STOP DB
srvctl stop database -d db_name [-o stop_options] where stop_options is normal/immediate(default)/transactional/abort
srvctl stop database -d PRODB -o normal srvctl stop database -d PRODB -o immediate srvctl stop database -d PRODB -o transactional srvctl stop database -d PRODB -o abort
DB remove
emoji_objects SYNTAX - REMOVE DB SERVICE
srvctl remove database -d db_unique_name [-f] [-y] [-v]
srvctl remove database -d PRODB -f -y
DB add
emoji_objects SYNTAX - ADDING DB SERVICE
srvctl add database -d db_unique_name -o ORACLE_HOME [-p spfile]
srvctl add database -d PRODB -o /u01/app/oracle/product/12.1.0.2/dbhome_1 -p +DATA/PRODDB/parameterfile/spfilePRODB.ora
DB 인스턴스 추가 / 제거
DB 인스턴스 remove
emoji_objects SYNTAX - REMOVING INSTANCE
srvctl remove instance -d DB_UNIQUE_NAME -i INSTANCE_NAME
srvctl remove instance -d PRODB - I PRODB1
DB 인스턴스 add
emoji_objects SYNTAX - ADDING INSTANCE
srvctl add instance –d db_unique_name –i inst_name -n node_name
srvctl add instance -d PRODB - i PRODB1 -n rachost1
DB 인스턴스 stop
emoji_objects SYNTAX - STOPPING INSTANCE
srvctl stop instance -d db_unique_name [-i "instance_name_list"]} [-o stop_options] [-f]
srvctl stop instance -d PRODB -i PRODB1
DB 인스턴스 start
emoji_objects SYNTAX - STARTING INSTANCE
srvctl start instance -d db_unique_name [-i "instance_name_list"} [-o start_options]
srvctl start instance -d PRODB -i PRODB1
데이터베이스/인스턴스 ENABLE 과 DISABLE
-- ENABLE - Reenables management by Oracle Restart for a component. -- DISABLE - Disables management by Oracle Restart for a component. srvctl enable instance -d DB_UNIQUE_NAME-i INSTANCE_NAME srvctl disable instance -d DB_UNIQUE_NAME-i INSTANCE_NAME srvctl enable database -d DB_UNIQUE_NAME srvctl disable database -d DB_UNIQUE_NAME
서비스 리로케이트(relocate)
emoji_objects SYNTAX - RELOCATE
srvctl relocate service -d {database_name} -s {service_name} -i {old_inst_name} -r {new_inst_name}
- EXAMPLE:(Relocating service PRDB_SRV from PREDB2 to PREDB1)
srvctl relocate service -d PREDB -s PRDB_SVC -i PREDB2 -t PREDB1 -- Check the status of service srvctl status service -d PREDB -s PRDB_SVC
서비스 START / STOP
emoji_objects SYNTAX - START/STOP SERVICE
srvctl start service -d {DB_NAME} -s {SERVICE_NAME} srvctl stop service -d {DB_NAME} -s {SERVICE_NAME}
- EXAMPLE:
srvctl start service -d PREDB -s PRDB_SRV srvctl stop service -d PREDB -s PRDB_SRV
서비스 ADD/ REMOVE
서비스 ADD
emoji_objects SYNTAX - ADDING A SERVICE
srvctl add service -d {DB_NAME} -s {SERVICE_NAME} -r {"preferred_list"} -a {"available_list"} [-P {BASIC | NONE | PRECONNECT}]
- EXAMPLE:
srvctl add service -d PREDB -s PRDB_SRV -r "PREDB1,PREDB2" -a "PREDB2" -P BASIC
서비스 REMOVE
emoji_objects SYNTAX - REMOVING A SERVICE
srvctl remove service -d {DB_NAME} -s {SERVICE_NAME}
- EXAMPLE:
srvctl remove service -d PREDB -s PRDB_SRV
환경변수(setenv) 설정
-- setenv to set env variables.(ORCL is the db_unique_name) srvctl setenv database -db ORCL -env "ORACLE_HOME=/oracle/app/oracle/product/12.1.0.2/dbhome_1" srvctl setenv database -db ORCL -env "TNS_ADMIN=/oracle/app/oracle/product/12.1.0.2/dbhome_1/network/admin" -- getenv to view the env setting: srvctl getenv database -db ORCL
ASM CONFIG 조회
srvctl config asm srvctl config asm -detail