Monday, July 22, 2013

Post 54 of series - Install Oracle RAC 12c on Vmware with Windows 7 64-bit as host OS and Linux CentOS or RHEL 6 as guest OS (Part 7, Create Oracle database 12c with dbca)

Uncounted millions, so many they are endless, search for Him. But only that one, who understands his own self, sees God near at hand.

[oracle@rac20 ~]$ cd /u01/app/
[oracle@rac20 bin]$ ./asmca

Make sure external is clicked and pick disk 3 as shown below. I will name the diskgroup as FLASH.

Click "OK" to create this diskgroup.

Click "OK"

Now add disk to data disk group. Right click on DATA disk group and click "Add Disks".

Pick disk 4 and click "OK".

Click "OK"

Click "Close".

Now start "dbca" as :

[oracle@rac20 bin]$ cd /u01/app/oracle/product/
[oracle@rac20 bin]$ ./dbca

Click "Create Database" and click "Next".

Type "Global DatabaseName" as "prabgun"
Then make sure ASM is selected
Datafiles location as "+DATA" and
"Fast Recovery Area" as "+FLASH"
Select database character set as:  AL32UTF8
Put your admin password and click "Next". If "Fast Recovery Area" is not "+FLASH" then select it by clicking "BROWSE" button.

Click "Yes".

Check all the warnings and these can be ignored and click next.

Click "Finish" and see the install go through.

Click "Exit".

Click Close and the database is ready. 

Now login into the database and see its up and running:

[oracle@rac20 ~]$ export ORACLE_SID=prabgun1
[oracle@rac20 ~]$ cd /u01/app/oracle/product/
[oracle@rac20 bin]$ export ORACLE_HOME=/u01/app/oracle/product/
[oracle@rac20 bin]$ ./sqlplus / as sysdba

SQL*Plus: Release Production on Mon Jul 22 12:07:11 2013

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

Connected to:
Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> set line 300
SQL> select * from gv$instance;

---------- --------------- ---------------- ---------------------------------------------------------------- ----------------- --------- ------------ --- ---------- ------- --------------- ---------- --- ----------------- ------------------ --------- --- ---------- ----------- -------
         2               2 prabgun2                                         21-JUL-13 OPEN         YES          2 STOPPED         ALLOWED     NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO           0 REGULAR     EE

         1               1 prabgun1                                         21-JUL-13 OPEN         YES          1 STOPPED         ALLOWED     NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO           0 REGULAR     EE


They alone join the Saadh Sangat, unto whom the Lord becomes Merciful. They chant and meditate on the Ambrosial Name of the Lord.

No comments:

Post a Comment