Jagjeet's Oracle Blog!

April 26, 2010

ASM Migration Project

Filed under: ASM — Tags: — Jagjeet Singh @ 5:00 am


For the last month I have been working on ASM migration project for one of our client in United States.


lient wanted to move couple of environments (including Production, QA, and Dev/Patch) to ASM, critical production environment running EBusiness Suit 11.5.10.2 on raw devices utilizing 5.1 TB storage, other instances are utilizing cooked file systems.


I really enjoy working with ASM, the day it was released I got passionate about this feature and have been playing in my lab.  My manager considered my interest with ASM and assigned me to this project (thanks to him). I am very much excited for this project, let’s see how this goes.


This project includes OATM (Oracle Application Tablespace Model) conversion, re-write solution for Cluster Failover (HP Service Guard is configured for Cluster Failover), DR is implemented using EMC Mirror View, BCV & backup methodology.


I would like share my experience after first migration to ASM. This migration was done using fndtsmig.pl (Oracle given utility to migrate segments). This utility migrate (move/rebuild) segments based on pre-defined rules to choose appropriate tablespaces.


We just finished with our first Iteration, I was more interested to see equal distribution of I/O across the Luns.  I pulled below report from 10g grid control for %usage of one diskgroup.

Disk Usage %


It shows well balanced equal usage distribution (it’s awesome, isn’t it),


let’s have a look for IO usage



As soon as I saw this page, I noticed 3 things.


1-      IO distributions are quit close/equal for all the Luns of DGOAPSFC. Other columns Total Read Calls & Total write Calls are almost equal for all the Luns. That is why I like ASM for this capability.


2-      BUT this is not the case with DGOLTPFC diskgroup , this is really strange that 4 disks out of 10 Luns got 40% more high I/O. 


3-      I noticed there is huge difference in IO response time for 2 disks in DGOLTPFC


Point no. 1 is quite obvious and expected, for second point I tried to find the cause but still this is an open issue for me. I am working on this and would post more if I could get something.


For 3rd point, I immediately made call to my storage administrator and asked for the same if something wired at storage end for specifically for 2 disks as there is huge difference in IO response time. Other disks avg. response time is near 5.5 ms where as LUN 43 and LUN 46 it’s more 9 ms.


Storage guy asked me to give some time,  after some time he told me that because of space constraint he could not give me all FC disks, those 2 disks are SATA. J


For final implementation we would be provided FC and SSD disks only so we started using descriptive naming convention.


Again, I am thrilled to work in this project and would share my experience.

October 9, 2008

Access ASM through FTP and HTTP using XDB Configuration

Filed under: ASM — Tags: , , — Jagjeet Singh @ 11:25 am

10g release 2 introduced a new feature to access the ASM disk groups outside the database via FTP and through a web browser using HTTP.

The use of FTP and HTTP adds a flexibility to manage the ASM environment. Any FTP client can be used to move/copy the files stored on ASM.


Because ASM is not a regular file system which can be accessed using standard FTP and HTTP service. To make this enable we need to setup the Oracle XML DB access which is a one time setup. Oracle XML DB provides the file mapping functionality.


Disk groups can be available outside the database via a Virtual file system /sys/asm.


Please follow the below steps:


1) Follow the Note: 243554.1 “How to Deinstall and Reinstall XML Database(XDB)” to install the XDB.


We can check if XDB is installed from dba_registry.


SQL> select comp_id,comp_name,version,status from dba_registry
2 where comp_id = 'XDB';


COMP_ID    COMP_NAME            VERSION     STATUS
---------- -------------------- ----------- -----------
XDB        Oracle XML Database  10.2.0.1.0  VALID


2) Configure the ports for FTP and HTTP


This can be done by two ways:


i) By executing the below script from sysdba and pass the FTP and HTTP port.


SQL> start ?/rdbms/admin/catxdbdbca 2100 8000


ii) By calling the package’s routines after connecting sysdba.


SQL>; exec dbms_xdb.setftpport(2100)
PL/SQL procedure successfully completed.


SQL>; exec dbms_xdb.sethttpport(8000)
PL/SQL procedure successfully completed.


Configuration for FTP and HTTP port can be confirmed using


SQL> ho lsnrctl status | grep TP


(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=js)(PORT=2100))(Presentation=FTP) (Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=js)(PORT=8000))(Presentation=HTTP)(Session=RAW))


Now we are ready to access ASM disk groups using FTP client or HTTP browser.
I have used the System database user to connect.


For access through web browser : http://hostaddress:8000


Below is the screen shot for FTP

FTP Client connected to ASM

FTP Client connected to ASM

Create a free website or blog at WordPress.com.