Basic srvctl commands

        
 ADD, REMOVE AND CHECK Database VIA SRVCTL


  • To add database.

    srvctl add database -d DBNAME -o <ORACLE_HOME>
  • To check database status

    srvctl status database -d DBNAME
  • To remove database

    srvctl remove database -d DBNAME

 START AND STOP DATABASE VIA SRVCTL

  • To start database.

    srvctl start database -d DBNAME
  • To stop database. 

    srvctl stop database -d DBNAME
  • To display configuration.

    srvctl config database -d DBNAME

 ADD, REMOVE AND CHECK INSTANCE VIA SRVCTL

  • To add instance.

    srvctl add instance -d DBNAME -i INSTANCENAME -n <HOST_NAME>
  • To check instance status.

    srvctl status instance -d DBNAME  -i INSTANCENAME
  • To remove instance.

    srvctl remove instance -d DBNAME -i INSTANCENAME
STOP, START AND CHECK INSTANCE VIA SRVCTL

  • To stop instance.

    srvctl stop instance -d db_unique_name [-i "instance_name_list"]} [-o stop_options] [-f]

    srvctl stop instance -d DB_NAME -i INSTANCENAME

  • To start instance.

    srvctl start instance -d DBNAME -i INSTANCENAME

STOP, START AND CHECK asm VIA SRVCTL

  • To start ASM.

    srvctl start asm -n NODE_NAME
  • To stop ASM.

    srvctl stop asm -n NODE_NAME
  • To check ASM status

    srvctl status asm -n NODE_NAME

  • To display ASM configuration

    srvctl config asm -n NODE_NAME

STOP, START AND CHECK sERVICE VIA SRVCTL

  • To start service.

    srvctl start service -d DBNAME -s SERVICE_NAME
  • To stop service.

    srvctl stop service -d DBNAME -s SERVICE_NAME
  • To check service status

    srvctl status service -d DBNAME 
  • To display service configuration

    srvctl config service -d DBNAME

 ADD AND REMOVE SERVICE VIA SRVCTL 


  • To add service.

    srvctl add service -d DBNAME -s SERVICE_NAME -r {"preferred_list"} -a {"available_list"}

     [-P {BASIC | NONE | PRECONNECT}]
  • To remove service.

     srvctl remove service -d DBNAME -s SERVICE_NAME 




Comments