Thursday, March 13, 2008

Creating and configuring Oracle 11g Database on ASM using Database Configuration Assistant (DBCA).Prerequisites1. Oracle Software 11.1.0.6 should already installed on the server. (refer below url for step by step)http://ravidba-oracle.blogspot.com/2008/07/oracle-11g-step-by-step-installation-on.html2. ASM Instance should already be created & configured and should be up and running.http://ravidba-oracle.blogspot.com/2008/03/oracle-11g-configuring-asm-for-oracle.htmlHardware/Software:VMWare Virtual Node – 2 CPU, 1024 MBHost Operating System – Windows XP Professional SP 3Guest Operating System – Oracle Enterprise Linux 4 (Update 5)Oracle RDBMS – 11.1.0.6Oracle ASM Instance – 11.1.0.61. 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)

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.