GPnP Profile Inside: pending.xml always creates, whether profile.xml exists or not: Practical 1 : Stop and start crs after removing profile.xml: Step1: Renamed profile.xml to profile.paw : [grid@paw-racnode1 ~]$ cd /u01/app/11.2.0/grid/gpnp/paw-racnode1/profiles/peer/ [grid@paw-racnode1…
Category: Database
GPnP ( Grid plug n play ) profile in Oracle 11g R2/12c RAC
GPnP ( Grid plug n play ) profile in Oracle 11g R2/12c RAC : What is GPnP profile and Why it is needed? With reference to my OCR and Voting Disk Blog…
ASM-Disks-Creation For RAC- Airy’s Notes
ASM Disks Creation for RAC: [root@paw-racnode1 ~]# chown oracle:oinstall /dev/sd[b-k] [root@paw-racnode1 ~]# vi /etc/rc.d/rc.local [root@paw-racnode1 ~]# fdisk -l [root@paw-racnode1 ~]# fdisk /dev/sdb [root@paw-racnode1 ~]# fdisk /dev/sdc [root@paw-racnode1 ~]# fdisk /dev/sdd [root@paw-racnode1 ~]#…
Hybrid Columnar Compression in Oracle R2
Hybrid Columnar Compression (Release 2 Only on Oracle Exadata) : In 11g Release 2 (but only if pre-installed with Oracle Exadata v2), compression technology has been extended in the form of Hybrid Columnar…
Table Compression Enhancements in Oracle Database 11g R1 Airy’s Notes
Table Compression Enhancements in Oracle Database 11g R1 : Table compression was introduced in Oracle 9i as a space saving feature for data warehousing projects. In 11g it is now considered a…
RMAN Recovery Catalog-Airy’s Notes
1: What is RMAN Recovery Catalog – Airy’s Notes 2: RMAN BASE RECOVERY CATALOG DATABASE CREATION – Airy’s Notes 3: Querying RMAN Base Recovery Catalog Thank you for Reading…This is AIRY…Enjoy 🙂
Automatic Storage Management Fast Mirror Resync in Oracle 11g – Airy’s Notes
Automatic Storage Management Fast Mirror Resync in Oracle 11g: The main purpose of Introducing ASM was to provide a batter Data Redundancy to the database and to discourage RAID at hardware level. ASM…
Oracle ASM File Access Control for Disk Groups in Oracle 11g – Airy’s Notes
Oracle ASM File Access Control for Disk Groups in Oracle 11g: Oracle ASM File Access Control provides optional protection for the content of Oracle ASM disk groups from accidental access by unauthorized…
Using ASM Scalability and Performance Enhancements in Oracle 11g – Airy’s Notes
Using ASM Scalability and Performance Enhancements in Oracle 11g: This feature increases the maximum data file size that Oracle can support to 128 TB. ASM supports file sizes greater than 128 TB…
Oracle 11g ASM Diskgroup Compatibility – Airy’s Notes
Oracle 11g ASM Diskgroup Compatibility: In Oracle 10.2, the are two new column COMPATIBILITY and DATABASE_COMPATIBILITY added to the V$ASM_DISKGROUP view, but only in Oracle 11g introduce the concept of diskgroup attributes and the V$ASM_ATTRIBUTE view. New…