What you have learnt is equivalent to the amount of sand you can hold in your hand. What you haven't is everything outside - Tamil Proverb


Labels

Wednesday, May 2, 2012

ODA Basics

Active Active replication - cool

Sun ZFS Backup Appliance

Exadata ASM w/ ASMCA

Newsletter

Total Cloud Control for Systems

http://www.oracle.com/us/corporate/events/cloudcontrolforsystems/index.html


View this on-demand event to learn how to accelerate mission-critical cloud deployment, unleash the power of Oracle Solaris 11, and simplify Oracle engineered systems management with Oracle Enterprise Manager Ops Center 12c

The master's RAC docs:

Single document URL and direct access

White Paper: Best Practices for Upgrading to Oracle Database 11g Release 2

Oracle Solaris Zones Preflight System Checker

Tweet by Yury

Let me introduce Mr Neo in Oracle. @riyajshamsudeen can read strace/truss & explain U how Oracle background procs works http://t.co/jBNvkk1j

by Yury at 5/1/12 6:07 PM

(Source: http://twitter.com/yvelikanov/status/197447121731985409)


Sent from my iPhone

Monday, April 30, 2012

Tweet by Marcin Przepiorowski

Just blogged how Oracle is detecting storage type to enable HCC on non-Exadata hosts - http://t.co/cCxLqfsl .

by Marcin Przepiorowski at 4/27/12 1:46 PM

(Source: http://twitter.com/pioro/status/196669066147135489)


Sent from my iPhone

Tweet by OraNA.info

Google Drive: Installing the windows client (filesystem plugin) http://t.co/RquTxQIK

by OraNA.info at 4/29/12 3:09 PM

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


Sent from my iPhone

Tweet by OracleBlogs

Distributed transaction on Oracle Real Application Cluster database http://t.co/Tgy4YjMR

by OracleBlogs at 4/29/12 5:26 PM

(Source: http://twitter.com/OracleBlogs/status/196712193981562881)


Sent from my iPhone

OracleBlogs Chinese

11g R2 RAC Expert http://t.co/2rF4EyM7

by OracleBlogs at 4/29/12 6:28 PM

(Source: http://twitter.com/OracleBlogs/status/196727640688832514)


Sent from my iPhone

Tweet by Oracle Magazine

Oracle Magazine for iPhone http://t.co/M4Flkg0O

by Oracle Magazine at 4/29/12 6:22 PM

(Source: http://twitter.com/oraclemagazine/status/196729733818486784)


Sent from my iPhone

Tweet by Yury

I heard this pres from @fuadar @ #C12LV. If U R serious about #RAC I recommend 2 check the slides published here http://t.co/kav6nsLH

by Yury at 4/29/12 8:05 PM

(Source: http://twitter.com/yvelikanov/status/196752017237094400)


Sent from my iPhone

Tweet by Fuad Arshad

#ODA Patch 2.2.0. Now Available http://t.co/jmXFtLsG #rac #oracle

by Fuad Arshad at 4/29/12 8:11 PM

(Source: http://twitter.com/fuadar/status/196753627006767104)


Sent from my iPhone

Tweet by Oracle Middleware

RT @oraclewebcenter: #DALLAS,TX May 3 FREE #AIIM #ContentManagement Boot Camp SIGN UP TODAY! #WebCenter http://t.co/hG1P7sem

by Oracle Middleware at 4/29/12 5:45 PM

(Source: http://twitter.com/OracleMiddle/status/196769510953459712)


Sent from my iPhone

Tweet by Fuad Arshad

blog post MIgrating from Single Instance to RAC and Upgrading using Data guard: As Promised Embedded below is m... http://t.co/6BYWHocU

by Fuad Arshad at 4/29/12 9:27 PM

(Source: http://twitter.com/fuadar/status/196772680345714688)


Sent from my iPhone

Tweet by Fuad Arshad

blog post ODA Patch 2.2.0. Now Available: The First Oracle Database Appliance Significant version patch is now a... http://t.co/Jy6HFAdY

by Fuad Arshad at 4/29/12 9:27 PM

(Source: http://twitter.com/fuadar/status/196772681801146368)


Sent from my iPhone

Tweet by OraNA.info

MIgrating from Single Instance to RAC and Upgrading using Data guard http://t.co/yan9PDQf

by OraNA.info at 4/29/12 9:50 PM

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


Sent from my iPhone

Tweet by Leighton L. Nelson

Playing with Hybrid Columnar Compression on #VirtualBox with Oracle's Sun ZFS Storage 7000 Simulator. Watch this demo
http://t.co/27yiCNSm

by Leighton L. Nelson at 4/29/12 11:02 PM

(Source: http://twitter.com/leight0nn/status/196796733529923584)


Sent from my iPhone

Tweet by CoskanDBA

http://t.co/o6UWjdGI how to read strace and sql trace output together by @fritshoogland

by CoskanDBA at 4/30/12 3:08 AM

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


Sent from my iPhone

Tweet by Syed Jaffer Hussain

OS Watcher Black Box User Guide [ID 301137.1]

by Syed Jaffer Hussain at 4/30/12 3:41 AM

(Source: http://twitter.com/sjaffarhussain/status/196866951610511361)


Sent from my iPhone

Tweet by Syed Jaffer Hussain

OSWatcher Black Box Analyzer (OSWbba) is a graphing & analysis utility which comes bundled with OSWbb v4.0.0 and higher. View 461053.1.

by Syed Jaffer Hussain at 4/30/12 3:47 AM

(Source: http://twitter.com/sjaffarhussain/status/196868442471665664)


Sent from my iPhone

Tweet by Uwe Hesse

Do you use RACcheck? A must when you are responsible for #Oracle #RAC administration. See MOS 1268927.1 Download, User Guide & Viewlet

by Uwe Hesse at 4/30/12 3:43 AM

(Source: http://twitter.com/UweHesse/status/196874600473313280)


Sent from my iPhone

Tweet by CoskanDBA

http://t.co/gGy0TBOI how does oracle optimize block transfer to reduce private network traffic on RAC by @riyajshamsudeen

by CoskanDBA at 4/30/12 3:14 AM

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


Sent from my iPhone

Tweet by OracleBlogs

Upcoming Exadata Technical Live Virtual Bootcamps: May 16-19th http://t.co/UGj5koRJ

by OracleBlogs at 4/30/12 6:30 AM

(Source: http://twitter.com/OracleBlogs/status/196909300151619584)


Sent from my iPhone

Sunday, April 29, 2012

Tweet by oaktable network

New post by rshamsud - _gc_fusion_compression - http://t.co/PyDRVuZE

by oaktable network at 4/28/12 11:00 PM

(Source: http://twitter.com/oakies_blog/status/196433756096176128)


Sent from my iPhone

Tweet by CoskanDBA

Hugepages are Not used by Database Buffer Cache [ID 829850.1]

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

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


Sent from my iPhone

Saturday, April 28, 2012

Tweet by Carlos Sierra

Free Webinar: Using SQLTXPLAIN to diagnose SQL statements performing poorly http://t.co/6xgxZUwm via @wordpressdotcom

by Carlos Sierra at 4/28/12 7:26 AM

(Source: http://twitter.com/csierra_usa/status/196260266625871872)


Sent from my iPhone

Tweet by Dominic Delmolino

What Valve Looks for When it Hires http://t.co/9xNuOonx

by Dominic Delmolino at 4/28/12 7:17 AM

(Source: http://twitter.com/ddelmoli/status/196285368969068546)


Sent from my iPhone

Tweet by OraNA.info

IOPS, capacity, bandwidth - and something new to explain to the people in purchasing http://t.co/AL8UdCxA

by OraNA.info at 4/28/12 6:35 PM

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


Sent from my iPhone

Tweet by Oracle Linux

@yvelikanov @pythianfielding Oracle VM Server for x86 may be used as hard partitioning technology:
http://t.co/MtQoJVJ8

by Oracle Linux at 4/28/12 8:42 PM

(Source: http://twitter.com/ORCL_Linux/status/196399045877567488)


Sent from my iPhone

Tweet by oaktable network

New post by rshamsud - _gc_fusion_compression - http://t.co/PyDRVuZE

by oaktable network at 4/28/12 11:00 PM

(Source: http://twitter.com/oakies_blog/status/196433756096176128)


Sent from my iPhone

Tweet by Gokhan Atil

New blog post of @pioro: HCC on non-Exadata - How Oracle is detecting storage type http://t.co/S90q3fp6

by Gokhan Atil at 4/27/12 4:39 PM

(Source: http://twitter.com/gokhanatil/status/195975452840562689)


Sent from my iPhone

Tweet by Leighton L. Nelson

An extended version of my presentation at Collaborate 12 - Looking at RAC, GI/Clusterware Diagnostic Tools #C12LV #Ora…http://t.co/OBMBoLan

by Leighton L. Nelson at 4/27/12 1:23 PM

(Source: http://twitter.com/leight0nn/status/195926047382978560)


Sent from my iPhone

Tweet by OracleBlogs

Solaris Volume Manager (SVM) on Solaris 11 http://t.co/8rrd5ccr

by OracleBlogs at 4/28/12 3:26 AM

(Source: http://twitter.com/OracleBlogs/status/196138243983540225)


Sent from my iPhone

Tweet by Frits Hoogland

Reading http://t.co/D1YAyWHm about Linux 2.6 IO. Must read for performance analysts!

by Frits Hoogland at 4/28/12 5:04 AM

(Source: http://twitter.com/fritshoogland/status/196162874492731394)


Sent from my iPhone

Tweet by OraNA.info

Free Webinar: Using SQLTXPLAIN to diagnose SQL statements performing poorly http://t.co/cl7ArqRS

by OraNA.info at 4/28/12 7:43 AM

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


Sent from my iPhone

Friday, April 27, 2012

Tweet by e-DBA

Have you seen our ODA video on youtube? take a look here http://t.co/NocNv48H @UKOUG @Oracle @Avnet_TS_UK @OracleFS #OracleDBappliance

by e-DBA at 4/26/12 7:34 AM

(Source: http://twitter.com/e_DBA/status/195511553917849600)


Sent from my iPhone

Tweet by Cloud Slam®

#CloudSlam'12 Session: Gain Total Cloud Control - http://t.co/bjwYj7Xu, by Anand Akela, Sr Director @Oracle #em12c #CloudComputing @aakela

by Cloud Slam® at 4/26/12 3:49 PM

(Source: http://twitter.com/CloudSlam/status/195602361236979712)


Sent from my iPhone

Tweet by Oracle ACE Program

Great article on Virtualization written by Justin Kestelyn (@oracletechnet ) in May/June issue of @oraclemagazine. http://t.co/Khi3Iep9

by Oracle ACE Program at 4/26/12 12:49 PM

(Source: http://twitter.com/oracleace/status/195614175844761600)


Sent from my iPhone

Tweet by Oracle ACE Program

@oracleace program newsletter April edition now available online. http://t.co/ExzvNKNc http://t.co/6louptuw

by Oracle ACE Program at 4/26/12 2:24 PM

(Source: http://twitter.com/oracleace/status/195614738330300417)


Sent from my iPhone

Tweet by Andy Colvin

Using 11.2.0.1 GI with #Exadata 11.2.3.1.0 and no BP12+ keeps CRS from starting. See MOS note 1429907.1 - don't run 11.2.0.1 with 11.2.2.4+

by Andy Colvin at 4/26/12 5:02 PM

(Source: http://twitter.com/acolvin/status/195618778548150272)


Sent from my iPhone

By Sandesh Rao

Oracle RMAN straps on rocket, hands admins launch button http://t.co/QugGFfTs

by Sandesh Rao at 4/26/12 5:26 PM

(Source: http://twitter.com/sandeshr/status/195624913460133888)


Sent from my iPhone

Scan by Yury

Just uploaded my #c12lv SCAN presentation http://t.co/X9VxXdMx slidesdesk http://t.co/8jm1MYyd Thanks to all 35 folks who came.

by Yury at 4/26/12 7:00 PM

(Source: http://twitter.com/yvelikanov/status/195648532152197120)


Sent from my iPhone

Virtual ops center

Scott Elvington blogs about Building a Virtual Data Center w/ Oracle Enterprise Manager Ops Center 12c http://t.co/IM9hbur2 #em12c

by OracleEnterpriseMgr at 4/26/12 7:03 PM

(Source: http://twitter.com/oracle_em/status/195649271855452161)


Sent from my iPhone

by Sushil Kumar

Detailed insight into how to create x86 and SPARC based IaaS cloud using #em12c https://t.co/AbvULfO7 #in #cloud

by Sushil Kumar at 4/26/12 9:07 PM

(Source: http://twitter.com/sxkumar/status/195723313182543875)


Sent from my iPhone

by Mercedes Biondi

Oracle Enterprise Manager 12c Cloud Control - New Features Part One http://t.co/0t7kJ2S3

by Mercedes Biondi at 4/26/12 10:42 PM

(Source: http://twitter.com/gleanmercebion/status/195724467379519489)


Sent from my iPhone

By Anand Prakash

SGA Re-Sizes Occurring Despite AMM/ASMM Being Disabled – Oracle 11.2 -- http://t.co/rlL9E2QZ

by Anand Prakash at 4/27/12 4:11 AM

(Source: http://twitter.com/anandprakash86/status/195787119644516352)


Sent from my iPhone

By CoskanDBA

Exadata smartscan is not being used on insert as select [id 1348116.1] after 11.2.2.2.0 cell release

by CoskanDBA at 4/27/12 6:22 AM

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


Sent from my iPhone

Thursday, April 26, 2012

Pres by Yury

Published my slides for "10 Problems with your RMAN backup script" session http://t.co/eXmpQODF. Conf details - http://t.co/o7IvJVT8

by Yury at 4/25/12 8:52 PM

(Source: http://twitter.com/yvelikanov/status/195321675334696962)


Sent from my iPhone

Pres by Arup Nanda

My session Beginning Performance Tuning at #C12LV download slides: http://t.co/FgsFxlEG and scripts: http://t.co/OY2ZPFJG

by Arup Nanda at 4/25/12 9:19 PM

(Source: http://twitter.com/arupnanda/status/195321859305246720)


Sent from my iPhone

Virtual box tip

Hostname OEL http://t.co/Y49JK0j9

by OracleBlogs at 4/26/12 4:29 AM

(Source: http://twitter.com/OracleBlogs/status/195429430691241984)


Sent from my iPhone

Wednesday, April 25, 2012

UCS TPC

@leight0nn Just remembered our discussion about # of luns. Have a look at this: http://t.co/LFTH004e #lotsOfLUNs

by Martin Bach at 4/24/12 12:11 PM

(Source: http://twitter.com/MartinDBA/status/194820927740051458)


Sent from my iPhone

Million dollar q

An excellent blog post by Julian Dontcheff: On DBA innovation: who is afraid to fail will keep falling forever http://t.co/Y9bNAcDk #em12c

by Gokhan Atil at 4/24/12 1:42 PM

(Source: http://twitter.com/gokhanatil/status/194843758280454144)


Sent from my iPhone

ODA Tip

Paul Tsien: ODA 2.3 comes out in July with support for multiple ORACLE_HOMEs #c12lv

by Marc Fielding at 4/24/12 2:31 PM

(Source: http://twitter.com/pythianfielding/status/194856396796329984)


Sent from my iPhone

ODA Tip

@fuadar you can do ODA 2.2 with an existing 11.2.0.2 database; you just can't run both 11.2.0.2 and 11.2.0.3 before ODA 2.3 comes out

by Marc Fielding at 4/24/12 3:29 PM

(Source: http://twitter.com/pythianfielding/status/194870729580363776)


Sent from my iPhone

Demo on 12c !

#Oracle EM 12c Demo Series — Explore Oracle Enterprise Manager Ops Center 12c: http://t.co/lskd63Vv @oracle_em

by Michelle Agul at 4/24/12 6:17 PM

(Source: http://twitter.com/michelleAgul/status/194924674218606593)


Sent from my iPhone

Need to explore the Exadata VM from Oracle

Exadata presentation http://t.co/Adt5U42P

by OraNA.info at 4/24/12 8:30 PM

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


Sent from my iPhone

The next leap

Oracle Solaris 11 Upgrade to Oracle Solaris 11 System Administrator http://t.co/65icZQpM

by OracleBlogs at 4/24/12 11:27 PM

(Source: http://twitter.com/OracleBlogs/status/194990937242468352)


Sent from my iPhone

Truth be told

Stress Is Not Your Enemy http://t.co/ZXaWeoK0

by Harvard Biz Review at 4/25/12 12:00 AM

(Source: http://twitter.com/HarvardBiz/status/194999387368337410)


Sent from my iPhone

11g OEM Tip

Removing targets from Grid Control – Oracle 11g http://t.co/wybfER70

by OraNA.info at 4/25/12 3:17 AM

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


Sent from my iPhone

12c webinar - hope replay is there

Pankaj Chandiramani: Webcast :Unleash the Power of Oracle Enterprise Manager to Build Private Clouds: There is a... http://t.co/ayfrAsPh

by Oracle FAQ at 4/25/12 3:32 AM

(Source: http://twitter.com/orafaq/status/195052582543179777)


Sent from my iPhone

Tuesday, April 24, 2012

Hugepages

http://t.co/DZ9PTRAS huge pages and side effects of not having them configured by @pioro

by CoskanDBA at 4/23/12 4:35 AM

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


Sent from my iPhone

By Gokhan Atil

New blog post of Bobby Durrett: Resource Manager wait events http://t.co/P5icxruG #oracle

by Gokhan Atil at 4/23/12 5:19 AM

(Source: http://twitter.com/gokhanatil/status/194354905870376960)


Sent from my iPhone

By Owen Hughes and team

Wanna play with an #Oracle #SPARC #SuperCluster? Check out the live, interactive 3D demo: http://t.co/qiHIv8CO

by Owen Hughes and team at 4/23/12 5:57 AM

(Source: http://twitter.com/ora_eng_systems/status/194364376688508928)


Sent from my iPhone

Tweet by Syed Jaffer Hussain

#AIOUG Sangam12 Call for papers is now open http://t.co/bH8iwtBU -> Events -> Sangam12 - Call for Papers

by Syed Jaffer Hussain at 4/23/12 12:46 PM

(Source: http://twitter.com/sjaffarhussain/status/194467377621123073)


Sent from my iPhone

ODA

ODA patch 2.2.0 is now available upgrade to Uek and 11.2.0.3 included https://t.co/vdVT7Jqt

by Fuad Arshad at 4/23/12 2:39 PM

(Source: http://twitter.com/fuadar/status/194497840934952961)


Sent from my iPhone

By Karl Arao - Exadata data sheets

#Exadata Data Sheets (v1,v2,x2-2,x2-8) http://t.co/w33cSUOe

by Karl Arao at 4/23/12 3:09 PM

(Source: http://twitter.com/karlarao/status/194503172881002496)


Sent from my iPhone

ODA

What Does Your Oracle Database Appliance Look Like? http://t.co/nHVemTaO

by OracleBlogs at 4/23/12 4:31 PM

(Source: http://twitter.com/OracleBlogs/status/194523975571873792)


Sent from my iPhone

Tweet by Yury

#C12RAC SIG @kutrovsky ASMLib & direct accessed devices have have the same headers. You can flip disks in between #idontkonwit #goodlearing

by Yury at 4/23/12 4:31 PM

(Source: http://twitter.com/yvelikanov/status/194524003992485888)


Sent from my iPhone

by Angie Barba

http://t.co/yb34HscQ Oracle Enterprise Manager 12c Cloud Control - New Features Part One - Database Journal

by Angie Barba at 4/23/12 10:26 PM

(Source: http://twitter.com/DedicatedSeEbri/status/194645441470660608)


Sent from my iPhone

Lucid Linux Load Avg

New blog post of Harald van Breederode: Understanding Linux Load Average – Part 1 http://t.co/Z2annHt3

by Gokhan Atil at 4/24/12 2:18 AM

(Source: http://twitter.com/gokhanatil/status/194671693229326336)


Sent from my iPhone

Good overview of the MACHINES

Re-uploaded pres slides for my Rise of the Machine session at #C12LV. Sorry; the old version had errors on the page. http://t.co/fsXopwv9

by Arup Nanda at 4/24/12 2:34 AM

(Source: http://twitter.com/arupnanda/status/194675650756485121)


Sent from my iPhone

Good Greek - for future ref

@kevinclosson thank you for http://t.co/HNp4URHL - it saved me several hours of investigation

by Martin Berger at 4/24/12 3:33 AM

(Source: http://twitter.com/martinberx/status/194690614183464960)


Sent from my iPhone

ASM TIP

ORA-15027: active use of diskgroup "DATA" precludes its dismount http://t.co/JUSB5OJR

by Anand Prakash at 4/24/12 3:41 AM

(Source: http://twitter.com/anandprakash86/status/194692506095587330)


Sent from my iPhone

Arup Nanda article

#SELECT Journal of #IOUG has made my article that won the Editor's Choice award freely available http://t.co/us1KYxME

by Arup Nanda at 4/24/12 3:11 AM

(Source: http://twitter.com/arupnanda/status/194698817826861056)


Sent from my iPhone

Sunday, April 22, 2012

by Tanel Poder

Just wrote a short blog entry: Where is LOB data stored http://t.co/fFu5VWRZ

by Tanel Poder at 4/22/12 11:30 AM

(Source: http://twitter.com/TanelPoder/status/194085695130845184)


Sent from my iPhone

Temp

c.hooper blog - Temporary Tablespace Storage Parameters – What is Wrong with this Quote http://t.co/Fd0tW8oL

by Jos van den Oord at 4/22/12 11:57 AM

(Source: http://twitter.com/joord01/status/194092577681702912)


Sent from my iPhone

Alex G slides- good discussion on ASM FGs

http://www.pythian.com/news/wp-content/uploads/IOUG12-HADB-public.pdf

(Source: http://twitter.com/alexgorbachev/status/194212226561880064)


Sent from my iPhone

Cool PDF from Arup...well deserved

Congratulations to @arupnanda, winner of the award for the best #IOUG article "Cache Fusion Demystified" http://t.co/RR4srMar #c12lv

by Marc Fielding at 4/22/12 11:30 PM

(Source: http://twitter.com/pythianfielding/status/194267077169782784)


Sent from my iPhone

RAC Internal by the master

gc buffer busy acquire vs release http://t.co/Z0a9PKWJ by @riyajshamsudeen

by Anand Prakash at 4/20/12 3:00 AM

(Source: http://twitter.com/anandprakash86/status/193232585021865984)


Sent from my iPhone

James Morle on ASM device naming

New Blog post:
Udev Rules OK: How to manage ASM device naming in RHEL/OL6

http://t.co/lZqAhOVU

by James Morle at 4/20/12 8:02 AM

(Source: http://twitter.com/JamesMorle/status/193308699484360705)


Sent from my iPhone

Marcin Przepiorowski on Hugepages

I have updated my post about HugePages - http://t.co/JZNsqa7c - @yvelikanov thanks for morning conversation

by Marcin Przepiorowski at 4/20/12 1:56 PM

(Source: http://twitter.com/pioro/status/193397736308092929)


Sent from my iPhone

Cool editing tips

I sed awk! http://t.co/QekFCepC

by OraNA.info at 4/20/12 3:44 PM

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


Sent from my iPhone

Saturday, April 21, 2012

Syed Jaffer Hussain's recording of single instance to RAC

My webinar about 'Migrating Oracle single instance to RAC', recorded... http://t.co/rqB2JSQM

by Syed Jaffer Hussain at 4/21/12 7:14 AM

(Source: http://twitter.com/sjaffarhussain/status/193658984706736129)


Sent from my iPhone

Jos van den Oord on OLR

Joords Oracle DBA blog: 11gR2 Clusterware :Oracle Local Registry (OLR): http://t.co/t2JA6fT0. What to do as OLR corrupt is.

by Jos van den Oord at 4/21/12 9:41 AM

(Source: http://twitter.com/joord01/status/193695938555019264)


Sent from my iPhone

Lucid explanation of RAC Server Pools

An Introduction to 11.2 RAC Server Pools - by @amansharma81 http://t.co/bVTwmPYR

by Anand Prakash at 4/19/12 2:50 PM

(Source: http://twitter.com/anandprakash86/status/193713052657516544)


Sent from my iPhone

Chargeback in 12c

New Whitepaper : Oracle Enterprise Manager 12c - Most Comprehensive Metering & Chargeback capabilities for Cloud http://t.co/vKvSwBPr #em12c

by OracleEnterpriseMgr at 4/11/12 11:00 AM

(Source: http://twitter.com/oracle_em/status/190091926450618368)


Sent from my iPhone

As always, typical Arup- Flashback technology

OraNA.info (@orana)
4/21/12 5:12 PM
Data migration testing - Oracle Flashback Database makes life easier dlvr.it/1Sps71


Sent from my iPhone

@tagoreghanta, 4/5/12 1:23 AM

RAMA TAGORE (@tagoreghanta)
4/5/12 1:23 AM
TRUE>> Speed:Source of stimulation & fleeting pleasure. Slowing down: route 2 depth, enduring satisfaction & 2 excelnc s.hbr.org/HWakhN


Sent from my iPhone

Friday, April 13, 2012

Sqlplus settings

Just noticed Randolf Geist also uses (at least) login.sql script from TPT by @TanelPoder It's awesome, BTW: http://t.co/3WlgQQMN

by Timur Akhmadeev at 4/11/12 11:53 AM

(Source: http://twitter.com/timurakhmadeev/status/190105386878115841)


Sent from my iPhone

Thursday, April 12, 2012

Oracle internals by Tanel

RT @TanelPoder Another Oracle internals hacking session with me - tomorrow! :) Register here -> http://t.co/wYNlh4nI

by Marcin Przepiorowski at 4/11/12 4:43 PM

(Source: http://twitter.com/pioro/status/190178285731332098)


Sent from my iPhone

Tuesday, April 10, 2012

Exadata - post ACS

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

Extending half rack Exadata to a full rack

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

Monday, April 9, 2012

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


Sunday, April 8, 2012

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

Saturday, April 7, 2012

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

Friday, April 6, 2012

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

Thursday, April 5, 2012

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

Sunday, April 1, 2012

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

Saturday, March 31, 2012

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

Wednesday, March 28, 2012

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



Sent from my iPhone

Getting diag info for Exadata



Sent from my iPhone

Tuesday, March 20, 2012

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.

Monday, February 13, 2012

Wednesday, February 8, 2012

GNS explained - video

http://youtu.be/qqUJFNByYp0


Monday, February 6, 2012

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

Vairamuthu gem

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

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


Sunday, February 5, 2012

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


Saturday, February 4, 2012

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

Tuesday, January 31, 2012

12c new features

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

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


Monday, January 30, 2012

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

Wednesday, January 25, 2012

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

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

Good Architecture pix for RAC & Exadata

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


Saturday, January 21, 2012

Friday, January 20, 2012

Monday, January 16, 2012

Saturday, January 14, 2012

Wednesday, January 11, 2012

Datasheet: Oracle Exadata 'expansion' rack

Exadata MAAAAAAA

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

Good discussion on Voting disk / OCR location for ASM

UEK

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

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

WHAT IS BIG DATA

Much awaited - ZERO DOWNTIME MIGRATION USING GOLDENGATE !

On Voting Disk & node eviction logic

Make Your Cubicle a Better Place to Work

Tuesday, January 10, 2012

10053 Trace file viewer

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

Oracle Data Applicance - Resource Kit page

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

Saturday, January 7, 2012

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.

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.

Sunday, January 24, 2010

Trying out tamil fonts in blogging

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

என்à®±ானுà®®் à®®ீண்டுà®®் வருவோà®®். வந்தால் 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=

My Blog List

Blog Archive

Total Pageviews


Custom Search