Exadata - post ACS

http://centroid.centricagency.com/knowledgebase/blog/exadata-initial-installation-validation-0

How the SPARC T4 Processor Optimizes Throughput Capacity: A Case Study

Need to try & get the brain around this someday:

https://blogs.oracle.com/ruud/entry/how_the_sparc_t4_processor

Configuring DG Broker using OEM 12c for an "existing" Data Guard setup

http://www.gokhanatil.com/2012/04/manage-your-existing-data-guards-with.html

Extending half rack Exadata to a full rack

Customer case study:

http://www.oracle.com/technetwork/database/features/availability/exadata-expansion-zero-downtime-1562570.pdf

Optimizer Statistics Whitepaper

Optimizer Statistics Whitepaper http://t.co/dtN8bcW6
by OraNA.info at 4/9/12 4:09 PM
(Source: http://twitter.com/orana/status/189444839199350784)

Sent from my iPhone

Cell version 11.2.3.1 - Db minimal pack patching gone

Updating Exadata Compute Nodes using ULN and YUM starting 11.2.3.1 http://t.co/KbJKcYAB #exadata #exalogic
by Oracle Exadata at 4/9/12 3:09 PM
(Source: http://twitter.com/oracleexadata/status/189528204984324098)

Sent from my iPhone

Couple of AWESOME metalink notes on RAC & SCAN

Handy logfile locations, comprehensive command reference (srvctl, crsctl, ocrconfig, olsnodes, cluvfy) and superb diagrams on the RAC startup sequence:


11gR2 Clusterware and Grid Home - What You Need to Know [ID 1053147.1]




SCAN concepts and demo:
11gR2 Grid Infrastructure Single Client Access Name (SCAN) Explained [ID 887522.1]


The demo link inside the SCAN metalink note doesn't work...here's the working link:
http://www.oracle.com/webfolder/technetwork/tutorials/demos/db/11g/r2/grid_rac/11_rac_scan/rac_scan_viewlet_swf.html

RAC ppt

My #OracleRAC presentation SlideShare Presentation on LinkedIn : Oracle RAC - Standard Edition, Enterprise Edition
http://t.co/pTvGuboJ
by Leighton L. Nelson at 4/7/12 8:23 PM
(Source: http://twitter.com/leight0nn/status/188784048968179712)

Sent from my iPhone

Duplicate Db

http://t.co/xF3FYjlU what happens to Read - Only tablespaces when you duplicate database, by @martinDBA

by CoskanDBA at 4/7/12 5:29 AM

(Source: http://twitter.com/coskan/status/188559017545711616)

Sent from my iPhone

Ops center

Steve Wilson (@virtualsteve) 4/6/12 3:42 PM Just posted my blog entry about launching Ops Center 12c in Tokyo. What a great trip! blogs.oracle.com/stevewilson/en…

Sent from my iPhone

ODA Advanced

Fuad Arshad (@fuadar) 4/6/12 5:22 PM Easy Made Easier - Networking blogs.oracle.com/dragonfly/entr…

Sent from my iPhone

Linux internals

Words of wisdom: Just because your Oracle database is all O_DIRECT, everything else is page cache. Learn: http://t.co/93ilVfbW

by Kevin Closson at 4/5/12 7:08 PM

(Source: http://twitter.com/kevinclosson/status/188040394771136512)

Sent from my iPhone

VM on VB

Setting up port forwarding for 7000 appliance VM in VirtualBox http://t.co/VVr2W8pr

by OraNA.info at 4/5/12 10:39 PM

(Source: http://twitter.com/orana/status/188093627724087297)

Sent from my iPhone

DG across Windows and Linux

Dan Norris (@dannorris) 4/4/12 8:54 PM @oraclenerd Also see 881421.1 for a recipe (win/linux DG setup) cc @jdanton

Sent from my iPhone

OPS CENTER and OEM 12c

A wealth of 12c Webinar replays here:
http://www.oracle.com/technetwork/oem/grid-control/webcasts-index-090211.html


Ops center information clutch here:
http://www.oracle.com/technetwork/oem/ops-center/index.html

Gokhan's step-by-step guide here:
http://www.gokhanatil.com/2011/09/how-to-install-oracle-ops-center-11g.html

@oracleace

Oracle ACE Program (@oracleace) 3/28/12 7:48 PM March @oracleace program newsletter now available online. bit.ly/Hl5tY9

Sent from my iPhone

Influencing styles

http://blogs.hbr.org/cs/2012/03/when_your_influence_is_ineffective.html?awid=5226915278051547197-3271

Sent from my iPhone

iPhone camera apps

Sadanand Dhume (@dhume01) 4/1/12 5:48 PM WSJ: Is the iPhone the only camera you need? [Yes.] online.wsj.com/article/SB1000…

Sent from my iPhone

Terrific roundup of ASM in Exadata

http://asmsupportguy.blogspot.com/2012/04/asm-in-exadata.html?m=1

Sent from my iPhone

Chinese again

OracleBlogs (@OracleBlogs) 3/31/12 4:26 AM Redundant Interconnect with Highly Available IP (HAIP) ow.ly/1isE0m

Sent from my iPhone

Again in Chinese

OracleBlogs (@OracleBlogs) 3/31/12 5:26 AM 11g Active Data Guard ow.ly/1isGHk

Sent from my iPhone

In Chinese

OracleBlogs (@OracleBlogs) 3/31/12 6:27 AM Data GuardRedo GAP ow.ly/1isJFc

Sent from my iPhone

Golden Gate - HTTPS

OraNA.info (@orana) 3/31/12 6:50 AM Configuring Oracle GoldenGate Monitor for HTTPS dlvr.it/1NVVqc

Sent from my iPhone

Big data

http://www.bizjournals.com/mobile/sanfrancisco/blog/2012/03/uc-berkeley-gets-10m-to-study-big-data.html?ana=RSS&s=article_search&utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+bizj_sanfrancisco+%28San+Francisco+Business+Times%29

Sent from my iPhone

Oem 12c

OraNA.info (@orana) 3/28/12 5:16 PM EM12c's Configuration Topology dlvr.it/1MzTtS

Sent from my iPhone

Perf tuning

OraNA.info (@orana) 3/28/12 5:51 PM Mastering Oracle Trace Data with Cary Millsap dlvr.it/1MzjwY

Sent from my iPhone

Perf tuning - V$SQLAREA

dlvr.it/1Mq1nL

Sent from my iPhone

Getting diag info for Exadata

allthingsoracle.com/method-for-hum…

Sent from my iPhone

How to move a datafile using RMAN - with some list backup commands

http://dlvr.it/1Lxpzv

ODA - Kerry's & Andy's blog

If you are looking to get familiarized with ODA, like in a couple of hours, this should be place for you to start.

http://kerryosborne.oracle-guy.com/2011/09/oracle-database-appliance/

Now, this is heavyduty:
http://blog.oracle-ninja.com/2011/09/inside-the-oracle-database-appliance-part-1/

http://blog.oracle-ninja.com/2011/12/inside-the-oracle-database-appliance-%e2%80%93-part-2/

Was it Einstein who said: “If you can't explain it simply, you don't understand it well enough”.
These guys are awesome.

Golden Gate DDL Replication

https://blogs.oracle.com/imc/entry/oracle_goldengate_configuring_ddl_replication

TEMP & UNDO usage in RAC

http://mobile.oaktable.net//node/4356
From the master
Sent from my iPhone

GNS explained - video

http://youtu.be/qqUJFNByYp0

AWR & Performance

CoskanDBA (@coskan)
2/5/12 3:41 PM

FAQ: How to Use AWR reports to Diagnose Database Performance Issues [ID 1359094.1]

RAC Networking - brilliant

OraNA.info (@orana)
2/5/12 6:23 PM

Oracle GNS and converting Grid Infrastructure from static DNS SCAN/VIP to dynamic GNS provided SCAN/VIP http://dlvr.it/19KWls

Auto BMR in standby

http://emrebaransel.blogspot.com/2012/02/automatic-block-media-recovery-on.html

Vairamuthu gem

Sundar (@sundar2005)
2/6/12 2:00 AM

RT @vairamuthu: அதிகாலை 5 மணிக்கு எழுந்து பழகுங்கள். போகப் போக வாழ்க்கையும் உடம்பும் வசப்படும்.

Migration

CoskanDBA (@coskan)
2/5/12 9:22 AM

Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backups [ID 1389592.1] this can be a game changer for migrations

Paradigm shift - DBaaS

Sudip Datta (@sudip_dat)
2/2/12 1:47 AM

Database as a Service: Transforming the role of DBAs.
http://goo.gl/FBPUc

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

ILOM upgrade

jarneil (@jarneil)
2/2/12 6:00 AM

new blog posting on updating #exadata iLOM firmware: http://jarneil.wordpress.com/2012/02/02/upgradingdowngrading-exadata-ilom-firmware/

Listener 11g RAC

http://askdba.org/weblog/2012/02/11gr2listener-startup-issues/

12c new features

OracleBlogs (@OracleBlogs)
1/31/12 9:33 PM

What's new in Oracle Enterprise Manager 12c Agents http://ow.ly/1h3J8O

RAC on Netapp

Leighton L. Nelson (@leight0nn) 1/29/12 1:37 PM Oracle Database 11g Release 2 Performance Using Data ONTAP 8.1 Operating in ClusterMode media.netapp.com/documents/tr-3961.pdf #RAC #DNFS

CISCO UCS

Leighton L. Nelson (@leight0nn) 1/29/12 10:19 PM Oracle 11gR2 DSS/DW Performance on Cisco UCS and NetApp Storage media.netapp.com/documents/tr-3926.pdf #RAC #NetApp #DNFS

Sent from my iPhone

Exadata disk layout

CoskanDBA (@coskan) 1/30/12 1:47 AM bit.ly/Ao6kT4 exadata disk layout and usable space calculations follow up post by @bryangrenn

EMGC 12c Video

Gokhan Atil (@gokhanatil) 1/30/12 3:21 AM Enterprise Manager Cloud Control 12c: Install and Integrate BI Publisher (YouTube) youtube.com/watch?v=1OSVDj… #em12c

ODA

OracleBlogs (@OracleBlogs) 1/30/12 9:37 AM Oracle Database Appliance - Partner Sales Webcast ow.ly/1h13V5

OPN EXADATA EXAM

Oracle Exadata (@oracleexadata) 1/30/12 9:56 AM OPN Certified Implementation Exams: Oracle Exadata 11g Essentials bit.ly/y43GmN #exadata #exalogic

Sent from my iPhone

Performance

CoskanDBA (@coskan) 1/28/12 4:19 PM bit.ly/zjcZ4L how can autotrace cjause problems for shared cursors by Randolf Geist

Absolute must-have bookmark: Oracle learning library

Absolute must-have bookmark: Oracle learning Library http://apex.oracle.com/pls/apex/f?p=60370:1:4190734027493864:::::

Performance - STS

OraNA.info (@orana) 1/29/12 12:20 AM How to rename SQL Tuning Set ( STS ) dlvr.it/17sSjG

OCFS - Once upon a time, super hot technology

http://blogs.oracle.com/wim/entry/the_latest_bits_around_ocfs2
Now largely forgotten, IMHO, due OCR, VD in ASM

Cluvfy healthcheck

http://martincarstenbach.wordpress.com/2012/01/28/did-you-know-the-cluvfy-healthcheck/

Useful integration of OEM & plsql

http://davidalejomarcos.wordpress.com/2012/01/29/extending-oracle-enterprise-manager-em-monitoring/?utm_source=dlvr.it&utm_medium=twitter&utm_campaign=Feed%3A+orana+%28OraNA%29

Performance - cursor sharing

My cursor wasn't shared because of STB_OBJECT_MISMATCH. What does that mean? http://ow.ly/1gVtMj

Redo sizing w/ nologging - Frm the master Riyaj

New post by rshamsud - Nologging redo size - http://tinyurl.com/7n469ob

SUSE TO. OEL

How Dell Migrated From SUSE Linux to Oracle Linux http://bit.ly/wCHOP5 > some technical details, not just a case study

If u missed today's 12c stuff

The Oracle Enterprise Management Online Forum is ended . You can watch on demand later http://bit.ly/wkhhJO #em12c

Rman BCT

From: Surachart Opun

read Oracle 10G Block Change Tracking Inside Out http://bit.ly/ys8REQ

Flashback explained

http://tinyurl.com/7xm45ht

Cool Linux

Does Your Weekend Workload Look Like This? http://ow.ly/1gVDyI

Worthy aim in life

Bill Gates (@BillGates)
1/24/12 7:32 PM

We can make the choice to help the world's poorest. http://b-gat.es/annual-letter

RAC INTERNALS VIDEO

Levi Pereira (@dba_levipereira)
1/24/12 8:51 PM

Watch: Part 2- Understanding Oracle RAC Internals by Markus Michalewicz http://wp.me/p189BW-jz via @wordpressdotcom

Nice DIY space calculation from Bryan

http://bit.ly/wPnt7E

Good Architecture pix for RAC & Exadata

http://uhesse.wordpress.com/2011/11/18/11gr2-rac-architecture-picture/


http://uhesse.wordpress.com/2011/12/02/exadata-quarter-rack-architecture-picture/

ODA VIDEO

Exa* (@ExaStar)
1/25/12 8:09 AM

Video: Introducing #Oracle #Database Appliance: A Fully Integrated System
http://www.youtube.com/watch?v=ySiXn9Db1fE

GoldenGate - 2 way replication

http://mdinh.wordpress.com/2012/01/21/my-bi-directional-replication-using-goldengate-adventure-ep1/

Rac Attack - terrific video of Riyaj explaining RAC

http://orainternals.wordpress.com/2012/01/20/video-deep-review-of-lms/

@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

Performance tuning - Superb comparison between SPM & SQL Profiles

http://intermediatesql.com/oracle/what-is-the-difference-between-sql-profile-and-spm-baseline/

LVM increase fs

http://goo.gl/fb/aWqOs

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

Brilliant new age - techie survival tips

http://dlvr.it/168FC0

Oracle on Kindle

http://mwidlake.wordpress.com/2012/01/18/oracle-documentation-on-a-kindle/

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/

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/

Physical snapshot database

http://uhesse.wordpress.com/2012/01/14/failover-to-snapshot-standby/?utm_source=twitterfeed&utm_medium=twitter

Perf related MOS

Syed Jaffer Hussain (@sjaffarhussain) 1/14/12 6:09 AM Selected Performance Related Seminars from Oracle Openworld [ID 1380043.1]

SFC Smart Flash Cache

http://www.ogh.nl//handouts.aspx#id235

Datasheet: Oracle Exadata 'expansion' rack

http://www.oracle.com/technetwork/database/exadata/exadata-storage-exp-rack-ds-v1-425092.pdf

Exadata MAAAAAAA

http://www.oracle.com/technetwork/database/features/availability/exadata-maa-131903.pdf

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 !

Performance Tuning - Tracing

http://hoopercharles.wordpress.com/2012/01/09/dumping-trace-events-what-you-see-is-not-necessarily-what-you-get/

Good discussion on Voting disk / OCR location for ASM

http://www.linkedin.com/groups/11203-RAC-voting-ocr-disk-3156190.S.87100486

https://forums.oracle.com/forums/thread.jspa?threadID=2328266&tstart=0

UEK

http://blogs.oracle.com/linux/entry/new_beta_drop_of_the

Virtualization fun stuff

Would love to lay my hands on the Solaris 11 VM & learn !
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.

Oracle Database Appliance

https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&eventid=365140&sessionid=1&key=C1E14A704BF9A7206BBE878B545040CC&partnerref=DBProd&sourcepage=register

ODA

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

Great 'POCKET REFERENCE' from Oracle

http://www.oracle.com/webapps/dialogue/ns/dlgwelcome.jsp?p_ext=Y&p_dlg_id=9575302&src=7027600&Act=54

WHAT IS BIG DATA

http://blogs.oracle.com/oracleretail/entry/what_is_big_data?utm_source=dlvr.it&utm_medium=twitter&utm_campaign=Feed%3A+orana+%28OraNA%29

http://radar.oreilly.com/2012/01/what-is-big-data.html

http://oraclestorageguy.typepad.com/oraclestorageguy/2011/05/what-is-big-data.html

Much awaited - ZERO DOWNTIME MIGRATION USING GOLDENGATE !

https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&eventid=364395&sessionid=1&key=B3A84869E9A93690E50B2E3C4F4F573A&partnerref=dbblog&sourcepage=register

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

Make Your Cubicle a Better Place to Work

http://blogs.hbr.org/cs/2012/01/how_to_make_a_bad_workspace_wo.html

10053 Trace file viewer

Should try this out

http://dboptimizer.com/2012/01/09/10053-trace-file-viewer/


DIY

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

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.

Avoiding 11.2.0.3 pitfalls w.r.t ACFS/ADVM

http://martincarstenbach.wordpress.com/2012/01/10/beware-of-acfs-when-upgrading-to-11-2-0-3/

Oracle Data Applicance - Resource Kit page

Laze around here:
http://www.oracle.com/webapps/dialogue/dlgpage.jsp?p_dlg_id=11020974&src=7299334&act=84&id1=11020975&id2=11020977&pe=null&pr=365.0&pt=N&pd=Y&xs=7299334&xa=84&pu=Null&po=WWMK11049301MP&ps=Y&p_ext=Y&p_tm=Null&r1=-1&r2=-1&r0=-1

THE FUTURE BECKONS - Database as a service - cookbook - DIY & test

To borrow from Nike:

JUST DO IT

http://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

How to create a 2nd standby db from the 1st?! - Interesting from Surachart Opun

http://surachartopun.com/2012/01/create-2nd-standby-database-from-1st.html

Oracle ASM & VOTING DISK

http://blog.oracle-ninja.com/2012/01/voting-disk-redundancy-in-asm/?utm_source=dlvr.it&utm_medium=twitter&utm_campaign=Feed%3A+orana+%28OraNA%29

Sent from my iPhone

First Video post - from iPhone

After a particularly happy day of Cricket

First post Via Blogger app for iPhone

Cows enjoying warm September sunlight

in University of Connecticut

First post from iPhone

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.

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.

Trying out tamil fonts in blogging

Lexington - என் மகளின் சொந்த ஊர்  !!!
இந்த ஊரை விட்டு செல்ல கஷ்டமாகத்தான் இருக்கிறது.

என்றானும் மீண்டும் வருவோம். வந்தால் Mt. Tabor park, kirklevinkle park, jacobson park - இங்கெல்லாம் என் பொண்ணுடன் மனைவியுடன் மீண்டும் walking செல்வோம்...

தமிழில் வெளிபடுத்த செய்த google-க்கு நன்றி நன்றி

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=