Basic SRVCTL Commands

Written by

dbapranjan

in

SRVCTL, short for Server Control Utility, is a command-line tool, used to manage various entities in an Oracle Cluster environment, including databases, instances, listeners, services, and more. It allows you to perform various tasks like starting, stopping, modifying.

Common Basic SRVCTL Commands:

  • Starting and Stopping Services:

Start a database instance:

SYNTAX – srvctl start database -d db_name [-o start_options]

start_option – 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

Stop a running database:

SYNTAX – srvctl stop database -d db_name [-o stop_options]

stop_options – 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

  • Checking Status

View the status of all database instances: 

srvctl status database -d

Get detailed information about a service:

srvctl info service -s

  • Adding and Removing Resources:

Add a new database: 

srvctl add database -d (caution: advanced usage)

Remove an existing service: 

srvctl remove service -s

More posts