Creating Database with ASM using DBCA


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

1

 

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.

1

 

3. Database name: Here its db11g (You can choose as you like not more than 8 Characters)

1

 

4. Enterprise Manager Option

1

 

1

 

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)

1

 

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.

1

 

7. ASM – SYS password “It should be same as what you entered when setting up ASM Instance”

1

 

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.

1

 

9.Use Oracle-Managed Files – Location of the Database Area “+DATA” which it keeps all the datafiles, controlfiles, archive etc.

1

 

10. Flash Recovery Area, if your prefer (recommended) so many features that help DBA.

Enable Archiving.

1

 

11. Select Sample Schemas

1

 

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.

1

 

13. Security Settings – New feature of Oracle 11g. I preferred to keep pre-11g default security settings.

1

 

14. One more New Feature – > Automatic Maintenance tasks.

1

 

15. Database Storage – Location of Control file, size of redo and Datafiles.

1

 

16. Creation Options – Template (which i want to use) and the database creation script which i prefer to keep it for further reference.

1

 

17. Database creation complete.

1

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: