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

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Aug 9, 2006

Part 15: Creating database using DBCA on Redhat 4.2 Advanced Server - Page 2

By Tarry Singh

DBCA installation:

DBCA is the database creation agent, although in previous versions, you could also install complete databases via scripts. I advise using the tools provided in the installation pack as these tools have matured enough since version 8.

Don't forget to check that Oracle homes like $ORACLE_HOME and $PATH are set properly. Again, we will allow for remote connections.

To start the database creation process, run the following:

# xhost +
access control disabled, clients can connect from any host

Now change back to Oracle use:

# su – oracle

And start the DBCA tool:

$ dbca &

Here we choose the RAC option; you can also choose the single instance database option as well.

Choose the "Create a Database" option:

Select all the available nodes by clicking on "Select All":

We take a "Transaction Processing" option (as we will, at some point on our course to "Administering our Oracle RAC" series, do some stress testing):

Select your GDN (Global Database Name). It could be "node1.mysite.com" and SID (Oracle System Identifier) prefix. Typically, "node1" will suffice; at least, I prefer it to have the same name as my GDN.

Here you are presented with several options, such as "Configuring the Database with Enterprise Manager", SMTP options such as email notification and email address. If you have your own DNS server running on another VMware Server, then you have all that information, if not create a small Linux box on a Virtual Server and create your little enterprise at home.

I chose the same password here; however, you will want to check your security policy, if you are planning to do this eventually in production.

Select the storage mechanism; there are several discussions on what to choose for what. We will pick ASM for our data. I am curious about the CFS as well, but I did not see to get past the errors when installing RAC on CFS signed disks. RAW devices are also a workable option. However, we will go ahead with what Oracle recommends.

Here we needed an ASM instance running. Should you be doing this on an previously RAC ready node, then your ASM instances were already running. Since this is a fresh install, we go ahead and opt for SYS password (that is the only one on ASM instance). Choosing the type of parameter file. We created a OCFS disk signed as spfileASM and we pick that option here.

Note: There are a lot of ASM parameters you can set by clicking on the ASM Parameters button but we won't go into details now.

All values filled in correctly and we can get our DBCA to create and start the ASM instances on all nodes. This will successfully start the ASM nodes. Do check your instances to see if they are running.


In this article, we looked at the companion CD installation and went ahead with the DBCA work and creating the ASM instances. We will go ahead with the creation of the ASM disk groups in our next article. On another note, I have already started testing the Solaris 10 on VMware Server as well as the new ESX 3.0 server. The installation is a breeze. I will try to keep the progress updated on my Oracle Performance Blog.

» See All Articles by Columnist Tarry Singh

Oracle Archives

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