Oracle Real Application Cluster (RAC) is the successor to Oracle Parallel Server (OPS) and allows multiple instances to access the same database (storage) accessing and modifying the same data at the same time. RAC provides fault tolerance, load balancing, and performance benefits by allowing the system to scale out, and at the same time since [...]
Author Archive
Basic RAC configuration
Mass Deployment Agent Installation
$ cat agent_down.ksh export AGENT_INSTALL_PASSWORD=${AGENT_PASSWORD} ./agentDownload.linux_x64 -b /apps/oracle/product -m rac01.dbaexpert.com -r 4900 -y Download the agentDownload.linux_x64 script from Grid Control Server to each of the clients. Leveraging the mass deployment agent installation method, you can deploy Oracle Intelligent Agents in matter of minutes. This script will basically download the product jar file and install the [...]
Partition Alignment with sfdisk 1 comment
# – # — Partition alignment of OCR / Vote Disks with 1MB offset echo “2048,,” | sfdisk -uS /dev/emcpowera echo “2048,,” | sfdisk -uS /dev/emcpowerb echo “2048,,” | sfdisk -uS /dev/emcpowerc # – # — Partition alignment of Data / FRA disks with 4MB offset echo “8192,,” | sfdisk -uS /dev/emcpowerd echo “8192,,” | [...]
Check for space on your ASM instance Leave a comment
Here’s a simple script to see how much space that you have at the disk and disk group level. This script should work on all the operating systems but only tested on Linux. The only portion that you will have to change is the ‘ps -ef’ line. export DB=$(ps -ef |grep +ASM |grep -i pmon [...]
ASM Sector Size for disk groups Leave a comment
Being able to specify a sector size larger than the default 512 bytes is another ASM feature of Oracle Databases 11g Release 2. Now, we can specify a sector size up to 4k. There is a new SECTOR_SIZE attribute while create the ASM disk group. ASM Cluster File System (Oracle ACFS) does not support 4 [...]
Ways to mount and dismount disk groups in Oracle Database 11g Release 2 Leave a comment
Prior to Oracle Database 11g Release 2, you had to issue the following commands in sqlplus to mount and dismount a diskgroup: SQL> alter diskgroup fra mount; Diskgroup altered. SQL> alter diskgroup fra dismount; Diskgroup altered. As of Oracle Database 11g Release 2, an easier and more SA friendly approach is provided with asmcmd: ASMCMD> [...]
Volume Management with asmcmd Leave a comment
Creating Volumes with the volcreate command ASMCMD> volcreate -G lobdata -s 4g vol_lob2 Note: You can not create a mirror or high redundancy volume on an external redundant disk group. ASMCMD> volcreate -G lobdata -s 4g –redundancy mirror vol_lob2 ORA-15032: not all alterations performed ORA-15471: volume redundancy incompatible with diskgroup redundancy (DBD ERROR: OCIStmtExecute) Displaying [...]
Setup ASMLIB Leave a comment
FDISK Output [root@rac103 ~]# fdisk -l Disk /dev/hda: 82.3 GB, 82348277760 bytes 240 heads, 63 sectors/track, 10637 cylinders Units = cylinders of 15120 * 512 = 7741440 bytes Device Boot Start End Blocks Id System /dev/hda1 * 1 1354 10236208+ 83 Linux /dev/hda2 1355 6772 40960080 83 Linux /dev/hda3 6773 7043 2048760 82 Linux swap [...]
Rename Disk Group Leave a comment
As of Oracle Database 11g Release 2, we can now rename disk groups. Why is this important? There’s two great reason why I think this feature is really beneficial for lot of companies. First, companies who leverage hardware mirroring or triple mirroring technologies such as EMC Business Continuity Volumes (BCV) or Hitachi Shadow Image (SI) [...]
Top Ten ASM Questions Presentation Leave a comment
TOP Ten ASM Questions Presentation by Nitin Vengurlekar at the Dallas Oracle User Group Posted by Charles Kim, Oracle ACE