Add Database Resource To Grid Control..Or..”Is Grid Losing Control?”

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!

Advertisements

About GemsOfProgramming

Beeing a previously enthusiastic Java programmer, I rolled into the Oracle Database Administration world. It turned out I got a knack for this, and since approx. 2000 I'm a full time DBA. My experiences touches lot of Oracle products like Forms and Reports 9/10, JDAPI, Application Server, Weblogic Fusion and of course: Oracle Enterprise Databases, JavaFX, Swing and other Java components.
This entry was posted in ASM, Databases and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s