Database Reference
In-Depth Information
The database can also be started using the srvctl command. The following commands start the database in OPEN
startup mode. Startup mode can be explicitly specified too.
$ srvctl start database -d ORCL
$ srvctl start database -d ORCL -o open
The parameter file can be explicitly specified using the pfile option.
$ srvctl start database -d ORCL -o open,pfile=initORCL1.ora
Instances can be managed individually, too. For example, an ORCL1 instance alone can be stopped using
the following command. It is also possible to specify a node name, as the mapping between instance_name and
node_number is already stored in OCR. You could also stop multiple instances in a single command specifying a list
of instances.
$ srvctl stop instance -d ORCL -i ORCL1
$ srvctl stop instance -d ORCL -n RAC1
$ srvctl stop instance -d ORCL -i ORCL1,ORCL2
Configuration of a database can be queried using the
config database command
and shows the spfile location,
oracle_home location, default start options, default stop options, and instances of a database, etc.
$ srvctl config database -d ORCL
Database unique name: ORCL
Database name: ORCL
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/orcl/spfileorcl1.ora
Domain:
rac.example.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ORCL
Database instances: ORCL1,ORCL2
Disk Groups: DATA
Services:
Database is administrator managed
Mapping between the node and instance names is stored in OCR, and array variable USR_ORA_INST_NAME
maintains this mapping. For example, in the following configuration, instance ORCL1 will be started in RAC1 node
and ORCL2 instance will be started in RAC2 node. It is possible to modify the USR_ORA_INST_NAME array variable
and change the mapping if needed.
$ crsctl stat res ora.racdb1.db -p|grep ORA_INST_NAME
...
GEN_USR_ORA_INST_NAME@SERVERNAME(RAC1)=ORCL1
GEN_USR_ORA_INST_NAME@SERVERNAME(RAC2)=ORCL2
...
USR_ORA_INST_NAME@SERVERNAME(RAC1)=ORCL1
USR_ORA_INST_NAME@SERVERNAME(RAC2)=ORCL2
