Where cdbrac1 is the database name, and cdbrac11, and cdbrac12 are the instance names
# old pre-12c syntax
srvctl stop database -d cdbrac1 -o immediate
# new 12c syntax
srvctl stop database -db cdbrac1 -stopoption immediate
# new 12c syntax status of instance and db
srvctl status database -db cdbrac1
# old pre-12c normal start syntax
srvctl start database -d cdbrac1
# new 12c srvctl start syntax normal default
srvctl start database -db cdbrac1
# new 12c srvctl stop instance only syntax
srvctl stop instance -db cdbrac1 -instance cdbrac11
# new 12c srvctl start instance only syntax
srvctl start instance -db cdbrac1 -instance cdbrac11
# old pre-12c srvctl stop instance only syntax
srvctl stop instance -d cdbrac1 -i cdbrac11
# old pre-12c srvctl start instance only syntax
srvctl start instance -d cdbrac1 -i cdbrac11
# new 12c “evaluate” what the command will do – don’t execute
srvctl start instance -db cdbrac1 -instance cdbrac11 -eval
# new 12c “predict” what failure will look like
srvctl predict instance -db cdbrac1 -instance cdbrac11 -verbose
Examples of Startup and shutdown of database 12c srvctl commands:
[oracle@rac1 ~]$ echo $ORACLE_SID
cdbrac11
[oracle@rac1 ~]$ srvctl stop database -db cdbrac1 -o immediate
[oracle@rac1 ~]$ srvctl status database -db cdbrac1
Instance cdbrac11 is not running on node rac1
Instance cdbrac12 is not running on node rac2
[oracle@rac1 ~]$ srvctl start database -db cdbrac1 -o mount
[oracle@rac1 ~]$ srvctl status database -db cdbrac1
Instance cdbrac11 is running on node rac1
Instance cdbrac12 is running on node rac2
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Mon Jul 31 08:50:14 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production
SQL> select open_mode from v$database;
OPEN_MODE
——————–
MOUNTED
SQL> quit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production
[oracle@rac1 ~]$ srvctl status database -db cdbrac1 -o open
PRKO-2002 : Invalid command line option: -o
[oracle@rac1 ~]$ srvctl start database -db cdbrac1 -o open
PRCR-1004 : Resource ora.cdbrac1.db is already running
PRCR-1079 : Failed to start resource ora.cdbrac1.db
CRS-5702: Resource ‘ora.cdbrac1.db’ is already running on ‘rac1’
[oracle@rac1 ~]$ srvctl modify database -db cdbrac1 -o open
PRCC-1007 : Path open does not exist
[oracle@rac1 ~]$ srvctl modify database -db cdbrac1 -startoption open
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Mon Jul 31 08:57:30 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production
SQL> select open_mode from v$database;
OPEN_MODE
——————–
MOUNTED
SQL> quit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production
[oracle@rac1 ~]$ srvctl start database -db cdbrac1 -startoption open
PRCR-1004 : Resource ora.cdbrac1.db is already running
PRCR-1079 : Failed to start resource ora.cdbrac1.db
CRS-5702: Resource ‘ora.cdbrac1.db’ is already running on ‘rac1’
[oracle@rac1 ~]$ srvctl stop database -db cdbrac1 -stoption immediate
PRKO-2002 : Invalid command line option: -stoption
[oracle@rac1 ~]$ srvctl stop database -db cdbrac1 -stopoption immediate
[oracle@rac1 ~]$ srvctl start database -db cdbrac1 -startoption open
[oracle@rac1 ~]$
[oracle@rac1 ~]$ srvctl config database -db cdbrac1 -all
Database unique name: cdbrac1
Database name: cdbrac1
Oracle home: /u01/app/oracle/product/12.2.0.1/db_1
Oracle user: oracle
Spfile: +DATA/CDBRAC1/PARAMETERFILE/spfile.298.947356499
Password file: +DATA/CDBRAC1/PASSWORD/pwdcdbrac1.282.947356141
Domain: localdomain
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
Database is enabled
Database is individually enabled on nodes:
Database is individually disabled on nodes:
OSDBA group: dba
OSOPER group: dba
Database instances: cdbrac11,cdbrac12
Configured nodes: rac1,rac2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
Or
[oracle@rac1 ~]$ srvctl config database -db cdbrac1 -verbose
Database unique name: cdbrac1
Database name: cdbrac1
Oracle home: /u01/app/oracle/product/12.2.0.1/db_1
Oracle user: oracle
Spfile: +DATA/CDBRAC1/PARAMETERFILE/spfile.298.947356499
Password file: +DATA/CDBRAC1/PASSWORD/pwdcdbrac1.282.947356141
Domain: localdomain
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: dba
Database instances: cdbrac11,cdbrac12
Configured nodes: rac1,rac2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@rac1 ~]$
And some instance start and stop commands
[oracle@rac2 ~]$ srvctl stop instance -db cdbrac1 -instance cdbrac11
[oracle@rac2 ~]$ srvctl status database -db cdbrac1
Instance cdbrac11 is not running on node rac1
Instance cdbrac12 is running on node rac2
[oracle@rac2 ~]$ srvctl start instance -db cdbrac1 -instance cdbrac11
[oracle@rac2 ~]$ srvctl status database -db cdbrac1
Instance cdbrac11 is running on node rac1
Instance cdbrac12 is running on node rac2