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/12.1.0.1/grid/bin/
[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/12.1.0.1/bin/
[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/12.1.0.1/bin
[oracle@rac20 bin]$ export ORACLE_HOME=/u01/app/oracle/product/12.1.0.1
[oracle@rac20 bin]$ ./sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 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 12.1.0.1.0 - 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;

   INST_ID INSTANCE_NUMBER INSTANCE_NAME    HOST_NAME                                                        VERSION           STARTUP_T STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_WAIT LOGINS      SHU DATABASE_STATUS   INSTANCE_ROLE      ACTIVE_ST BLO     CON_ID INSTANCE_MO EDITION
---------- --------------- ---------------- ---------------------------------------------------------------- ----------------- --------- ------------ --- ---------- ------- --------------- ---------- --- ----------------- ------------------ --------- --- ---------- ----------- -------
FAMILY
--------------------------------------------------------------------------------
         2               2 prabgun2         rac21.rac.meditate.com                                           12.1.0.1.0        21-JUL-13 OPEN         YES          2 STOPPED         ALLOWED     NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO           0 REGULAR     EE


         1               1 prabgun1         rac20.rac.meditate.com                                           12.1.0.1.0        21-JUL-13 OPEN         YES          1 STOPPED         ALLOWED     NO  ACTIVE            PRIMARY_INSTANCE   NORMAL    NO           0 REGULAR     EE



SQL>



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