OTN Appreciation Day: ASM

OTN Appreciation Day: ASM

First thing I have to say, Thanks Tim for this great idea. Tim Hall I have to say one of my favorite features has to be the Oracle ASM. Oracle ASM is the storage/file system where you store your data files and other database files. One of the great advantages I like is that you can add or remove disks without any downtime! To give you a great example is that a few months back I had to change the disks that our ASM was using to faster ones, we were able to add these new disks to the ASM and remove the old disks without any system outage. A blog post I had written earlier show's how this work's - Adding New ASM Disks If you don’t use ASM, I would be asking why! Kiran

Adding New ASM Disks

We have decided to add some new disks to our ASM and migrate the data.

We have decided to add some new disks to our ASM and migrate the data, Easy First as root check we can see the new disks on the machine: If we log onto our ASM, we can see the current disks mounted: Lets create the new disk. Now that we have listed disks, we can find where they are attached We can use the above to locate physical disk in /dev As for the commands we need to issue to modify the FRA diskgroup we would need to do the below: Monitor the migration using the below, increase power if needed: If you want to pause: Once finished we can review the disks by issuing the command below, we can see FRA1 is closed and we have moved to the new disk.

ERROR: -14(asmlib /opt/oracle/extapi/64/asm/orcl/1/libasm.so version failed with 2

So you have decided to patch your OS, after patching you cannot start the ASM, when you look into the alert log for the ASM you see the following: Errors in file /u01/app/oracle/product/11.2.0/grid/log/diag/asm/+asm/+ASM/trace/+ASM_rbal_5702.trc: ORA-15183: ASMLIB initialization error [driver/agent not installed] WARNING: FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so ERROR: no read quorum in group: required 2, found 0 disks NOTE: cache dismounting (clean) group 1/0xC9C86BB1 (DATA) NOTE: messaging CKPT to quiesce pins Unix process pid: 5733, NOTE: dbwr not being msg'd to dismount NOTE: lgwr not being msg'd to dismount NOTE: cache dismounted group 1/0xC9C86BB1 (DATA) NOTE: cache ending mount (fail) of group DATA number=1 incarn=0xc9c86bb1 NOTE: cache deleting context for group DATA 1/0xc9c86bb1 Tue Jun 09 17:28:12 2015 ERROR: -14(asmlib /opt/oracle/extapi/64/asm/orcl/1/libasm.so version failed with 2 ) Check the following as it could be the kernal: # uname -rm 2.6.18-406.el5 x86_64 # rpm -qa |grep asm oracleasm-2.6.18-371.3.1.el5-2.0.5-1.el5 oracleasm-support-2.1.8-1.el5 oracleasmlib-2.0.4-1.el5 We can see from the above commands that the kernal has changed to 2.6.18-406 and we only have the packages installed for 2.6.18-371.  We need to download the package. Navigate to : http://www.oracle.com/technetwork/server-storage/linux/downloads/rhel5-084877.html Scroll down to your architecture for example Intel EM64T (x86_64) Architecture Library and Tools From here we can see in the list the following : oracleasm-2.6.18-406.el5-2.0.5-1.el5.x86_64.rpm - This matches our kernal from our OS command earlier, download this. # rpm -Uvh oracleasm-2.6.18-406.el5-2.0.5-1.el5.x86_64.rpm warning: oracleasm-2.6.18-406.el5-2.0.5-1.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159 Preparing... ########################################### [100%] 1:oracleasm-2.6.18-406.el########################################### [100%] # /etc/init.d/oracleasm start Initializing the Oracle ASMLib driver: [ OK ] Scanning the system for Oracle ASMLib disks: [ OK ] The ASM is up and running again!!!