Enter Your Email

Enter your email address:

Delivered by FeedBurner

Custom Search

Thursday, March 13, 2008

Oracle 11g :: Creating Database with ASM using DBCA

Creating and configuring Oracle 11g Database on ASM using Database Configuration Assistant (DBCA).
1. Oracle Software should already installed on the server. (refer below url for step by step)
2. ASM Instance should already be created & configured and should be up and running.
VMWare Virtual Node – 2 CPU, 1024 MB
Host Operating System – Windows XP Professional SP 3
Guest Operating System – Oracle Enterprise Linux 4 (Update 5)
Oracle RDBMS –
Oracle ASM Instance –
1. Run DBCA from a terminal login as Oracle user. You can use PUTTY from a HOST System as well by setting the DISPLAY for x-windows.
Select -> Create Database
2. Select General Purpose, as this is just for testing purpose I want to use all the features of Oracle 11g and as well with the Example schemas. Real time i would prefer to create a seed database which would be CUSTOM DATABASE.
3. Database name: Here its db11g (You can choose as you like not more than 8 Characters)
4. Enterprise Manager Option
4 -1 . Warning : To configure Listener, so from a new terminal we need to run netca, please follow below URL for step by step on this.
Once you are done with NETCA configuring the LISTENER, Continue
5. I prefer to use same password (Just for testing Purpose and easy to remember)
6. Select Automatic Storage Management (ASM). Make sure that ASM instance is up & running and the LISTENER associated with it should be running as well.
7. ASM - SYS password "It should be same as what you entered when setting up ASM Instance"
8. Select the Disk Group Name which you would like your new database to use. Make sure that the disks are mounted and the Redundancy as set according to your needs.
9.Use Oracle-Managed Files - Location of the Database Area "+DATA" which it keeps all the datafiles, controlfiles, archive etc.
10. Flash Recovery Area, if your prefer (recommended) so many features that help DBA.
Enable Archiving.
11. Select Sample Schemas
12. Memory Management - I prefereed to use Automatic Memory Management to test Oracle 11g. As default it takes 40%, I set it to 28%. Rest of the tabs, i left default.
13. Security Settings - New feature of Oracle 11g. I preferred to keep pre-11g default security settings.
14. One more New Feature - > Automatic Maintenance tasks.
15. Database Storage - Location of Control file, size of redo and Datafiles.
16. Creation Options - Template (which i want to use) and the database creation script which i prefer to keep it for further reference.
17. Database creation complete.

I have my new Oracle 11g database with ASM as storage, and what all remained is i need to test the new features of Oracle 11g and to gain hands on - and plan to give Oracle 11g Upgrade for Administrators.

Wish me luck - Ravi Prakash

Wednesday, March 12, 2008

Oracle 11g :: netca (Listener Configuration for Oracle 11g Database)

Sometimes you need to run netca manually to configure Listener for your database. In Oracle 11g i found this message as a warning when selecting Database Control Configuration.

So planned to document this and of course this is one of the part of Oracle 11g Installation.
1. Open a terminal as a Oracle user and run netca.
Select -> Listener Configuration
2. Select Add, as we are going to create a LISTENER for a new setup. If we have any existing listener running on the Server, remain options will be highlight like "delete" "re-configure" etc.
3. Listener Name, or you can leave the existing one.
4. TCP is selected as default.
5. Select the Port here (or) you can leave the default port.

Oracle 11g :: Configuring ASM for Oracle 11g RDBMS

Setting up and configuring storage with ASM for Oracle 11g RDBMS
VMWare Version 1.0.8
Host Operating System: Windows XP – 32 Bit
Guest Operating System: OLE 4 (Update 5)
Oracle RDBMS Version:

1. Oracle Software should already installed on the server.

Click here -> For Step by step http://ravidba-oracle.blogspot.com/2008/07/oracle-11g-step-by-step-installation-on.html
2. Raw disks should already be formatted using fdisk and should be available to the server.

3. Disk Label should be created with ORACLE ASM LIB.

** Please download Oracle ASM Lib from OTN.
oracleasmlib-2.0.2-1.i386.rpm (or) you can configure this when you setup Linux by selecting
System Tools -> oracle oracleasm-2.6.9.. (driver for UP kernel).
[root@oracledb2 init.d]# ls -ltr oracleasm*
-rwxr-xr-x 1 root root 18114 Oct 24 2006 oracleasm
[root@oracledb2 init.d]# pwd
Usage: /etc/init.d/oracleasm {startstoprestartenabledisableconfigurecreatediskdeletediskquerydisklistdisksscandisksstatus}
For rest of the steps please follow the above URL to add the disks using oracleasm.
[root@oracledb2 init.d]# /etc/init.d/oracleasm listdisks
Once you have the disks in place, login as Oracle user and run DBCA
1. Select Configure Automatic Storage Management : Step 1 of 4 -> Click Next

2. A warning screen will appear. For ASM (Automatic Storage Management) the Oracle Cluster Synchronization Service (CSS) needs to be running. All you need to do is - login as a root user and run the localconfig reset from $ORACLE_HOME/bin directory, as shown in the below screen.

3. Open a termial / Putty section login as a root user, and execute localconfig reset from $ORACLE_HOME/bin.
Once you have the message "Oracle CSS service is installed and running under init" you can click "OK" at the warning screen.
4. Specify the password for the SYS user. (This is for ASM Instance).
7. I have missed few of the screens, you need to assign the Disk Group Name, assign the Volumes that we create before and select the redundancy. I created two Disk Group's.
spfiledb11g.ora => +DATA/DB11G/PARAMETERFILE/spfile.280.674840503
And the second group RECOVERYDEST/ for FLASH recovery area.
8. Mount the Disks - Click Mount All

9. Mounting Disk Groups...10. Disks are mounted, Next we create database.
Please refer my next post

Tuesday, March 04, 2008

Oracle 11G Step by Step Installation on Enterprise Linux 4

Oracle 11g(11.1): Step by Step Installation on Enterprise Linux 4
Will update the notes soon....

Copyright © 2005 - 2008 DBA-ONWeb Technical blog. All rights reserved