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;









11 comments:

  1. Value for this reason useful providing. Chiropractic is generally a wellness vocation which focuses on upon illnesses about the musculature procedure combined with the tight procedure. Currently just click right here Cash Advance Spring-Valley Combined with the unwanted effects these types of illnesses.

    ReplyDelete
  2. I've lost my portfolio Your portfolio is probably still in our system. It is possible that you spelled your login email incorrectly and created another account by mistake. You can also login with the same email to the website to confirm it is still there.

    Damn Monty Python to hell for mocking our one true Lord and savior Jesus Christ, Nike Air Force 1 Cheap Outlet the King of Kings! Coach Outlet Online Yep, Python faced MK Outlet Online extreme Jordan Shoes For Sale wrath from religious quarters for their mistreatment of the Lord. Numerous countries such as Ireland and Cheap Michael Kors Handbags Norway banned the film outright for years. In a famous moment (for Ray Ban Outlet British television anyway) Mervyn Stockwood, the Anglican Bishop of Southwark, debated John Cleese and Coach Outlet Clearance Sale Michael Palin on air, likening the Pythons to Judas, and claiming they would get their "30 pieces of Best Yeezys silver" for the film...

    ReplyDelete