HOME > > Administrating Services

Administrating Services

Anup - Friday, July 22, 2011


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 nodeapps:- srvctl config nodeapps -n
config asm:- srvctl config asm -n
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 asm:- srvctl start asm -n -i
Start listener:- srvctl start listener -n

srvctl stop
Stop database: - srvctl stop database -d
Stop instance: - srvctl stop instance -d -i
Stop nodeapps: - srvctl stop nodeapps -n
Stop asm: - srvctl stop asm -n -i
Stop listener:- srvctl stop listener -n

srvctl status

srvctl status database
srvctl status database -d -v
srvctl status instance
srvctl status instance -d -i -v
srvctl status nodeapps
srvctl status nodeapps -n
srvctl status asm
srvctl status asm -n

srvctl remove

srvctl remove database
srvctl remove database -d
srvctl remove instance
srvctl remove instance -d -i
srvctl remove nodeapps
srvctl remove nodeapps -n
srvctl remove asm
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.rac2.LISTENER_RAC2.lsnr

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
srvctl enable instance  -d -i
srvctl enable asm
srvctl enable asm -n -i

srvctl disable

srvctl disable database
srvctl disable database -d
srvctl disable instance
srvctl disable instance -d -i
srvctl disable asm
srvctl disable asm -n -i

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me