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
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.
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.