1. Login to ORACLE user first.

oracle_user.JPG

2.  Following WELCOME SCREEN will appear, Click NEXT

welcome_screen.JPG

3. Select the operation that you want to perform, Select CREATE A DATABASE and Click NEXT

operation.JPG

4. Select Database Templates, Select GENERAL PURPOSE or TRANSACTION PROCESSING and Click NEXT

GENERAL.JPG

5. Under Database Identification, Type GLOBAL DATABASE NAME and SID accordingly and Click NEXT

global_db.JPG

6. Under MANAGEMENT OPTION, Simply Click NEXT

EM.JPG

7. Enter Database Credentials accordingly, You give individual password for each of the ADMINISTRATIVE users or You can give only one password for all the FOUR users. Click NEXT

pass.JPG

9. If you password standards does not meet then you might see the following message, Simply Click YES

yes.JPG

10. Under Database File Locations, Select STORAGE TYPE to AUTOMATIC STORAGE MANAGEMENT (ASM)

asm.JPG

11. Under Database File Locations, Select USE ORACLE-MANAGED FILES and then Click on BROWSE

managedone.JPG

12. After Clicking BROWSE from above, Following screen will appeared select DATA and Click OK

13. Again first of all make sure that you have selected the following one, after then Click NEXT
Storage Type : Automatic Storage Management (ASM)

Select o USE ORACLE-MANAGED FILE
Click browse and Select DATA

again.JPG

14. After Clicking NEXT, It will ask for the ASM PASSWORD. Give the Password accordingly and Click OK

asmnew.JPG

15. NOTE : IF YOU SEE Could not validate ASMSNMP password due to following error- "ora-01017" ERROR MESSAGE then follow the following STEPS.

[grid@storage ~]$  sqlplus / as sysasm

 

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 6 12:52:18 2016

 

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Automatic Storage Management option

 

SQL> Alter user asmsnmp identified by asmnepal;

 

User altered.

 

SQL>

asmsnmp.JPG

ANOTHER WAY TO CHANGE ASMSNMP password is through ASMCD

[grid@storage ~]$ asmcmd

asmcmd> orapwusr --modify --password asmsnmp

asmcmd>Enter password: **********

16. Re-Type the password again and Click NEXT

asmnew.JPG

17. Under Recovery Configuration, Make sure to do the following steps and then Click NEXT

Click on  check box [] SPECFIFY FLASH RECOVERY AREA

Under Flash Recovery Areat : Click BROWSE and Select +FRA
Click on [ ] Enable Arciving

 

recovery.JPG

18. Under Database Content, Make sure you have click on [] SAMPLE SCHEMAS and Click NEXT

sample.JPG

19. Under Initialization Parameters, At CHARACTER SETS tabs Select USE UNICODE(AL32UTF8) and Click NEXT

unicode.JPG

20. Database Storage Screen will appear, Click NEXT

storage.JPG

21. Under CREATION OPTIONS, Make Sure you have selected [ ] CREATED DATABASE and [ ] GENERATE DATABASE CREATION SCRIPTS and then Click FINISH

creationoptions.JPG

21. Confirmation message will appear. Click OK

confirmation.JPG

22. You will see the DATABASE CREATION SCRIPT GENERATION display. Click OK

dbcreationscripts.JPG
23. And now the INSTALLATION process will begin. Wait for the INSTALLATION

dca.JPG

23. NOTE : During Installation if you get the message saying SET ORACLE_UNIQUE NAME TO orcl and RUN ENTERPRISE MANAGER then DO NOTHING. Simply click at OK only

 

24. After 100% Complete, You will see the following message :

dcaone.JPG

25. OUTPUT OF LISTENER STATUS AFTER DATABASE CREATION.

 

CREATING DBCA IS NOW COMPLETE