I am new to Exadata. I would like to create a database on Exadata sever. I am working on Quarter RAC.
Please can I know how to create ASM disk group on ASM.
Also how to check the space on Exadata. Is there any documentation which list commands/syntax to check on space, creating disk group etc.
I cannot see any space when doing df -h
[reidm@dm01db01 ~]$ echo $ORACLE_HOME
[reidm@dm01db01 ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
30G 16G 13G 56% /
/dev/sda1 124M 19M 99M 17% /boot
99G 21G 73G 23% /u01
tmpfs 81G 196M 81G 1% /dev/shm
/dev/sdb1 3.8G 3.5G 303M 93% /mnt/usb
The machine config is
[reidm@dm01db01 ~]$ uname -a
Linux dm01db01.uklond6.savvis.net 2.6.18-188.8.131.52.2.el5 #1 SMP Tue Jun 28 05:21:19 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
SQL> 1 create diskgroup DATA_SSD normal redundancy disk 'o/*/ssddisk*' 2 attribute 'compatible.rdbms'='184.108.40.206.0', 3 'compatible.asm'='220.127.116.11.0', 4 'cell.smart_scan_capable'='TRUE', 5* 'au_size'='4M' Alternatively you can use the database control for the ASM instance to create the new diskgroup. Your new flash disks should show up as candidate disks.
ps -ef | grep pmonif so as oracle set your environment to the instance and do asmcmd.
user5846399 wrote:So you have a full rack, and want 1 database with 7 instances and 1 node with a separate database instance? Clarify if need be.
I want to install 8 database 7 RAC and 1 single instance.
I would like to create separate diskgroup for each database. As per your reply if 3 disk group created by oracle consumes all the space, then I will not be able to create new disk group. So I have to use existing diskgroup.So you want 2 diskgroups? Clarify if need be?
Can this have a performance impact?Certainly. Depending on how you implement them.