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...
Sunday, January 22, 2012
Saturday, January 21, 2012
@sjaffarhussain, 1/21/12 6:21 AM
 Syed Jaffer Hussain (@sjaffarhussain)1/21/12 6:21 AM Another great way to obtain 10053 trace is to use 'DBMS_SQLDIAG.DUMP_TRACE' packaged procedure (11g R2 onwards) |
http://jaffardba.blogspot.com/2012/01/easy-way-to-obtain-10053-trace.html
Friday, January 20, 2012
Superb presentation on 11gR2 RAC internals
 Levi Pereira (@dba_levipereira)1/20/12 8:26 AM Watch: Part 1- Understanding Oracle RAC Internals by Markus Michalewicz wp.me/p189BW-jm via @wordpressdotcom |
Wednesday, January 18, 2012
Oracle on Kindle
http://mwidlake.wordpress.com/2012/01/18/oracle-documentation-on-a-kindle/
Martin Widlake has Kindle tips.
Martin Widlake has Kindle tips.
Performance blog-posts
K.Hailey has a terrific roundup on the internals of file I/O in a non-ASM env:
http://dboptimizer.com/2012/01/19/buffer-busy-waits-and-disk-file-operations-io/
Should catch up with these someday:
http://fritshoogland.wordpress.com/2012/01/18/using-r-and-oracle-tracefiles/
http://dboptimizer.com/2012/01/19/buffer-busy-waits-and-disk-file-operations-io/
Should catch up with these someday:
http://fritshoogland.wordpress.com/2012/01/18/using-r-and-oracle-tracefiles/
Monday, January 16, 2012
12c for production support monitoring/paging
Superb post from DBA Kevler on using 12c for production support paging design
http://dbakevlar.com/2012/01/getting-the-most-out-of-enterprise-manager-and-notifications/
http://dbakevlar.com/2012/01/getting-the-most-out-of-enterprise-manager-and-notifications/
Saturday, January 14, 2012
Perf related MOS
| Syed Jaffer Hussain (@sjaffarhussain) 1/14/12 6:09 AM Selected Performance Related Seminars from Oracle Openworld [ID 1380043.1] |
Thursday, January 12, 2012
Wednesday, January 11, 2012
AUTO DOP !
That little AUTO DOP rascal :
http://uhesse.wordpress.com/2011/10/12/auto-dop-differences-of-parallel_degree_policyautolimited/
Superb posting by Uwe Hesse - always the best !
http://uhesse.wordpress.com/2011/10/12/auto-dop-differences-of-parallel_degree_policyautolimited/
Superb posting by Uwe Hesse - always the best !
Virtualization fun stuff
Would love to lay my hands on the Solaris 11 VM & learn !
This is the Virtual Box prebuilt-page:
This is the Virtual Box prebuilt-page:
http://www.oracle.com/technetwork/community/developer-vm/index.html
Oracle VM for Oracle Virtual Box !!
http://www.oracle.com/technetwork/server-storage/vm/template-1482544.html
Should try that out one of these days.
http://www.oracle.com/technetwork/server-storage/vm/template-1482544.html
Should try that out one of these days.
On patching schedules for 11.2.0.3
Another new acronym, that will become popular: QDPE: Quarterly Database Patch for Exadata !
And another: QFSDP (Go figure !)
http://www.pythian.com/news/29911/introducing-thequarterly-database-patch-for-exadata/
A Colvin blogged about it also:
http://blog.oracle-ninja.com/2012/01/new-exadata-full-stack-patches/
THE Rene Kundersma:
http://blogs.oracle.com/XPSONHA/entry/first_quarterly_full_stack_download
And another: QFSDP (Go figure !)
http://www.pythian.com/news/29911/introducing-thequarterly-database-patch-for-exadata/
A Colvin blogged about it also:
http://blog.oracle-ninja.com/2012/01/new-exadata-full-stack-patches/
THE Rene Kundersma:
http://blogs.oracle.com/XPSONHA/entry/first_quarterly_full_stack_download
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
Tuesday, January 10, 2012
HAIP & CHM in 11.2.0.2
From Alejandra Vargas:
http://blogs.oracle.com/AlejandroVargas/entry/rac11_2_0_2_redundant
The pdf link doesn't work tho
http://blogs.oracle.com/AlejandroVargas/entry/rac11_2_0_2_redundant
The pdf link doesn't work tho
Exadata in your laptop !
Kinda trailblazer, first-of-its-kind, whatever you choose to call.
Gokhan Atil is THE MAN !
http://www.gokhanatil.com/2012/01/is-it-possible-to-build-exadata.html
DIY
Jason Arneil's blog posting is the latest knock.
http://jarneil.wordpress.com/2012/01/17/building-an-exadata-compute-node-usb-imaging-drive/
Vishal Gupta's is also helpful:
http://blog.vishalgupta.com/2011/10/23/exadata-storage-compute-node-remote-reimaging/
http://blog.vishalgupta.com/2011/10/15/oracle-exadata-documentation/
All reminds of a proverb in Tamil:
ஞாயிà®±ை கை மறைப்பாà®°் இல்
Translated, it means, you cannot cover the sun using your.hands.
THE FUTURE BECKONS - Database as a service - cookbook - DIY & test
To borrow from Nike:
JUST DO IThttp://www.oracle.com/technetwork/oem/cloud-mgmt/em12c-dbaas-cookbook-1432364.pdf#sf2898668
To install 12c, step by step, follow Gokhan Atil's guide:
http://www.gokhanatil.com/2011/10/howto-install-oracle-enterprise-manager.html
If you are totally new to 12c, here's what should bring you upto speed quickly:
Total Cloud Control. Zero to cloud in one day: http://www.oracle.com/technetwork/oem/cloud-mgmt-496758.html
Sunday, January 8, 2012
Saturday, January 7, 2012
Back blogging
Why do we blog? I mean, one can understand if you are blogging on your company site. Answer seems to me like someone might hit upon this and be benefited. Even my little daughter might chance across this blog...when she's big enough like they show in this ad for Google. But foremost, is a primordial & basic impulse of expressing oneself.
Case in hand specifically is, there's a lot good information floating around via twitter.
This could be a permanent place to collect 'em.
So, I am back blogging.
Case in hand specifically is, there's a lot good information floating around via twitter.
This could be a permanent place to collect 'em.
So, I am back blogging.
Monday, February 8, 2010
A lovely and beautiful and slow and grey day
I know time will fly. Weeks and months roll on.
"Each day just goes so fast
I turn around , it's past
...
...
A lifetime is so short
A new one can't be bought"
--- "Love you to", Beatles, The Revolver
We all wanted our workdays to be very short and weekends long.
We wanted to laze around at home and never wanted to come office.
It's strange that I want to come to my office each day and actually wish the day doesn't end so quickly.
I wish I had enjoyed my workplace more. Just 4 more days. Grey and beautiful. Hum of the datacenter seeping thru. On some brilliant days, the sunlight. Today, the greyness.
Time to go home.
But today is a beautiful long day.
"Each day just goes so fast
I turn around , it's past
...
...
A lifetime is so short
A new one can't be bought"
--- "Love you to", Beatles, The Revolver
We all wanted our workdays to be very short and weekends long.
We wanted to laze around at home and never wanted to come office.
It's strange that I want to come to my office each day and actually wish the day doesn't end so quickly.
I wish I had enjoyed my workplace more. Just 4 more days. Grey and beautiful. Hum of the datacenter seeping thru. On some brilliant days, the sunlight. Today, the greyness.
Time to go home.
But today is a beautiful long day.
Sunday, January 24, 2010
Trying out tamil fonts in blogging
Lexington - என் மகளின் சொந்த ஊர் !!!
இந்த ஊரை விட்டு செல்ல கஷ்டமாகத்தான் இருக்கிறது.
என்à®±ானுà®®் à®®ீண்டுà®®் வருவோà®®். வந்தால் Mt. Tabor park, kirklevinkle park, jacobson park - இங்கெல்லாà®®் என் பொண்ணுடன் மனைவியுடன் à®®ீண்டுà®®் walking செல்வோà®®்...
தமிà®´ில் வெளிபடுத்த செய்த google-க்கு நன்à®±ி நன்à®±ி
இந்த ஊரை விட்டு செல்ல கஷ்டமாகத்தான் இருக்கிறது.
என்à®±ானுà®®் à®®ீண்டுà®®் வருவோà®®். வந்தால் Mt. Tabor park, kirklevinkle park, jacobson park - இங்கெல்லாà®®் என் பொண்ணுடன் மனைவியுடன் à®®ீண்டுà®®் walking செல்வோà®®்...
தமிà®´ில் வெளிபடுத்த செய்த google-க்கு நன்à®±ி நன்à®±ி
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: ...
-
Career Lessons from Mentoring - Why I Move On, and Why You Might Need To I mentor between three and five individuals at any given
-
-
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...
-
Hotsos Symposium 2018 - Just a quick note to say I’m doing a couple of talks at this year’s Hotsos Symposium, which starts next Monday at 8:30AM. It’s not too late to register. ...
-
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...
-
sqlite3 - I just tried sqlite. It is ultra-light and support SQL commands. Just try this $ sqlite3 test.db SQLite version 3.26.0 2018-12-01 12:34:55 Enter ".help" fo...
-
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...
-
Identify driver details for your block devices - While preparing a presentation for POUG 2025 I had a need to find out more about the block device driver in use on my system. I was particularly interested...
-
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 ...
-
-
CatVector Demo Website - I have added a static version of my CatVector demo app for visualizing embedding vectors: tanelpoder.com/catvector/ Previously you had to clone the CatBenc...
-
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
