In normal circumstances when you have the Grid infrastructure installed (or Oracle Restart, or ASM) when a database is created, it will add a resource to the GC (Grid Control) and all is well.
But when doesn’t happen, be prepared to be surprised..OEM will report systems down, not able to connect, while the system is up etc..
The process is very easy, when you know how..but isn’t this always the case? 😉
It is a two step process: first add the database itself, then the instance(s) you have.
Step 1: add the database resource
$ srvctl add database -d ORCL -o /home/of/the/database/db_1
Step 2: add the instance to the database resource
$ srvctl add instance -d ORCL -i ORCL1 -n server01 (Optional) $ srvctl add instance -d ORCL -i ORCL2 -n server02
Check if the cluster is aware of the new resource:
$ crsctl stat res ora.ORCL.db -p < a lot of info>
And that’s all.. Success!
