How to : Add database to CRS

Mostly right now i’d been working on 2 node database cluster. so when doing a patching i need to stop all the database in both nodes.

someone is doing a testing on the server and created a new database but when stopping it won’t allow me.. and resulted me to stop it using sqlplus.

so i decided to add it to CRS.

[oracle@kxxxxsgtu21 ~]$ srvctl status database -d POCTEST1
PRCD-1120 : The resource for database POCTEST1 could not be found.
PRCR-1001 : Resource ora.poctest1.db does not exist
[oracle@kxxxxsgtu21 ~]$


Now lets add it …

[oracle@kxxxxsgtu21 ~]$ srvctl add database -d POCTEST -o /optware/oracle/11.2.0.4/db_1

[oracle@kxxxxsgtu21 ~]$ srvctl config database -d POCTEST
Database unique name: POCTEST
Database name:
Oracle home: /optware/oracle/11.2.0.4/db_1
Oracle user: oracle
Spfile: /optware/oracle/11.2.0.4/db_1/dbs/initPOCTEST1.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: POCTEST
Database instances:
Disk Groups: DATA,FRA
Mount point paths:
Services:
Type: RAC
Database is administrator managed
[oracle@kxxxxsgtu21 ~]$

Register the database instance, make sure to register the instance before doing anything.

[oracle@kxxxxsgtu21 ~]$ srvctl add instance -d POCTEST -i POCTEST1 -n kxxxxsgtu21

[oracle@kxxxxsgtu21 ~]$ srvctl config database -d POCTEST
Database unique name: POCTEST
Database name:
Oracle home: /optware/oracle/11.2.0.4/db_1
Oracle user: oracle
Spfile: /optware/oracle/11.2.0.4/db_1/dbs/initPOCTEST1.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: POCTEST
Database instances: POCTEST1
Disk Groups: DATA,FRA
Mount point paths:
Services:
Type: RAC
Database is administrator managed

Using srvctl you can check the status of the database.

[oracle@kxxxxsgtu21 ~]$ srvctl status database -d POCTEST
Instance POCTEST1 is not running on node kxxxxsgtu21
[oracle@kxxxxsgtu21 ~]$

thanks!

Advertisements

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