Moving to Oracle RAC One Node - Page 12

9. Create a second Oracle Database (racdb) on the spare node

You can create as many databases as you need in the cluster as long as you have the system resources to support the databases. We will create another database, racdb on the spare node, gurnard2 to take advantage of the idle resources (requires Oracle RAC One Node license).

The procedure to create the database is similar to the steps outlined in section 5. Install Oracle Database 11g (appsdb). We specify racdb instead for the Global Database Name and SID and select gurnard2 as the node to install the database.

After the successful completion of the database installation, you will see the following:

oracle@gurnard1-> srvctl config database -d racdb
Database unique name: racdb
Database name: racdb
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/racdb/spfileracdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb1
Disk Groups: DATA,FRA
Services:
Database is administrator managed
 
oracle@gurnard1-> srvctl status database -d racdb
Instance racdb1 is running on node gurnard2

10. Initialize the second Database to Oracle RAC One Node

oracle@gurnard1-> raconestatus
 
RAC One Node databases on this cluster:
 
 
  Database UP Fix Required    Current Server       Candidate Server Names
  ======== == ============ ====================  ==========================
    appsdb  Y       N                  gurnard1           gurnard1 gurnard2

 
 
Available Free Servers:
 
 
oracle@gurnard1-> raconeinit
 
Candidate Databases on this cluster:
 
 #      Database        RAC One Node    Fix Required
===     ========        ============    ============
[1]       appsdb            YES               N
[2]        racdb             NO              N/A
 
Enter the database to initialize [1]: 2
 
 
Database racdb is now running on server gurnard2
 
Candidate servers that may be used for this DB: gurnard1
 
Enter the names of additional candidate servers where this DB may run (space delimited): gurnard1
 
Please wait, this may take a few minutes to finish.......
 
Database configuration modified.
 
 
 
oracle@gurnard1-> raconestatus
 
RAC One Node databases on this cluster:
 
 
  Database UP Fix Required    Current Server       Candidate Server Names
  ======== == ============ ====================  ==========================
    appsdb  Y       N                  gurnard1           gurnard1 gurnard2
     racdb  Y       N                  gurnard2           gurnard2 gurnard1
 
 
Available Free Servers:
 
 
oracle@gurnard1-> srvctl config database -d racdb
Database unique name: racdb
Database name: racdb
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/racdb/spfileracdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb_1
Disk Groups: DATA,FRA
Services:
Database is administrator managed
 
 
oracle@gurnard1-> srvctl status database -d racdb
Instance racdb_1 is running on node gurnard2
 
oracle@gurnard1-> srvctl status database -d appsdb
Instance appsdb_1 is running on node gurnard1

We now have created and configured two Oracle RAC One Node databases. For failover protection, racdb_1 instance can failover to gurnard1 and likewise, appsdb_1 instance can failover to gurnard2.