The password file stored asm crsctl stat res ora
Chapter 3 ■ raC OperatiOnal praCtiCes
SQL>select * from gv$pwfile_users where username='RS';
The Clusterware resource for the database also has a new attribute referring to the password file; in this example, the password file is stored in ASM.
$ crsctl stat res ora.orcl12.db –p |more
...
To manage a database, it is advisable to use the srvctl command. While it is possible to manage databases as Clusterware objects using crsctl commands, you should try to use the srvctl command whenever possible. The srvctl command provides an additional layer of security and avoids unnecessary activity in the Clusterware owner account.
The general syntax of the srvctl command is given in the following. To start or stop a database, you would use the following command:
Chapter 3 ■ raC OperatiOnal praCtiCes
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 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.
USR_ORA_INST_NAME@SERVERNAME(RAC1)=ORCL1
USR_ORA_INST_NAME@SERVERNAME(RAC2)=ORCL2
91
