SRVCTL Command Reference for Oracle Restart

This section provides details about the syntax and options for SRVCTL commands specific to Oracle Restart. See Oracle Real Application Clusters Administration and Deployment Guide for the full list of SRVCTL commands.

SRVCTL Command Syntax and Options Overview

SRVCTL expects the following command syntax:

srvctl command object options

where:

• command is a verb such as start, stop, or remove. See Table 4-7 for a complete list.

• object is the component on which SRVCTL performs the command, such as database, listener, and so on. You can also use component abbreviations. See Table 4-8 for a complete list of components and their abbreviations.

• options extend the use of a preceding command combination to include additional parameters for the command. For example, the -d option indicates that a database unique name follows, and the -s option indicates that a comma-delimited list of database service names follows.

Case Sensitivity SRVCTL commands and components are case insensitive. Options are case sensitive. Database and database service names are case insensitive and case preserving.

SRVCTL Components Summary

Table 4-8 lists the keywords that can be used for the object portion of SRVCTL commands. You can use either the full name or the abbreviation for each component keyword.

add

The srvctl add command adds the specified component to the Oracle Restart configuration, and optionally sets Oracle Restart configuration parameters for the component. After a component is added, Oracle Restart begins to manage it, restarting it when required.

To perform srvctl add operations, you must be logged in to the database host computer with the proper user account. See "Preparing to Run SRVCTL" for more information.

srvctl add asm

Adds an Oracle ASM instance to the Oracle Restart configuration.

Syntax and Options

Use the srvctl add asm command with the following syntax:

srvctl add asm [-l listener_name [-p spfile] [-d asm_diskstring]]

-l listener_name

-p spfile

-d asm_diskstring

Example

An example of this command is:

srvctl add asm -l crmlistener

srvctl add database

Adds a database to the Oracle Restart configuration.

After adding a database to the Oracle Restart configuration, if the database then accesses data in an Oracle ASM disk group, a dependency between the database that disk group is created. Oracle Restart then ensures that the disk group is mounted before attempting to start the database.

However, if the database and Oracle ASM instance are not running when you add the database to the Oracle Restart configuration, you must manually establish the dependency between the database and its disk groups by specifying the -a option in the SRVCTL command. See the example later in this section.

Syntax and Options

Use the srvctl add database command with the following syntax:

srvctl add database -d db_unique_name -o oracle_home [-m domain_name] 
  [-n db_name] [-p spfile] [-s start_options] [-t stop_options]
  [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}]
  [-y {automatic | manual}] [-a disk_group_list]

-d db_unique_name

-o Oracle_home

-m domain_name

-n db_name

-p spfile

-s start_options

-t stop_options

-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}

-y {AUTOMATIC | MANUAL}

-a disk_group_list

Examples

This example adds the database with the DB_UNIQUE_NAME dbcrm:

srvctl add database -d dbcrm -o /u01/app/oracle/product/11.2.0/dbhome_1

This example adds the same database and also establishes a dependency between the database and the disk groups DATA and RECOVERY.

srvctl add database -d dbcrm -o /u01/app/oracle/product/11.2.0/dbhome_1
  -a "DATA,RECOVERY"

srvctl add listener

Adds a listener to the Oracle Restart configuration.

Syntax and Options

Use the srvctl add listener command with the following syntax:

srvctl add listener [-l listener_name] [-p endpoints] [-s] [-o Oracle_home]

-l listener_name

-p endpoints

"[TCP:]port[, ...] [/IPC:key] [/NMP:pipe_name] [/TCPS:s_port] [/SDP:port]"

-s

-o Oracle_home

Example

The following command adds a listener (named LISTENER) running out of the database Oracle home and listening on TCP port 1522:

srvctl add listener -p TCP:1522 -o /u01/app/oracle/product/11.2.0/dbhome_1

srvctl add ons

Adds an ONS to an Oracle Restart configuration.

ONS must be added to an Oracle Restart configuration to enable the sending of Fast Application Notification (FAN) events after an Oracle Data Guard failover.

When ONS is added to an Oracle Restart configuration, it is initially disabled. You can enable it with the srvctl enable ons command.

Syntax and Options

Use the srvctl add ons command with the following syntax:

srvctl add ons [-e em_port] [-l ons_local_port] [-r ons_remote_port] [-t host[:port],[host[:port]...]] [-v]

-e em_port

-l ons_local_port

-r ons_remote_port

-t host[:port],[host[:port],...

-v

srvctl add service

Adds a database service to the Oracle Restart configuration. Creates the database service if it does not exist. This method of creating a service is preferred over using the DBMS_SERVICE PL/SQL package.

Syntax and Options

Use the srvctl add service command with the following syntax:

srvctl add service -d db_unique_name -s service_name
  [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]]
  [-y {AUTOMATIC | MANUAL}] [-e {NONE | SESSION | SELECT}] [-m {NONE | BASIC}]
  [-w integer] [-z integer] [-j {SHORT | LONG}]
  [-B {SERVICE_TIME | THROUGHPUT | NONE}] [-q {TRUE | FALSE}] -t edition_name

-d db_unique_name

-s service_name

-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]

-y {AUTOMATIC | MANUAL}

-e {NONE |SESSION | SELECT}

-m {NONE | BASIC}

-w integer

-z integer

-j {SHORT | LONG}

-B {SERVICE_TIME | THROUGHPUT | NONE}

-q {TRUE | FALSE}

-t edition_name

Example

This example adds the sales service for the database with DB_UNIQUE_NAME dbcrm. The service is started only when dbcrm is in PRIMARY mode.

srvctl add service -d dbcrm -s sales -l PRIMARY

config

The srvctl config command displays the Oracle Restart configuration of the specified component or set of components.

srvctl config asm

Displays the Oracle Restart configuration information for the Oracle ASM instance.

Syntax and Options

Use the srvctl config asm command with the following syntax:

srvctl config asm [-a]

-a

Example

An example of this command is:

srvctl config asm -a

asm home: /u01/app/oracle/product/11.2.0/grid
ASM is enabled.

srvctl config database

Displays the Oracle Restart configuration information for the specified database, or lists all databases managed by Oracle Restart.

Syntax and Options

Use the srvctl config database command with the following syntax:

srvctl config database [-d db_unique_name [-a]]

-d db_unique_name

-a

Examples

An example of this command to list all Oracle Restart–managed databases is:

srvctl config database

dbcrm
orcl

An example of this command to display configuration and enabled/disabled status for the database with the DB_UNIQUE_ID orcl is:

srvctl config database -d orcl -a

Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/orcl/spfileorcl.ora
Domain: us.example.com
Start options: open
Stop options: immediate
Database role:
Management policy: automatic
Disk Groups: DATA
Services: mfg,sales
Database is enabled

srvctl config listener

Displays the Oracle Restart configuration information for all Oracle Restart–managed listeners or for the specified listener.

Syntax and Options

Use the srvctl config listener command with the following syntax:

srvctl config listener [-l listener_name]

-l listener_name

Example

This example displays the configuration information and enabled/disabled status for the default listener:

srvctl config listener

Name: LISTENER
Home: /u01/app/oracle/product/11.2.0/dbhome_1
End points: TCP:1521
Listener is enabled.

srvctl config ons

Displays the current configuration information for ONS.

Syntax and Options

Use the srvctl config ons command with the following syntax:

srvctl config ons

srvctl config service

For the specified database, displays the Oracle Restart configuration information for the specified database service or for all Oracle Restart–managed database services.

Syntax and Options

Use the srvctl config service command with the following syntax:

srvctl config service -d db_unique_name [-s service_name] [-a]

-d db_unique_name

-s service_name

-a

Example

An example of this command is:

srvctl config service -d dbcrm -s sales

Service name: sales
Service is enabled
Cardinality: SINGLETON
Disconnect: true
Service role: PRIMARY
Management policy: automatic
DTP transaction: false
AQ HA notifications: false
Failover type: NONE
Failover method: NONE
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: NONE
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition: e2

disable

Disables a component, which suspends management of that component by Oracle Restart. The srvctl disable command is intended to be used when a component must be repaired or shut down for maintenance, and should not be restarted automatically. When you disable a component:

• It is no longer automatically restarted.

• It is no longer automatically started through a dependency.

• It cannot be started with SRVCTL.

To perform srvctl disable operations, you must be logged in to the database host computer with the proper user account. See "Preparing to Run SRVCTL" for more information.

srvctl disable asm

Disables the Oracle ASM instance.

Syntax and Options

Use the srvctl disable asm command with the following syntax:

srvctl disable asm

srvctl disable database

Disables the specified database.

Syntax and Options

Use the srvctl disable database command with the following syntax:

srvctl disable database -d db_unique_name

-d db_unique_name

Example

An example of this command is:

srvctl disable database -d dbcrm

srvctl disable diskgroup

Disables an Oracle ASM disk group.

Syntax and Options

Use the srvctl disable diskgroup command with the following syntax:

srvctl disable diskgroup -g diskgroup_name

-g diskgroup_name

Example

An example of this command is:

srvctl disable diskgroup -g DATA

srvctl disable listener

Disables the specified listener or all listeners.

Syntax and Options

Use the srvctl disable listener command with the following syntax:

srvctl disable listener [-l listener_name]

-l listener_name

Example

An example of this command is:

srvctl disable listener -l crmlistener

srvctl disable ons

Disables ONS.

Syntax and Options

Use the srvctl disable ons command with the following syntax:

srvctl disable ons -v

-v

srvctl disable service

Disables one or more database services.

Syntax and Options

Use the srvctl disable service command with the following syntax:

srvctl disable service -d db_unique_name -s service_name_list

-d db_unique_name

-s service_name_list

Example

The following example disables the database service sales and mfg:

srvctl disable service -d dbcrm -s sales,mfg

enable

The srvctl enable command reenables the specified disabled component so that:

• Oracle Restart can automatically restart it.

• It can be automatically started through a dependency.

• You can start it manually with SRVCTL.

If the component is already enabled, then the command is ignored.

When you add a component to the Oracle Restart configuration, it is enabled by default.

To perform srvctl enable operations, you must be logged in to the database host computer with the proper user account. See "Preparing to Run SRVCTL" for more information.

srvctl enable asm

Enables an Oracle ASM instance.

Syntax and Options

Use the srvctl enable asm command with the following syntax:

srvctl enable asm

srvctl enable database

Enables the specified database.

Syntax and Options

Use the srvctl enable database command with the following syntax:

srvctl enable database -d db_unique_name

-d db_unique_name

Example

An example of this command is:

srvctl enable database -d dbcrm

srvctl enable diskgroup

Enables an Oracle ASM disk group.

Syntax and Options

Use the srvctl enable diskgroup command with the following syntax:

srvctl enable diskgroup -g diskgroup_name

-g diskgroup_name

Example

An example of this command is:

srvctl enable diskgroup -g DATA

srvctl enable listener

Enables the specified listener or all listeners.

Syntax and Options

Use the srvctl enable listener command with the following syntax:

srvctl enable listener [-l listener_name]

-l listener_name

Example

An example of this command is:

srvctl enable listener -l crmlistener

srvctl enable ons

Enables ONS.

Syntax and Options

Use the srvctl enable ons command with the following syntax:

srvctl enable ons -v

-v

srvctl enable service

Enables one or more database services for the specified database.

Syntax and Options

Use the srvctl enable service command with the following syntax:

srvctl enable service -d db_unique_name -s service_name_list

-d db_unique_name

-s service_name_list

Examples

The following example enables the database services sales and mfg in the database with DB_UNIQUE_NAME dbcrm:

srvctl enable service -d dbcrm -s "sales,mfg"

getenv

Gets and displays environment variables and their values from the Oracle Restart configuration for a database, listener, or Oracle ASM instance.

srvctl getenv asm

Displays the configured environment variables for the Oracle ASM instance.

Syntax and Options

Use the srvctl getenv asm command with the following syntax:

srvctl getenv asm [-t name_list]

-t name_list

Example

The following example displays all configured environment variables for the Oracle ASM instance:

srvctl getenv asm

srvctl getenv database

Displays the configured environment variables for the specified database.

Syntax and Options

Use the srvctl getenv database command with the following syntax:

srvctl getenv database -d db_unique_name [-t name_list]

-d db_unique_name

-t name_list

Example

The following example displays all configured environment variables for the database with DB_UNIQUE_NAME dbcrm:

srvctl getenv database -d dbcrm

srvctl getenv listener

Displays the configured environment variables for the specified listener.

Syntax and Options

Use the srvctl getenv listener command with the following syntax:

srvctl getenv listener [-l listener_name] [-t name_list]

-l listener_name

-t name_list

Example

The following example displays all configured environment variables for the listener named crmlistener:

srvctl getenv listener -l crmlistener

modify

Modifies the Oracle Restart configuration of a component. The change takes effect when the component is next restarted.

To perform srvctl modify operations, you must be logged in to the database host computer with the proper user account. See "Preparing to Run SRVCTL" for more information.

srvctl modify asm

Modifies the Oracle Restart configuration for the Oracle ASM instance.

Syntax and Options

Use the srvctl modify asm command with the following syntax:

srvctl modify asm [-l listener_name] [-p spfile] [-d asm_diskstring]

-l listener_name

-p spfile

-d asm_diskstring

Example

An example of this command is:

srvctl modify asm -l crmlistener

srvctl modify database

Modifies the Oracle Restart configuration for a database.

Syntax and Options

Use the srvctl modify database command with the following syntax:

srvctl modify database -d db_unique_name [-o oracle_home] [-u oracle_user] 
  [-m domain_name] [-n db_name] [-p spfile] [-s start_options] 
  [-t stop_options] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | 
  SNAPSHOT_STANDBY}] [-y {automatic | manual}] [-a disk_group_list] [-z]

-d db_unique_name

-u oracle_user

-z

Example

The following example changes the role of the database with DB_UNIQUE_NAME dbcrm to LOGICAL_STANDBY:

srvctl modify database -d dbcrm -r logical_standby

srvctl modify listener

Modifies the Oracle Restart configuration for the specified listener or all listeners.

Syntax and Options

Use the srvctl modify listener command with the following syntax:

srvctl modify listener [-l listener_name] [-p endpoints] [-o Oracle_home]

-l listener_name

-p endpoints

"[TCP:]port[, ...] [/IPC:key] [/NMP:pipe_name] [/TCPS:s_port] [/SDP:port]"

-o Oracle_home

Example

This example modifies the TCP port on which the listener named crmlistener listens:

srvctl modify listener -l crmlistener -p TCP:1522

srvctl modify ons

Modifies ONS.

Syntax and Options

Use the srvctl modify ons command with the following syntax:

srvctl modify ons [-e em_port] [-l ons_local_port] [-r ons_remote_port] [-t host[:port],[host[:port]...]] [-v]

-e em_port

-l ons_local_port

-r ons_remote_port

-t host[:port],[host[:port],...

-v

srvctl modify service

Modifies the Oracle Restart configuration of a database service.

Syntax and Options

Use the srvctl modify service command with the following syntax:

srvctl modify service -d db_unique_name -s service_name]
  [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]]
  [-y {AUTOMATIC | MANUAL}] [-e {NONE | SESSION | SELECT}] [-m {NONE | BASIC}]
  [-w integer] [-z integer] [-j {SHORT | LONG}]
  [-B {SERVICE_TIME | THROUGHPUT | NONE}] [-q {TRUE | FALSE}] -t edition_name

-d db_unique_name

-s service_name

-t edition_name

Example

For the database with a DB_UNIQUE_NAME of dbcrm, the following command changes the Oracle Data Guard role of the database service named support to standby:

srvctl modify service -d dbcrm -s support -l standby

remove

Removes the specified component from the Oracle Restart configuration. Oracle Restart no longer manages the component. Any environment variable settings for the component are also removed.

Before you remove a component from the Oracle Restart configuration, you must use SRVCTL to stop it. Oracle recommends that you disable the component before removing it, but this is not required.

To perform srvctl remove operations, you must be logged in to the database host computer with the proper user account. See "Preparing to Run SRVCTL" for more information.

srvctl remove asm

Removes an Oracle ASM instance.

Syntax and Options

Use the srvctl remove asm command with the following syntax:

srvctl remove asm  [-f]

-f

Example

An example of this command is:

srvctl remove asm

srvctl remove database

Removes a database. Prompts for confirmation first.

Syntax and Options

Use the srvctl remove database command with the following syntax:

srvctl remove database -d db_unique_name [-f] [-y] [-v]

-d db_unique_name

-f

-y

-v

Example

An example of this command is:

srvctl remove database -d dbcrm

srvctl remove diskgroup

Removes an Oracle ASM disk group.

Syntax and Options

Use the srvctl remove diskgroup command with the following syntax:

srvctl remove diskgroup -g diskgroup_name [-f]

-g diskgroup_name

-f

Examples

This example removes the disk group named DATA. An error is returned if files are open on this disk group.

srvctl remove diskgroup -g DATA

srvctl remove listener

Removes the specified listener or all listeners.

Syntax and Options

Use the srvctl remove listener command with the following syntax:

srvctl remove listener [-l listener_name] [-a] [-f]

-l listener_name

-a

-f

Example

The following command removes the listener lsnr01:

srvctl remove listener -l lsnr01

srvctl remove ons

Removes ONS.

Syntax and Options

Use the srvctl remove ons command as follows:

srvctl remove ons -f -v

-f

-v

srvctl remove service

Removes the specified database service.

Syntax and Options

Use the srvctl remove service command as follows:

srvctl remove service -d db_unique_name -s service_name] [-f]

-d db_unique_name

-s service_name

-f

Example

An example of this command is:

srvctl remove service -d dbcrm -s sales

setenv

The setenv command sets values of environment variables in the Oracle Restart configuration for a database, a listener, or the Oracle ASM instance.

To perform srvctl setenv operations, you must be logged in to the database host computer with the proper user account. See "Preparing to Run SRVCTL" for more information.

srvctl setenv asm

Sets the values of environment variables in the Oracle Restart configuration for the Oracle ASM instance. Before starting the instance, Oracle Restart sets environment variables to the values stored in the configuration.

Syntax and Options

Use the srvctl setenv asm command with the following syntax:

srvctl setenv asm {-t name=val[,name=val,...] | -T name=val}

-t name=val[,name=val,...]

-T name=val

Example

The following example sets the AIX operating system environment variable AIXTHREAD_SCOPE in the Oracle ASM instance configuration:

srvctl setenv asm -t AIXTHREAD_SCOPE=S

srvctl setenv database

Sets the values of environment variables in the Oracle Restart configuration for a database instance. Before starting the instance, Oracle Restart sets environment variables to the values stored in the configuration.

Syntax and Options

Use the srvctl setenv database command with the following syntax:

srvctl setenv database -d db_unique_name {-t name=val[,name=val,...] |
  -T name=val}

-d db_unique_name

-t name=val[,name=val,...]

-T name=val

Example

The following example sets the LANG environment variable in the configuration of the database with a DB_UNIQUE_NAME of dbcrm:

srvctl setenv database -d dbcrm -t LANG=en

srvctl setenv listener

Sets the values of environment variables in the Oracle Restart configuration for a listener. Before starting the listener, Oracle Restart sets environment variables to the values stored in the configuration.

Syntax and Options

Use the srvctl setenv listener command with the following syntax:

srvctl setenv listener [-l listener_name] {-t name=val[,name=val,...] | 
  -T name=val}

-l listener_name

-t name=val[,name=val,...]

-T name=val

Example

The following example sets the AIX operating system environment variable AIXTHREAD_SCOPE in the configuration of the listener named crmlistener:

srvctl setenv listener -l crmlistener -t AIXTHREAD_SCOPE=S

start

Starts the specified component or components.

srvctl start asm

Starts the Oracle ASM instance.

For this command, SRVCTL connects "/ as sysasm" to perform the operation. To run such operations, the owner of the executables in the Oracle Grid Infrastructure home must be a member of the OSASM group, and users running the commands must also be in the OSASM group.

Syntax and Options

Use the srvctl start asm command with the following syntax:

srvctl start asm [-o start_options]

-o start_options

Examples

This example starts the Oracle ASM instance, which then mounts any disk groups named in the ASM_DISKGROUPS initialization parameter:

srvctl start asm

This example starts the Oracle ASM instance without mounting any disk groups:

srvctl start asm -o nomount

srvctl start database

Starts the specified database instance.

For this command, SRVCTL connects "/ as sysdba" to perform the operation. To run such operations, the owner of the Oracle executables in the database Oracle home must be a member of the OSDBA group (for example, the dba group on UNIX and Linux), and users running the commands must also be in the OSDBA group.

Syntax and Options

Use the srvctl start database command with the following syntax:

srvctl start database -d db_unique_name [-o start_options]

-d db_unique_name

-o start_options

Example

An example of this command is:

srvctl start database -d dbcrm -o pfile=testparm,nomount

srvctl start diskgroup

Starts (mounts) an Oracle ASM disk group.

Syntax and Options

Use the srvctl start diskgroup command with the following syntax:

srvctl start diskgroup -g diskgroup_name

-g diskgroup_name

Example

An example of this command is:

srvctl start diskgroup -g DATA

srvctl start home

Starts all of the components that are managed by Oracle Restart in the specified Oracle home. The Oracle home can be an Oracle Database home or an Oracle Grid Infrastructure home.

This command starts the components that were stopped by a srvctl stop home. This command uses the information in the specified state file to identify the components to start.

Syntax and Options

Use the srvctl start home command with the following syntax:

srvctl start home -o oracle_home -s state_file

srvctl start listener

Starts the specified listener or all listeners.

Syntax and Options

Use the srvctl start listener command with the following syntax:

srvctl start listener [-l listener_name]

-l listener_name

Example

An example of this command is:

srvctl start listener -l listener

srvctl start ons

Starts ONS.

Syntax and Options

Use the srvctl start ons command with the following syntax:

srvctl start ons -v

-v

srvctl start service

Starts the specified database service or services.

Syntax and Options

Use the srvctl start service command with the following syntax:

srvctl start service -d db_unique_name [-s service_name_list] [-o start_options]

-d db_unique_name

-s service_name_list

-o start_options

Example

For the database with a DB_UNIQUE_NAME of dbcrm, the following example starts the sales database service:

srvctl start service -d dbcrm -s sales

status

Displays the running status of the specified component or set of components.

srvctl status asm

Displays the running status of the Oracle ASM instance.

Syntax and Options

Use the srvctl status asm command with the following syntax:

srvctl status asm [-a]

-a

Example

An example of this command is:

srvctl status asm

ASM is running on dbhost

srvctl status database

Displays the running status of the specified database.

Syntax and Options

Use the srvctl status database command with the following syntax:

srvctl status database -d db_unique_name [-f] [-v]

-d db_unique_name

-f

-v

Example

An example of this command is:

srvctl status database -d dbcrm -v

Database dbcrm is running with online services mfg,sales

srvctl status diskgroup

Displays the running status of an Oracle ASM disk group.

Syntax and Options

Use the srvctl status diskgroup command with the following syntax:

srvctl status diskgroup -g diskgroup_name [-a]

-g diskgroup_name

-a

Example

An example of this command is:

srvctl status diskgroup -g DATA

Disk Group DATA is running on dbhost

srvctl status home

Displays the running status of all of the components that are managed by Oracle Restart in the specified Oracle home. The Oracle home can be an Oracle Database home or an Oracle Grid Infrastructure home.

This command writes the current status of the components to the specified state file.

Syntax and Options

Use the srvctl status home command with the following syntax:

srvctl status home -o oracle_home -s state_file

srvctl status listener

Displays the running status of the specified listener or of all Oracle Restart–managed listeners.

Syntax and Options

Use the srvctl status listener command with the following syntax:

srvctl status listener -l listener_name

-l listener_name

Example

An example of this command is:

srvctl status listener -l crmlistener

Listener CRMLISTENER is running on dbhost

srvctl status ons

Displays the running status of ONS.

Syntax and Options

Use the srvctl status ons command with the following syntax:

srvctl status ons

srvctl status service

Displays the running status of one or more database services.

Syntax and Options

Use the srvctl status service command with the following syntax:

srvctl status service -d db_unique_name [-s service_name_list] [-f] [-v]

-d db_unique_name

-s service_name_list

-f

-v

Example

For the database with the DB_UNIQUE_NAME of dbcrm, the following example displays the running status of the service sales:

srvctl status service -d dbcrm -s sales

Service sales is running on dbhost

stop

Stops the specified component or components.

If you want a component to remain stopped after you issue a srvctl stop command, disable the component. See the disable command.

srvctl stop asm

Stops the Oracle ASM instance.

Syntax and Options

Use the srvctl stop asm command with the following syntax:

srvctl stop asm [-o stop_options] [-f]

-o stop_options

-f

Example

An example of this command is:

srvctl stop asm -o abort -f

srvctl stop database

Stops a database.

Syntax and Options

Use the srvctl stop database command with the following syntax:

srvctl stop database -d db_unique_name [-o stop_options] [-f]

-d db_unique_name

-o stop_options

-f

Example

An example of this command is:

srvctl stop database -d dbcrm

srvctl stop diskgroup

Stops (dismounts) an Oracle ASM disk group.

Syntax and Options

Use the srvctl stop diskgroup command with the following syntax:

srvctl stop diskgroup -g diskgroup_name [-f]

-g diskgroup_name

-f

Examples

This example stops the disk group named DATA. An error is returned if files are open on this disk group.

srvctl stop diskgroup -g DATA

srvctl stop home

Stops all of the components that are managed by Oracle Restart in the specified Oracle home. The Oracle home can be an Oracle Database home or an Oracle Grid Infrastructure home.

This command identifies the components that it stopped in the specified state file.

Syntax and Options

Use the srvctl stop home command with the following syntax:

srvctl stop home -o oracle_home -s state_file [-t stop_options] [-f]

-t stop_options

-f

srvctl stop listener

Stops the designated listener or all Oracle Restart–managed listeners. Stopping a listener does not cause databases that are registered with the listener to be stopped.

Syntax and Options

Use the srvctl stop listener command with the following syntax:

srvctl stop listener [-l listener_name] [-f]

-l listener_name

-f

Example

An example of this command is:

srvctl stop listener -l crmlistener

srvctl stop ons

Stops ONS.

Syntax and Options

Use the srvctl stop ons command with the following syntax:

srvctl stop ons -v

-v

srvctl stop service

Stops one or more database services.

Syntax and Options

Use the srvctl stop service command with the following syntax:

srvctl stop service -d db_unique_name [-s service_name_list] [-f]

-d db_unique_name

-s service_name_list

-f

Examples

The following example stops the sales database service on the database with a DB_UNIQUE_NAME of dbcrm:

srvctl stop service -d dbcrm -s sales

unsetenv

The unsetenv command deletes one or more environment variables from the Oracle Restart configuration for a database, a listener, or an Oracle ASM instance.

To perform srvctl unsetenv operations, you must be logged in to the database host computer with the proper user account. See "Preparing to Run SRVCTL" for more information.

srvctl unsetenv asm

Removes the specified environment variables from the Oracle Restart configuration for the Oracle ASM instance.

Syntax and Options

Use the srvctl unsetenv asm command with the following syntax:

srvctl unsetenv asm -t name_list

-t name_list

Example

The following example removes the AIX operating system environment variable AIXTHREAD_SCOPE from the Oracle ASM instance configuration:

srvctl unsetenv asm -t AIXTHREAD_SCOPE

srvctl unsetenv database

Removes the specified environment variables from the Oracle Restart configuration for the specified database.

Syntax and Options

Use the srvctl unsetenv database command as follows:

srvctl unsetenv database -d db_unique_name -t name_list

-d db_unique_name

-t name_list

Example

The following example deletes the AIXTHREAD_SCOPE environment variable from the Oracle Restart configuration for the database with a DB_UNIQUE_NAME of dbcrm:

srvctl unsetenv database -d dbcrm -t AIXTHREAD_SCOPE

srvctl unsetenv listener

Removes the specified environment variables from the Oracle Restart configuration for the specified listener or all listeners.

Syntax and Options

Use the srvctl unsetenv listener command with the following syntax:

srvctl unsetenv listener [-l listener_name] -t name_list

-l listener_name

-t name_list

Example

The following example removes the AIX operating system environment variable AIXTHREAD_SCOPE from the listener configuration for the listener named crmlistener:

srvctl unsetenv listener -l crmlistener -t AIXTHREAD_SCOPE