Lets imagine one has to configure the existing database to the RAC One node/ GI Standalone. In 12c the syntax has slightly changed, the options become more meaningful.
[oracle@single1 ~]$ srvctl add -h
The SRVCTL add command adds the configuration and the Oracle Restart application to the OCR for the cluster database, named instances, named services, or for the named nodes.
Usage: srvctl add database -db-oraclehome [-domain ] [-spfile ] [-pwfile ] [-role {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY | FAR_SYNC}] [-startoption ] [-stopoption ] [-dbname ] [-instance ] [-policy {AUTOMATIC | MANUAL | NORESTART}] [-diskgroup " "]
For the database with name ED12, the command would be:
srvctl add database -db ED12 -oraclehome /u01/oracle/product/12.1.0/dbhome_1 -spfile '/u01/oracle/product/12.1.0/dbhome_1/dbs/spfileED12.ora' -policy AUTOMATIC -startoption OPEN -stopoption IMMEDIATE
[oracle@single1 ~]$ srvctl status database -d ED12
Database is not running.
[oracle@single1 ~]$ srvctl start database -d ED12
[oracle@single1 ~]$ ps -ef | grep pmon
oracle 2737 1 0 12:10 ? 00:00:00 asm_pmon_+ASM
oracle 3140 1 0 12:27 ? 00:00:00 ora_pmon_ED12
oracle 3351 2906 0 12:27 pts/0 00:00:00 grep pmon
Is the OLD syntax still working? Yes it does.
[oracle@single1 ~]$ srvctl stop database -d ED12
[oracle@single1 ~]$ srvctl remove database -d Ed12 -f
[oracle@single1 ~]$ srvctl status database -d Ed12
PRCD-1120 : The resource for database Ed12 could not be found.
PRCR-1001 : Resource ora.ed12.db does not exist
[oracle@single1 ~]$ srvctl add database -d ED12 -o /u01/oracle/product/12.1.0/dbhome_1 -p '/u01/oracle/product/12.1.0/dbhome_1/dbs/spfileED12.ora' -y AUTOMATIC -s OPEN -t IMMEDIATE
[oracle@single1 ~]$ srvctl start database -d ED12
[oracle@single1 ~]$ ps -ef | grep pmon
oracle 2711 1 0 12:31 ? 00:00:00 asm_pmon_+ASM
oracle 3360 1 0 12:36 ? 00:00:00 ora_pmon_ED12
oracle 3773 2558 0 12:44 pts/0 00:00:00 grep pmon
No comments:
Post a Comment