Thursday, September 8, 2011

11gR2 Oracle Grid infrastructure with ASM for a Standalone Server with Virtual RAW disks

REASON

1.                   I have RAC(Real Application Cluster) 11gR2 in production. For DR(Disaster Recovery) we don't need RAC. So I need to install Grid Infrastructure with ASM for Standalone serve on remote server and there is only one server with file system ext3 one mount point /opt. I need to configure ASM before we switching primary RAC DB to DR Single instance with Grid Infrastructure. Main idea we mount to DR server all our ASM disks.



Create Virtual RAW disk on Single DR server, to able install GRID infrastructure;

mkdir /opt/asm

dd if=/dev/zero of=/opt/asm/disk1 bs=1024 count=2097152
dd if=/dev/zero of=/opt/asm/disk2 bs=1024 count=2097152
dd if=/dev/zero of=/opt/asm/disk3 bs=1024 count=2097152

chown grid:asmadmin: /opt/asm/disk*

losetup /dev/loop1 /opt/asm/disk1
losetup /dev/loop2 /opt/asm/disk2
losetup /dev/loop3 /opt/asm/disk3

raw /dev/raw/raw1 /dev/loop1
raw /dev/raw/raw2 /dev/loop2
raw /dev/raw/raw3 /dev/loop3

chown grid:asmadmin /dev/raw/raw[1-3]


install Grid Infrastructure and Oracle database with ASM support


 
[root@lv-dr-rtpsdb3 oracle]# /opt/app/oraInventory/orainstRoot.sh
Changing permissions of /opt/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /opt/app/oraInventory to oinstall.
The execution of the script is complete.
[root@lv-dr-rtpsdb3 oracle]# /opt/app/11.2.0/grid/root.sh
Running Oracle 11g root script...

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /opt/app/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /opt/app/11.2.0/grid/crs/install/crsconfig_p                   arams
Creating trace directory
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node lv-dr-rtpsdb3 successfully pinned.
Adding daemon to inittab
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.

lv-dr-rtpsdb3     2011/08/30 15:09:48     /opt/app/11.2.0/grid/cdata/lv-dr-rtpsd                   b3/backup_20110830_150948.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
[root@lv-dr-rtpsdb3 oracle]#


Than substitute ASM init+ASM.ora with your production RAC ASM configuration file, restart HSA

under user grid or root

crsctl stop has
crsctl start has
CRS-4123: Oracle High Availability Services has been started.


than under oracle check

if ASYNC is ON?, if you see output it is linked, it should be linked

ldd $ORACLE_HOME/bin/oracle | grep libaio
nm $ORACLE_HOME/bin/oracle | grep io_getevent
 

if RAC is LINEKED to ORACLE, 0 is not linked, it should be 0. To swith off cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk rac_off ioracle

cd $ORACLE_HOME/rdbms/lib
nm -r libknlopt.a | grep -c kcsm.o
 

take initDB.ora file switch off claster configuration

and startup your DB on ASM as a single instance;









No comments:

Post a Comment