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