Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Oracle

Posted Oct 6, 2010

Moving to Oracle RAC One Node - Page 12

By Vincent Chan

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:

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

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.



Oracle Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM