How to configure database with Oracle 12c Restart

##################################################
How to configure database with Oracle 12c Restart
#################################################

Note: Although the Oracle Grid Infrastructure automatically registers database if GI is installed prior to DB but
in my case, I already had Oracle database created and GI was added later on.
Now I need to register my Oracle database with Oracle Restart (Grid Infrastructure on Standalone)


============================
Current configuration
============================
SQL> !srvctl config database

Note: The srvctl command is running from Oracle database ORACLE_HOME/bin


============================
Add database 
============================
SQL> !/u03/app/oracle/12.1.0/12cR1/bin/srvctl add database -d cdbdemo -o /u03/app/oracle/12.1.0/12cR1


SQL> !/u03/app/oracle/12.1.0/12cR1/bin/srvctl config
cdbdemo


SQL> !/u03/app/oracle/12.1.0/12cR1/bin/srvctl config database -d cdbdemo
Database unique name: cdbdemo
Database name:
Oracle home: /u03/app/oracle/12.1.0/12cR1
Oracle user: oracle
Spfile:
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Database instance: cdbdemo
Disk Groups:
Services:



============================
Testing
============================
[root@dbtrmrk init.d]# ps -ef | grep smon | grep -v grep
oracle   20922     1  0 03:48 ?        00:00:00 asm_smon_+ASM
oracle   21824     1  0 05:17 ?        00:00:00 ora_smon_cdbdemo


[root@dbtrmrk init.d]# kill -9 21824
[root@dbtrmrk init.d]# ps -ef | grep smon | grep -v grep
oracle   20922     1  0 03:48 ?        00:00:00 asm_smon_+ASM

NOte: Oracle Database was not started by Restart....

hmm...what is missing? spfile ???? let's try





SQL> !srvctl modify database -db cdbdemo -spfile /u03/app/oracle/12.1.0/12cR1/dbs/spfilecdbdemo.ora


SQL> !srvctl config database -db cdbdemo
Database unique name: cdbdemo
Database name:
Oracle home: /u03/app/oracle/12.1.0/12cR1
Oracle user: oracle
Spfile: /u03/app/oracle/12.1.0/12cR1/dbs/spfilecdbdemo.ora
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Database instance: cdbdemo
Disk Groups: DATA
Services:




[root@dbtrmrk init.d]# ps -ef | grep pmon
oracle   23317     1  0 06:09 ?        00:00:00 asm_pmon_+ASM
oracle   24267     1  0 06:14 ?        00:00:00 ora_pmon_cdbdemo

[root@dbtrmrk init.d]# kill -9 24267

Fri May 09 06:29:34 2014
Instance started by oraagent
Completed: ALTER DATABASE MOUNT /* db agent *//* {0:9:7} */
Fri May 09 06:30:32 2014
CJQ0 started with pid=56, OS id=27907
Completed: ALTER DATABASE OPEN /* db agent *//* {0:9:7} */



[root@dbtrmrk init.d]# /u10/app/gridbase/product/grid/12gR1/bin/crsctl status resource -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMDG.dg
               ONLINE  ONLINE       dbtrmrk                  STABLE
ora.DATA.dg
               ONLINE  ONLINE       dbtrmrk                  STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       dbtrmrk                  STABLE
ora.asm
               ONLINE  ONLINE       dbtrmrk                  Started,STABLE
ora.ons
               OFFLINE OFFLINE      dbtrmrk                  STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cdbdemo.db
      1        ONLINE  ONLINE       dbtrmrk                  Open,STABLE
ora.cssd
      1        ONLINE  ONLINE       dbtrmrk                  STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       dbtrmrk                  STABLE
--------------------------------------------------------------------------------

Enjoy....Abid Malik