The following tools are available for administrating services.
DBCA
OEM
DBMS_SERVICE
Server Control Utility
Here we will discuss only about Server Control Utility (SRVCTL).
We can use SRVCTL to Add, start, stop, and Enable, Disable and remove instances and services.
Command Syntax:
Srvctl add
The SRVCTL
add command add configuration in the OCR.Add Database: - srvctl add database -d -o
Add Instance: - srvctl add instance -d -i -n
Add nodeapps: - srvctl add nodeapps -n -o -A /255.255.255.0
Add asm: - srvctl add asm -n -i -o
srvctl config
The SRVCTL
config command displays the configuration stored in the OCR.Config database: - srvctl config database -d
config listener:- srvctl config listener -n
srvctl start
Start database:- srvctl start database -d -o open
Start instance:- srvctl start instance -d -i
Start nodeapps:- srvctl start nodeapps -n
Start listener:- srvctl start listener -n
srvctl stop
Stop nodeapps: - srvctl stop nodeapps -n
srvctl status
srvctl status database -d -v
srvctl status instance -d -i -v
srvctl status asm
srvctl remove
srvctl remove database -d
srvctl remove instance -d -i
srvctl remove nodeapps
srvctl remove nodeapps -n
srvctl remove asm -n -i
srvctl remove listener -n node1 -l lsnr01
AlterNet method to remove listener by using crs_unregister
1. $ crs_stat | grep NAME\= | grep lsnr
NAME=ora.rac1.LISTENER_RAC1.lsnr
NAME=ora.rac1.LISTENER_RAC1.lsnr
NAME=ora.rac2.LISTENER_RAC2.lsnr
then
$ crs_unregister ora.rac1.LISTENER_RAC1.lsnr
$ crs_unregister ora.rac2.LISTENER_RAC2.lsnr
srvctl enable
then
$ crs_unregister ora.rac1.LISTENER_RAC1.lsnr
$ crs_unregister ora.rac2.LISTENER_RAC2.lsnr
srvctl enable
srvctl enable database
srvctl enable database -d
srvctl enable instance -d -i
srvctl enable asm -n -i
srvctl disable
srvctl disable database -d
srvctl disable instance -d -i
srvctl disable asm -n -i
