Moving Databases from ASM to ZFS on Exadata
-
Exadata is the best database machine available to run every Oracle database
workload. But many times, within Exadata proliferate a large number of test
a...
Showing posts with label ASM. Show all posts
Showing posts with label ASM. Show all posts
Wednesday, May 2, 2012
Sunday, April 1, 2012
Saturday, February 4, 2012
Very interesting - ASM IO
Anand Prakash (@anandprakash86)
2/2/12 5:40 AM
Monitor RAC I/O with gv$iostat_function http://wp.me/ppZNJ-fG via @wordpressdotcom
2/2/12 5:40 AM
Monitor RAC I/O with gv$iostat_function http://wp.me/ppZNJ-fG via @wordpressdotcom
Wednesday, January 11, 2012
On Voting Disk & node eviction logic
Terrific deck of slides:
http://www.linkedin.com/osview/canvas?_ch_page_id=1&_ch_panel_id=1&_ch_app_id=17224180&_applicationId=1200&_ownerId=0&appParams={%22from%22:%22unknown%22,%22view%22:%22canvas%22,%22page%22:%22slideview%22,%22slideshow_id%22:%2210771668%22,%22ownerless%22:%221%22}
http://www.oracle.com/technetwork/database/oracle-clusterware-11grel2-owp-1-129843.pdf
http://www.linkedin.com/osview/canvas?_ch_page_id=1&_ch_panel_id=1&_ch_app_id=17224180&_applicationId=1200&_ownerId=0&appParams={%22from%22:%22unknown%22,%22view%22:%22canvas%22,%22page%22:%22slideview%22,%22slideshow_id%22:%2210771668%22,%22ownerless%22:%221%22}
http://www.oracle.com/technetwork/database/oracle-clusterware-11grel2-owp-1-129843.pdf
Sunday, January 8, 2012
Tuesday, August 25, 2009
Managing ASM Disk Discovery
Most of the times, when everything else fails we turn to setting ASM_DISKSTRING as '/dev/oracleasm/disks/*' and it is almost always guaranteed to work. But this way we know that the ASM Library is not used at all and disk discovery happens outside the Library. Not a good thing. This can be confirmed using kfod (kfod asm_diskstring=ORCL:* disks=all) . So, what should you tinker with then to use the ASM Lib rather than the SYSTEM library, as shown by the LIBRARY field of v$asm_disk? When doing a migration, you may also get a HEADER_STATUS=UNKNOWN and the errors ORA-15032, ORA-15063 and ORA-15186.
Well, if you are using multipathing s/w, you got to let the disk discovery use just the pseudo-devices and not any of the many single devices (thru' many I/O paths) that form a single pseudo device. If you are using EMC with PowerPath, set it to emcpower. If you are using NetApp with DeviceMapper, set it to dm.
oracle---tlxkrdbrr1.lex.lexmark.com--/home/oracle--orcl1
> su -
Password:
[root@tlxkrdbrr1 ~]# inq
Inquiry utility, Version V7.3-872 (Rev 0.0) (SIL Version V6.5.0.0 (Edit Level 872)
Copyright (C) by EMC Corporation, all rights reserved.
For help type inq -h.
...............................................................................
....
-------------------------------------------------------------------------
DEVICE :VEND :PROD :REV :SER NUM :CAP(kb)
-------------------------------------------------------------------------
/dev/sda :DELL :PERC 6/i :1.21 : : 142737408
/dev/sdb :NETAPP :LUN :7310 :HnanPJQ/ : 15728640
/dev/sdc :NETAPP :LUN :7310 :HnanPJQ/ : 20971520
/dev/sdd :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sde :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdf :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdg :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdh :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdi :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdj :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdk :NETAPP :LUN :7310 :HnanPJRN : 2097152
/dev/sdl :NETAPP :LUN :7310 :HnanPJQ/ : 15728640
/dev/sdm :NETAPP :LUN :7310 :HnanPJQ/ : 20971520
/dev/sdn :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdo :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdp :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdq :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdr :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sds :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdt :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdu :NETAPP :LUN :7310 :HnanPJRN : 2097152
/dev/sdv :NETAPP :LUN :7310 :HnanPJQ/ : 15728640
/dev/sdw :NETAPP :LUN :7310 :HnanPJQ/ : 20971520
/dev/sdx :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdy :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdz :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/dm-0 :DELL :PERC 6/i :1.21 : : 142737408
/dev/dm-1 :DELL :PERC 6/i :1.21 : : 142737408
/dev/dm-2 :DELL :PERC 6/i :1.21 : : 142737408
/dev/dm-3 :DELL :PERC 6/i :1.21 : : 142737408
/dev/dm-4 :DELL :PERC 6/i :1.21 : : 142737408
/dev/dm-5 :DELL :PERC 6/i :1.21 : : 142737408
/dev/dm-6 :DELL :PERC 6/i :1.21 : : 142737408
/dev/dm-7 :DELL :PERC 6/i :1.21 : : 142737408
/dev/dm-8 :DELL :PERC 6/i :1.21 : : 142737408
/dev/dm-9 :DELL :PERC 6/i :1.21 : : 142737408
/dev/sdaa :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdab :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdac :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdad :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdae :NETAPP :LUN :7310 :HnanPJRN : 2097152
/dev/sdaf :NETAPP :LUN :7310 :HnanPJQ/ : 15728640
/dev/sdag :NETAPP :LUN :7310 :HnanPJQ/ : 20971520
/dev/sdah :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdai :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdaj :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdak :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdal :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdam :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdan :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/sdao :NETAPP :LUN :7310 :HnanPJRN : 2097152
/dev/sdap :DGC :RAID 5 :0226 :65000091 : 20971520
/dev/sdaq :DGC :RAID 5 :0226 :69000093 : 157286400
/dev/sdar :DGC :RAID 5 :0226 :68000083 : 10485760
/dev/sdas :DGC :RAID 5 :0226 :65000091 : 20971520
/dev/sdat :DGC :RAID 5 :0226 :69000093 : 157286400
/dev/sdau :DGC :RAID 5 :0226 :68000083 : 10485760
/dev/sdav :DGC :RAID 5 :0226 :65000091 : 20971520
/dev/sdaw :DGC :RAID 5 :0226 :69000093 : 157286400
/dev/sdax :DGC :RAID 5 :0226 :68000083 : 10485760
/dev/sday :DGC :RAID 5 :0226 :65000091 : 20971520
/dev/sdaz :DGC :RAID 5 :0226 :69000093 : 157286400
/dev/sdba :DGC :RAID 5 :0226 :68000083 : 10485760
/dev/dm-10 :DELL :PERC 6/i :1.21 : : 142737408
/dev/dm-11 :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/dm-12 :NETAPP :LUN :7310 :HnanPJQ/ : 15728640
/dev/dm-13 :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/dm-14 :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/dm-15 :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/dm-16 :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/dm-17 :NETAPP :LUN :7310 :HnanPJRN : 2097152
/dev/dm-18 :NETAPP :LUN :7310 :HnanPJQ/ : 20971520
/dev/dm-19 :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/dm-20 :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/dm-21 :NETAPP :LUN :7310 :HnanPJQ/ : 20971520
/dev/dm-22 :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/dm-23 :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/dm-24 :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/dm-25 :NETAPP :LUN :7310 :HnanPJRN : 2097152
/dev/dm-27 :NETAPP :LUN :7310 :HnanPJQ0 : 5242880
/dev/emcpowera :DGC :RAID 5 :0226 :65000091 : 20971520
/dev/emcpowerb :DGC :RAID 5 :0226 :69000093 : 157286400
/dev/emcpowerc :DGC :RAID 5 :0226 :68000083 : 10485760
[root@tlxkrdbrr1 ~]#
[root@tlxkrdbrr1 ~]#
[root@tlxkrdbrr1 ~]#
[root@tlxkrdbrr1 ~]#
[root@tlxkrdbrr1 ~]#
[root@tlxkrdbrr1 ~]#
[root@tlxkrdbrr1 ~]# /etc/init.d/oracleasm listdisks
ASMDISK01
ASMDISK02
[root@tlxkrdbrr1 ~]# /etc/init.d/oracleasm querydisks ASMDISK01 ASMDISK02
Usage: /etc/init.d/oracleasm {start|stop|restart|enable|disable|configure|createdisk|deletedisk|querydisk|listdisks|scandisks|status}
[root@tlxkrdbrr1 ~]# /etc/init.d/oracleasm querydisk ASMDISK01 ASMDISK02
Disk "ASMDISK01" is a valid ASM disk on device [66, 145]
Disk "ASMDISK02" is a valid ASM disk on device [66, 161]
[root@tlxkrdbrr1 ~]# cat /proc/partitions | egrep '145|161'
8 161 2095662 sdk1
65 145 5238597 sdz1
65 161 5238597 sdaa1
66 145 20971504 sdap1 <====== This is totally wrong. The ASM disk should not be individual
66 161 157284351 sdaq1 <====== disks. It should on the multipathed device
[root@tlxkrdbrr1 ~]# cat /proc/partitions | egrep -i emc
120 32 10485760 emcpowerc
120 33 3001328 emcpowerc1
120 34 3001344 emcpowerc2
120 35 4483072 emcpowerc3
120 16 157286400 emcpowerb
120 17 157284351 emcpowerb1 <===== ASMDISK02 SHOULD IDEALLY BE ON THIS
120 0 20971520 emcpowera
120 1 20971504 emcpowera1 <===== ASMDISK01 SHOULD IDEALLY BE ON THIS
[root@tlxkrdbrr1 ~]# cp /etc/sysconfig/oracleasm /etc/sysconfig/oracleasm.bk_jc_08_24
[root@tlxkrdbrr1 ~]# cat /etc/sysconfig/oracleasm
#
# This is a configuration file for automatic loading of the Oracle
# Automatic Storage Management library kernel driver. It is generated
# By running /etc/init.d/oracleasm configure. Please use that method
# to modify this file
#
# ORACLEASM_ENABELED: 'true' means to load the driver on boot.
ORACLEASM_ENABLED=true
# ORACLEASM_UID: Default user owning the /dev/oracleasm mount point.
ORACLEASM_UID=oracle
# ORACLEASM_GID: Default group owning the /dev/oracleasm mount point.
ORACLEASM_GID=oinstall
# ORACLEASM_SCANBOOT: 'true' means fix disk perms on boot
ORACLEASM_SCANBOOT=true
# ORACLEASM_CLEARBOOT: 'true' means clean old disk perms on boot
ORACLEASM_CLEARBOOT=true
# ORACLEASM_SCANORDER: Matching patterns to order disk scanning
ORACLEASM_SCANORDER=dm
# ORACLEASM_SCANEXCLUDE: Matching patterns to exclude disks from scan
ORACLEASM_SCANEXCLUDE=
[root@tlxkrdbrr1 ~]# vi /etc/sysconfig/oracleasm
[root@tlxkrdbrr1 ~]# cat /etc/sysconfig/oracleasm
#
# This is a configuration file for automatic loading of the Oracle
# Automatic Storage Management library kernel driver. It is generated
# By running /etc/init.d/oracleasm configure. Please use that method
# to modify this file
#
# ORACLEASM_ENABELED: 'true' means to load the driver on boot.
ORACLEASM_ENABLED=true
# ORACLEASM_UID: Default user owning the /dev/oracleasm mount point.
ORACLEASM_UID=oracle
# ORACLEASM_GID: Default group owning the /dev/oracleasm mount point.
ORACLEASM_GID=oinstall
# ORACLEASM_SCANBOOT: 'true' means fix disk perms on boot
ORACLEASM_SCANBOOT=true
# ORACLEASM_CLEARBOOT: 'true' means clean old disk perms on boot
ORACLEASM_CLEARBOOT=true
# ORACLEASM_SCANORDER: Matching patterns to order disk scanning
#ORACLEASM_SCANORDER=dm
ORACLEASM_SCANORDER=
# ORACLEASM_SCANEXCLUDE: Matching patterns to exclude disks from scan
ORACLEASM_SCANEXCLUDE=
[root@tlxkrdbrr1 ~]# /etc/init.d/oracleasm restart
Unmounting ASMlib driver filesystem: [ OK ]
Unloading module "oracleasm": [ OK ]
Loading module "oracleasm": [ OK ]
Mounting ASMlib driver filesystem: [ OK ]
Scanning system for ASM disks: [ OK ]
[root@tlxkrdbrr1 ~]#
[root@tlxkrdbrr1 ~]#
[root@tlxkrdbrr1 ~]# /etc/init.d/oracleasm querydisk ASMDISK01 ASMDISK02
Disk "ASMDISK01" is a valid ASM disk on device [66, 145] <===== STILL WRONG
Disk "ASMDISK02" is a valid ASM disk on device [66, 161]
[root@tlxkrdbrr1 ~]# vi /etc/sysconfig/oracleasm
[root@tlxkrdbrr1 ~]# /etc/init.d/oracleasm restart
Unmounting ASMlib driver filesystem: [ OK ]
Unloading module "oracleasm": [ OK ]
Loading module "oracleasm": [ OK ]
Mounting ASMlib driver filesystem: [ OK ]
Scanning system for ASM disks: [ OK ]
[root@tlxkrdbrr1 ~]# /etc/init.d/oracleasm querydisk ASMDISK01 ASMDISK02
Disk "ASMDISK01" is a valid ASM disk on device [120, 1]
Disk "ASMDISK02" is a valid ASM disk on device [120, 17]
[root@tlxkrdbrr1 ~]#
[root@tlxkrdbrr1 ~]#
[root@tlxkrdbrr1 ~]#
[root@tlxkrdbrr1 ~]# ############### THATABOY
[root@tlxkrdbrr1 ~]#
[root@tlxkrdbrr1 ~]#
[root@tlxkrdbrr1 ~]#
[root@tlxkrdbrr1 ~]# cat /etc/sysconfig/oracleasm
#
# This is a configuration file for automatic loading of the Oracle
# Automatic Storage Management library kernel driver. It is generated
# By running /etc/init.d/oracleasm configure. Please use that method
# to modify this file
#
# ORACLEASM_ENABELED: 'true' means to load the driver on boot.
ORACLEASM_ENABLED=true
# ORACLEASM_UID: Default user owning the /dev/oracleasm mount point.
ORACLEASM_UID=oracle
# ORACLEASM_GID: Default group owning the /dev/oracleasm mount point.
ORACLEASM_GID=oinstall
# ORACLEASM_SCANBOOT: 'true' means fix disk perms on boot
ORACLEASM_SCANBOOT=true
# ORACLEASM_CLEARBOOT: 'true' means clean old disk perms on boot
ORACLEASM_CLEARBOOT=true
# ORACLEASM_SCANORDER: Matching patterns to order disk scanning
#ORACLEASM_SCANORDER=dm
ORACLEASM_SCANORDER=emcpower
# ORACLEASM_SCANEXCLUDE: Matching patterns to exclude disks from scan
ORACLEASM_SCANEXCLUDE=
Subscribe to:
Posts (Atom)
My Blog List
-
-
Computing Oracle SQL_ID and HASH_VALUE - I needed an hash function, in Java, which is simple, practically less collision and provides a short alphanumeric or an unsigned number as hash for any str...
-
Presentation – Working with Oracle Database in VB.Net with ODP.Net and Visual API Toolkit; Enhancing Visual Manufacturing 9.0.0 - August 7, 2017 A few weeks ago I gave a presentation to a regional group of ERP users, some with an Oracle Database backend and some with a Microsoft SQL S...
-
latency heatmaps in D3 and Highcharts - See Brendan Gregg’s blog on how important and cool heatmaps can be for showing latency information and how average latency hides what is really going on: ...
-
Keeping Your AI Eye on the Right Ball - I haven’t blogged in a while, been a little busy, but today I found I was in a writing craze or maybe because Oracle announced layoffs, and Oracle is the c...
-
-
pgbouncer and slow server pool increase - This post is about an issue I ran into when trying to use pgbouncer in front of Yugabyte YSQL, the postgres layer yugabyte reuses for handling relational d...
-
Use Snowflake and Zepl to Analyse Covid-19 (coronavirus) Data - Coronavirus changed our life, most of us are stuck at home. We are trying to follow everything about the pandemic. So I wanted to write a blog post which w...
-
New Index enhancement in Oracle 12c Part 1 – Multiple indexes on the same set of columns - New Index enhancement in Oracle 12c Part 1 – Multiple indexes on the same set of columns In the article you will have a look at the following new index f...
-
Exadata X8M - World's Fastest Database Machine - Exadata X8M has launched during OOW 2019, and termed as world's fastest Database Machine. Let's walkthrough about new additions that has made X8M as world...
-
my Time/Task/Goal/Habit (TTGH) management - There was a post last night on oracle-l on the topic of task/project/time management, and I’m a big fan of productivity hacks and the whole GTD idea or met...
-
NoCOUG Conference – 2/27/2026 - Well for the first time in a very long time I am posting something on my blog. I’m doing a keynote for the Northern California Oracle Users Group (NoCOUG)....
-
Following Various Legal Action Regarding “Oracle Cloud Revenue” - As a courtesy, I would like to provide a copy of the latest legal document filed in an action being brought against Oracle leadership resulting from allege...
-
Where to find ojdbc17_g.jar - I haven’t done much JDBC tracing yet, but recently for a Kerberos KCM + ANO case I wanted more traces. In the old doc, on google and myoraclesupport, you’l...
-
Updating Exadata Database Nodes (2) - Just a small note that starting Exadata 12.2.1.1.0 dbnodeupdate.zip is no more available as a separate download. Exadata Database Node updates should be ap...
-
Creating copies of your multi-TB databases doesn’t have to take forever - Back in the day when I worked as a production DBA I vividly remember all the coordination meetings that we held to ensure that the planned clone of our pro...
-
Pluggable Database Cloning using Snapshot Copy - You need to be logged in to see this part of the content. Please Login to access.
-
OEM SSL Cipher Hardening Reset After Securing OMS - I have recently been installing Oracle Enterprise Manager at several sites, and one of the key requirements has been to ensure that the installation isn’t ...
-
-
Almost Summer Sale 2026: All my video courses discounted in May! (plus free Exadata Internals videos) - Hello everyone! *Scroll to the end to see where to find the free Exadata Internals & Advanced Performance Metrics seminar videos (4 hours) that are old, ...
-
OTW18 Sessions: Data Engineering and Latch Contentions - Thank you all those who came to my sessions at the OakTable World. Here are the presentations materials Think Data; not Database Data Engineering for Data ...
-
Oracle University Provides the Best Test Fests - Oracle University Certification Exams Are once again available at Test Fests at various events. Last year at the TECH14 and APPS14 conferences, the UK Orac...
-
Naredra Modi, Venkiah Naidu to interact with Governors on Wednesday - It would be the first meeting of this kind during the pandemic
-
Pickleball & Longevity - Studien zufolge trägt die Trendsportart Pickleball in nahezu idealer Weise zur Langlebigkeit bei! Wer möchte nicht sein Leben bei guter Gesundheit um 10 Ja...
-
Exadata Flash Cache WriteBack - With the announcement Exadata X3, Oracle has introduced a new feature called “FlashCache Writeback” to allow writes to cell Flash Cache (aka Exadata Smart ...
-
Oracle Ksplice introduces Known Exploit Detection functionality - The Oracle Ksplice team has added some really cool new functionality in Oracle Ksplice. Instead of writing and copying the blog pretty much, just go dire...
Subscribe To
Posts
All Comments
