tag:blogger.com,1999:blog-34962591571301846602013-05-08T17:47:12.772-07:00I Love What I do i.e. Oracle DBAFahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.comBlogger153125tag:blogger.com,1999:blog-3496259157130184660.post-49296055481163592312013-05-08T17:47:00.000-07:002013-05-08T17:47:12.792-07:002013-05-08T17:47:12.792-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> There are certain dictionary views available to monitor the Exadata cells from the database.One of the view is gv$cell_thread_history. This view is very interesting as it delves down to the session level with its serial number, SQL, specific cell, instance and also which Exadata object was waited and every entry is logged with the time. Looks very cool:<br /> <br /> SQL&gt; desc gv$cell_thread_history<br />&nbsp;Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Null?&nbsp;&nbsp;&nbsp; Type<br />&nbsp;----------------------------------------------------- -------- ------------------------------------<br />&nbsp;INST_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;CELL_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(1024)<br />&nbsp;SNAPSHOT_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;SNAPSHOT_TIME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DATE<br />&nbsp;THREAD_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;JOB_TYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(32)<br />&nbsp;WAIT_STATE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(32)<br />&nbsp;WAIT_OBJECT_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(32)<br />&nbsp;SQL_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(13)<br />&nbsp;DATABASE_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;INSTANCE_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;SESSION_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;SESSION_SERIAL_NUM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br /> <br /> Here is a sample code snippet:<br /> <br /> SQL&gt; select wait_object_name,count(*) cnt from gv$cell_thread_history group by wait_object_name order by cnt;<br /><br />WAIT_OBJECT_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CNT<br />-------------------------------- ----------<br />UserThread Cond&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />PredicateDisk-113&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />bwresv Q_1/2k&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />bufWaitObjQ_8k&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />PredicateDiskRead IO Completion&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />bwresv Q_8k&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />FSA: cache replacementQ_1MHugePa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />CachePut Fence&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />NetworkDirectory ReqHandle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />PredicateCacheGetJob&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />Flash Cache LRU&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />FSA: Cache Get Job&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />DiskDirectory HT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />GenTimeStats Operation&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />in use Q_8k&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />Completed Map Element List&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />gdisk ext&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br />FSA: fcCtxt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8<br />FSA: cache replacementQ_8k&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8<br />FlashCache HT buckets&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8<br />PredicateDisk-110&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8<br />FC outstanding IOs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8<br />IOContext&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8<br />Cache Completed Jobs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8<br />PredicateDisk-32&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12<br />PredicateDisk-56&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12<br />PredicateDisk-50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12<br />PredicateDisk-22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12<br /></div> Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-81225281241080023312013-05-08T17:12:00.002-07:002013-05-08T17:12:16.494-07:002013-05-08T17:12:16.494-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> <div itemscope="" itemtype="http://schema.org/BlogPosting"> News and views are an integral part of our modern daily life. When it comes to the information-hungry roles such as database professionals, such need becomes more pressing. Log Buffer is one way to keep abreast of news and views from the world of Oracle, SQL Server, and MySQL.<br /> <br /> <strong>Oracle:</strong><br /> <br /> There is a significant update SLOB 2, <a href="https://kevinclosson.wordpress.com/2013/05/02/slob-2-a-significant-update-links-are-here/">Kevin Closson</a> informs.<br /> <a href="http://hoopercharles.wordpress.com/2013/05/01/grouping-data-sets-by-week-number-in-the-month/">Charles Hooper</a> is grouping Data Sets by Week Number of the Month.<br /> <a href="http://www.antognini.ch/2013/05/itl-deadlocks-script/">Chris Antognini</a> has shared a script that is used to demo ITL deadlocks.<br /> As <a href="http://richardfoote.wordpress.com/2013/05/01/storage-indexes-vs-database-indexes-iv-8-column-limit-eight-line-poem/">Exadata</a> Storage Indexes (SI) are purely memory only structures located on the Exadata storage servers, care needs to be taken in how much memory they can potentially consume.<br /> <a href="http://connormcdonald.wordpress.com/2013/04/29/its-not-about-the-outage/">Connon McDonald</a> says that its not about the outage, but….<br /> <br /> <strong>SQL Server:</strong><br /> <br /> <a href="http://sql.richarddouglas.co.uk/">Richard Douglas </a>is giving information about SQL Server events in UK.<br /> <a href="http://thomaslarock.com/">Thomas LaRock</a> has been involved in a virtualization projects for almost ten years now.<br /> <a href="http://littlekendra.com/">Kendra Little</a> has five things about Fillfactor.<br /> <a href="http://kevinekline.com/">Kevin Kline</a> suggests to use TPC database benchmarks to save money.<br /> Here’s a quick mystery. You have a <a class="broken_link" href="http://midnightdba.itbookworm.com/midnightdba/blog/">SQL Server</a> with several jobs that appear to be running properly and on schedule, but many of them show no history.<br /> <br /> <strong>MySQL:</strong><br /> <br /> How does <a href="http://blog.jcole.us/2013/05/02/how-does-innodb-behave-without-a-primary-key/">InnoDB</a> behave without a Primary Key? Jeremy Cole asks.<br /> The <a href="http://blog.mariadb.org/mariadb-java-client-1-1-2-released/">MariaDB</a> project is pleased to announce the immediate availability of the MariaDB Java Client 1.1.2.<br /> Normal 0 false <a href="http://scaledb.blogspot.com/2013/05/thoughts-on-xeround-and-free.html">false</a> false EN-US X-NONE X-NONE Everybody loves free. It is the best marketing term one could use.<br /> <a href="http://www.clusterdb.com/mysql-cluster/mysql-cluster-manager-1-2-3-released/">MySQL</a> Cluster Manager 1.2.3 is now available to download from My Oracle Support.<br /> When is a Subquery Executed?&nbsp; <a href="http://oysteing.blogspot.com/2013/05/when-is-subquery-executed.html">Øystein Grøvlen</a> writes.<br /> <br /> <b>This post appeared at <a href="http://www.pythian.com/blog/log-buffer-318-a-carnival-of-the-vanities-for-dbas/">Pythian Blog</a> initially. </b><br /> </div> </div> Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-20897440161324299472012-11-10T22:40:00.002-08:002012-11-10T22:40:29.738-08:002012-11-10T22:40:29.738-08:00<div dir="ltr" style="text-align: left;" trbidi="on"> Log writer process of Oracle is one of the most revered background process, a real work horse, a real charming darling who keeps the whole Oracle database system consistent and humming beautifully and many technologies in Oracle sprout from this good old process. Consistency is the key in database systems, and so in the <a href="http://www.pythian.com/news/about-log-buffer/">Log Buffer Editions</a>, and this <a href="http://www.pythian.com/news/37487/log-buffer-294-a-carnival-of-the-vanities-for-dbas/">Log Buffer #294</a> continues it. And yes, the coolest 2012 PASS Summit is also there.<br /> <br /> <a href="http://www.pythian.com/news/37487/log-buffer-294-a-carnival-of-the-vanities-for-dbas/">Read More. </a></div> Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-25342046904656559582012-11-01T18:22:00.001-07:002012-11-01T18:22:31.919-07:002012-11-01T18:22:31.919-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> <div class="separator" style="clear: both; text-align: center;"> <a href="http://4.bp.blogspot.com/-9WkuIhBbkGU/UJMgNWWqmlI/AAAAAAAAAGQ/DDRzEVKWJmY/s1600/IMG_1808.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="239" src="http://4.bp.blogspot.com/-9WkuIhBbkGU/UJMgNWWqmlI/AAAAAAAAAGQ/DDRzEVKWJmY/s320/IMG_1808.JPG" width="320" /></a></div> <br /></div> Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-30080697185878855142012-11-01T18:19:00.001-07:002012-11-01T18:19:38.298-07:002012-11-01T18:19:38.298-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> <div class="separator" style="clear: both; text-align: center;"> <a href="http://4.bp.blogspot.com/-ZO0hIYd18IU/UJMffZwewaI/AAAAAAAAAGI/1aJj5sjyEHU/s1600/IMG_2027%5B1%5D.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="239" src="http://4.bp.blogspot.com/-ZO0hIYd18IU/UJMffZwewaI/AAAAAAAAAGI/1aJj5sjyEHU/s320/IMG_2027%5B1%5D.JPG" width="320" /></a></div> <br /></div> Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-20783045365483219622012-11-01T18:15:00.001-07:002012-11-01T18:15:56.039-07:002012-11-01T18:15:56.039-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> Perth is far from everywhere, but not far from the Oracle technologies. Passion, knowledge, and urge to share the experience, skills, tips and knowledge brought people from across the planet to gather under one roof and learn, educate and network under the banner of <a href="http://www.ausoug.org.au/2020/">Oracle with 20:20 Foresight</a>. <br /> <br /> <a href="http://3.bp.blogspot.com/-2XKsgTRsbMM/UJMefdR8MLI/AAAAAAAAAGA/BcxyG_c5gxM/s1600/IMG_2001%5B1%5D.JPG" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="239" src="http://3.bp.blogspot.com/-2XKsgTRsbMM/UJMefdR8MLI/AAAAAAAAAGA/BcxyG_c5gxM/s320/IMG_2001%5B1%5D.JPG" width="320" /></a><span id="more-37399"></span>The event was organized by the Australian Oracle User Group with many other sponsors and exhibitors and was a explosion of innovation. Where there is Oracle on this planet, Pythian is there, rest assured. We presented three papers during this mega conference in West of Australia. <a href="http://www.pythian.com/news/author/velikanov/">Yury Velikanov </a>presented on Direct NFS, and I presented on Exadata Patching and Oracle IORM in Exadata. Pythian’s Warren Adkins was also present during the event.<br /> <br /> The sessions by <a href="http://www.pythian.com/news/37399/pythian-at-oracle-with-2020-foresight-perth-australia/tkyte.blogspot.com">Tom Kyte</a>, <a href="http://www.oaktable.net/users/melcaffrey">Malenie Caffrey</a>, <a href="http://www.google.com.au/url?sa=t&amp;rct=j&amp;q=connon%20mcdonald%20oralce&amp;source=web&amp;cd=1&amp;cad=rja&amp;ved=0CCMQFjAA&amp;url=http%3A%2F%2Fwww.oracledba.co.uk%2F&amp;ei=57-QUO_zG6qdiAenl4CQDg&amp;usg=AFQjCNHc25AWXEwYCgifEjijVDN_M5IfzQ">Connor McDonald</a>, Peter Sharman, Martin Power and Paul Geurin were few of the many great presenters. From pluggable databases to Oracle Data Archive, and from R12 migrations to Exadata, the conference had everything for everyone. It also supported the great cause of <a href="https://www.cancerwa.asn.au/">cancer council</a> in Western Australia and the passion for it was great too.</div> Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-39722845376086791122012-10-16T20:34:00.000-07:002012-10-16T20:34:10.868-07:002012-10-16T20:34:10.868-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> The remotest city of the world, the capital of Western Australia, Perth is once again having its premier Oracle conference.<br /> <br /> <a href="http://www.ausoug.org.au/2020/">AUSOUG and OAUG</a> invite you to join your colleagues from the WA Oracle community at their premier WA Oracle Conference being held at Hilton Parmelia Perth Hotel 29 - 30 October 2012.<br /> <br /> The conference theme is <i>"Technology and Applications Conference for the Oracle User Community</i>".<br /> <br /> I will be presenting there on Demystification of Oracle DBRM with IORM in Exadata and you can find my session location and time in the <a href="http://www.ausoug.org.au/2020/ConferenceProgram.htm">conference program</a>.&nbsp; <br /> <br /> See you there in Perth on Oracle with 20:20 Foresight.<br /> </div> Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-21818549299545935152012-10-16T20:29:00.003-07:002012-10-16T20:29:31.152-07:002012-10-16T20:29:31.152-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> Firstly, thanks to all of you who attended the session and then sent the questions afterwards through the email and Twitter. Also apologies for rushing the session as we were very short on time. I will be presenting this session again very soon and will update the date and venue here. I will also be uploading the slides to the site in the near future.<br /> <br /> Thanks to <a href="http://otn.oracle.com/">Oracle Technology Network (OTN)</a> and <a href="http://brainsurface.com/">Tariq Farooq</a> of Brain Surface for having me there. <br /> <br /> Thanks again.</div> Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-4865906154225481602012-10-15T23:31:00.000-07:002012-10-15T23:31:08.000-07:002012-10-15T23:31:08.000-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> Following is the detail of the event from the <a href="http://www.nu.edu.pk/NewsDetails.aspx?nid=999">FAST NU</a> website:<br /> <br /> Oracle Technology Network (OTN) Expert+ Conference for the Oracle Community @NUCES/FAST Lahore<br /><br />Oracle Technology Network (OTN) Presents:<br /><br />Attend4FREE! - 5 Hours of Expert+ Speakers &amp; Sessions!<br /><br />Oct 16, 2012 5pm - 10pm Pakistan Time<br /><br />100% LIVE: Attend Physically OR Virtually - @NUCES/FAST Lahore<br /><br />100% FREE - Attend virtually by clicking on the link shown below:<br /><br />https://www3.gotomeeting.com/register/452999046<br /><br />Presented by Oracle Technology Network (OTN), Organized by BrainSurface &amp; hosted at the prestigious National University of Computer and Emerging Sciences (FAST-NU), this is a DO-NOT-MISS event where some of the worlds best known independent Oracle experts come together physically and virtually in the first-ever independent Oracle-centric conference in Pakistan.<br /><br />Physical Venue: National University of Computer &amp; Emerging Sciences (FAST-NU) Block-B, Faisal Town, Lahore. Pakistan<br /><br />Tel: +92-42-111-128-128 </div> Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-32824732181313950702012-09-19T23:44:00.000-07:002012-09-19T23:44:00.192-07:002012-09-19T23:44:00.192-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> When Oracle opens the world, it stays opened. Like every year, the climax of all things Oracle will be showcased in the elegant and bustling American city of San Fransisco. My session on Exadata patching will be there and its details are as follows:<br /> <br /> <span style="text-align: left; width: 575px;">=== Session Details ===<br /></span><br /> <table><tbody> <tr><td><a href="https://oracleus.activeevents.com/connect/search.ww?event=openworld#loadSearch-event=openworld&amp;searchPhrase=CON6588&amp;searchType=session&amp;tc=0&amp;sortBy=&amp;p=&amp;i%2810942%29=17179&amp;i%2811425%29=&amp;i%2810053%29=10304&amp;i%2811404%29=&amp;i%2811562%29=&amp;i%2811488%29=&amp;i%2810089%29=&amp;i%2811840%29=">Smooth&nbsp;as Silk Oracle Exadata Patching</a></td> <td>CON6588</td> <td>Conference Session</td> <td><a href="http://www.pythian.com/news/author/mirza/" target="_blank">Fahd Mirza Chughtai</a></td> <td>Thursday October 4, 2012, 11:15 – 12:15</td> <td>Moscone West – Rm 3024</td> <td>The more components a system has, the more challenging its maintenance becomes. Oracle Exadata marries storage with&nbsp;computation through a fast reliable network, and patching all of these seem daunting.&nbsp;&nbsp;Many companies seem to struggle with it, with some even avoiding it altogether by keeping it&nbsp;”pending”. This presentation will give tested, applied and working tips to make the Oracle Exadata patching experience smooth as silk, like vacationing in Hawaii.</td></tr> </tbody></table> <br /> <table><tbody> <tr><td></td><td></td><td>See you there in SFO at <a href="http://www.oracle.com/openworld/index.html">OOW</a>.</td></tr> </tbody></table> </div> Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-78720689621522846072012-09-06T21:26:00.001-07:002012-09-06T21:26:31.474-07:002012-09-06T21:26:31.474-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> I was thumbing through the photos in my iPhone from my Melbourne trip of August, where I went to present two sessions on Exadata in <a href="http://fahdmirza.blogspot.com.au/2012/08/my-exadata-sessions-at-insync12.html">Insync12</a>.<br /> <br /> I spent couple of hours on first and last day in sigh-seeing or should I say my iPhone did the sight-seeing, and I nursed him. As I was going through the photos, I realized I was kind of watching those places first time. There were many things which were present in the photos, but I never saw them with my own eyes while walking or traveling in the trams or cabs.<br /> <br /> I have decided that on my next trip anywhere, I am going to put my iPhone in my pocket while watching the places. Photos are plenty out there, and if I don't have any picture with all the landmarks and monuments behind me, then its fine as nothing is going to fall apart. Next time, I am going to see it myself and enjoy them. I won't film or snapshot anything, as there are plenty of travel books online and in print which have them shoot from every angle.<br /> <br /> It's me who has spent money and time and effort, and not my iPhone. It's me who should be watching and enjoying the stuff and not my dumb iPhone. And besides, its battery is so limited and it's very awkward to handle :)<br /> <br /> Cheers.</div> Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-9201504971413272662012-08-29T17:58:00.002-07:002012-08-29T17:58:25.792-07:002012-08-29T17:58:25.792-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> When I first arrived in Australia, I was so stressed to see mega, urgent, limited supply sales at crash-door prices everywhere at Coles, Woolworths, Harvey Norman and other mega supermarkets. I wanted to go and buy all the stuff as I thought there would be no tomorrow and this is the once in a life time chance.<br /> <br /> For instance I wanted to buy hundreds of liters of milk because it was on special rate and they said that it won't last long. Now after almost an year, not only the milk stands at the same special rate as it was before, that lounge, that bed, that TV, that fridge; everything is still at special and on that same rate and even has come down.<br /> <br /> But Pythian is not some mega supermarket and we don't do it often, and in fact I have first time seen Pythian selling hardware and they are offering the Oracle Database Appliance at a throwaway price and its not that ever-continuing sale, so if you need it, you need to hurry it up.<br /> <br /> Here is what Alex says:<br /> <br /> <blockquote style="background-color: #e0e0e0; font-size: 11px;"> <i> "With Oracle Database Appliance, everything comes ready—you just drop the appliance in the data center, type in the selected IP addresses and run a single command from Oracle appliance manager. Two hours later you have a full-blown RAC cluster with a re-configured database. No network changes. No database storage setup. No server configuration. No compatibility nightmares." <br /> <div style="float: right; text-align: right;"> - Alex Gorbachev, Chief Technology Officer, Pythian</div> </i></blockquote> <br /> <br /> More detail is <a href="http://www.pythian.com/news/35463/advert-oracle-database-appliances-discount/">here</a>.</div> Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-86049752792202929112012-08-15T23:45:00.000-07:002012-08-15T23:45:18.607-07:002012-08-15T23:45:18.607-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> I have been working with Exadata systems for the last two years and have loved every moment of it. Pythian's challenging and learning environment makes it a great experience. I thought of checking my Exadata know-how by attempting the Exadata certification, and thankfully passed it and became <span class="st"><a href="http://www.oracle.com/partners/campaign/exadata-spec-criteria-043877.html">Oracle <em>Exadata</em> 11g <em>Certified</em> Implementation Specialist</a>.</span><br /> <br /> <span class="st">Yes quite a mouthful title, but nonetheless a good one.&nbsp;</span><br /> <br /> <span class="st">I will be writing another post as how to become an Exadata certified professional without using Exadata soon.&nbsp; </span></div> Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-88822996912623190342012-08-08T00:15:00.001-07:002012-08-08T00:15:26.958-07:002012-08-08T00:15:26.958-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> Fun with knowledge is on and I will be speaking at Insync12 in Melbourne on 22nd August.&nbsp; I have two sessions to deliver, both related to Exadata, a technology closer to my heart.<br /> <br /> <a href="http://www.insync12.com.au/about-insync12">About Insync</a>: The InSync12 Conference and Exhibitor Showcase is a joint event of the Quest ANZ user group – representing JDE and PeopleSoft customers, and the Australian Oracle User Group (AUSOUG) representing the Technology, Development and Applications users.<br /> <br /> Hope to see you there.<br /> <br /> The conference program is <a href="http://www.insync12.com.au/conference-program">here</a>. </div>Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-83762002481291053452012-05-16T19:36:00.001-07:002012-05-16T19:36:25.783-07:002012-05-16T19:36:25.783-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> dbm_configurator.xls is needed to generate databasemachine.xml file which is needed by OEM 12c to discover an exadata cluster.<br /><br />Following is a step&nbsp; by step process as how to generate databasemachine.xml file to be used with OEM 12c:<br /><br />1) Get the dbm_configurator70.xls file from /opt/oracle.SupportTools/onecommand directory from the first compute node of Exadata cluster.<br /><br />2) Also get config.dat and dbmachine.params file from /opt/oracle.SupportTools/onecommand directory.<br /><br />3) Open dbm_configurator70.xls file in Microsoft Excel and enabled the ActiveX content and Macros.<br /><br />4) Make sure that all three files are in one directory and then click import button in the dbm_configurator excel file.<br /><br />5) Select the dbmachine.params file and click ok, and it should populate the fields in your Excel sheet. <br /><br />6) Verify that all the values are ok and if they are not change them and then click on Generate button.<br /><br />7) This should generate a configuration on the bottom part of your Excel sheet.<br /><br />8) Review that information and if its fine, then click on Create Config Button and it should generate mutliple files in your C drive and you will get a pop up telling you location of generated files.<br /><br />9) databasemachine.xml is one of those generated files and you can use it with your OEM12c.<br /><br />HTH.<br />&nbsp;</div>Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-82559075655316223232012-04-28T00:46:00.002-07:002012-04-28T00:46:59.829-07:002012-04-28T00:46:59.829-07:00<div dir="ltr" style="text-align: left;" trbidi="on"> Short, sweet and very useful.<br /> <br /> Was running a shell script in Linux to execute some SQL, and got the following error during start of script:<br /> <br /> <pre class="default prettyprint"><code><span class="pun">^</span><span class="pln">M</span><span class="pun">:</span><span class="pln"> bad interpreter</span></code></pre> <pre class="default prettyprint"><code><span class="pln">&nbsp;</span></code></pre> <pre class="default prettyprint"><code><span class="pln">Yes, received the script from the windows.</span></code></pre> <pre class="default prettyprint"><code><span class="pln">&nbsp;</span></code></pre> <pre class="default prettyprint"><code><span class="pln">Now to rectify this, open the script file in VI editor and give following command:</span></code></pre> <pre class="default prettyprint"><code><span class="pln">&nbsp;</span></code></pre> <pre class="default prettyprint"><code><span class="pln">:set fileformat=unix</span></code></pre> <pre class="default prettyprint"><code><span class="pln">&nbsp;</span></code></pre> <pre class="default prettyprint"><code><span class="pln">save it with :wq</span></code></pre> <pre class="default prettyprint"><code><span class="pln">&nbsp;</span></code></pre> <pre class="default prettyprint"><code><span class="pln">and run it again.</span></code></pre> <pre class="default prettyprint"><code><span class="pln">&nbsp;</span></code></pre> <pre class="default prettyprint"><code><span class="pln">Should Run like a beaut. </span></code></pre> </div>Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com1tag:blogger.com,1999:blog-3496259157130184660.post-77447458239234580312012-04-16T16:51:00.000-07:002012-04-16T16:51:49.830-07:002012-04-16T16:51:49.830-07:00<div dir="ltr" style="text-align: left;" trbidi="on">While applying BP14 in half rack of Exadata V2, got following error from node 2: <br /> <br /> The opatch Component check failed. This patch is not applicable for /u01/app/oracle/product/11.2.0.2/dbhome_1<br /> <br /> The opatch Applicable check failed for /u01/app/oracle/product/11.2.0.2/dbhome_1.<br /> <br /> The patch is not applicable for /u01/app/oracle/product/11.2.0.2/dbhome_1<br /> <br /> The patch ran successfully at the node 1.<br /> <br /> After a little poking found out that the OPatch directory in the grid home had its owner set to root, while at the node 1 the owner was oracle.<br /> <br /> So I ran chown -R OPatch/ in grid home and ran the patch again, and it worked like a charm.</div>Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-23140745170686654632012-03-25T01:41:00.000-07:002012-03-25T01:41:00.180-07:002012-03-25T01:41:00.180-07:00<div dir="ltr" style="text-align: left;" trbidi="on">If you have done Exadata patching few times, you are likely to know the dreaded situation when during the patching, especially the cell nodes refuse to come back.<br /> <br /> You wait and wait, and know that all the cells have restarted successfully, except one or may be sometimes two. The patching completes and the imageinfo command shows that the Active image version has been updated at all the cells, and now only if that down cell could come up....<br /> <br /> Eventually you either restart the cell through ILOM or ask SA or you yourself hard reboot it. It comes back and you find out that the Active image version is still pointing towards the older version. You sift through logs, check the usb version and all that stuff.<br /> <br /> This situation likely happens due to the lock on udev. So its a very good idea to check for such kind of locking before cell patching with the following command:<br /> <br /> /opt/oracle.cellos/validations/init.d/checkdeveachboot<br /> <br /> If you find any locks, reboot the cell, and then proceed with the patching. If it happens during middle of patching, and you find that a cell which was brought up through hard reboot has older image version, then check for these locks and reboot the cell, and apply the patch.</div>Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-77679042961491602352012-03-09T22:13:00.000-08:002012-03-09T22:13:20.870-08:002012-03-09T22:13:20.870-08:00<div dir="ltr" style="text-align: left;" trbidi="on">From the MOS document ID 1274318.1:<br /> <br /> To verify the hardware and firmware configuration for a storage server, execute the following "cellcli" command as the "cellmonitor" userid:<br /> <br /> CellCLI&gt; alter cell validate configuration<br /> <br /> The output will be similar to:<br /> <br /> Cell RanDomcel08 successfully altered <br /> <br /> If any result other than "successfully altered" is returned, investigate and correct the condition.<br /> <br /> Ok, After a disk replacement in the cell, ran the above command on cell from cellcli, and to my horror got the following error:<br /> <br /> [WARNING] All drives are not identical<br /> [FATAL] Can not continue. See exceptions above <br /> <br /> But from SR, it was relieving to know that as the firmware of the newly replaced disk was the latest one, and it could be ignored.</div>Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com1tag:blogger.com,1999:blog-3496259157130184660.post-60255406970119703552012-02-06T16:06:00.000-08:002012-03-06T16:10:27.686-08:002012-03-06T16:10:27.686-08:00<div dir="ltr" style="text-align: left;" trbidi="on">Exachk is a fine utility to perform health check on the Exadata systems. Though its one limitation is to provide a root password for the compute nodes, cell nodes and IB switches, and obviously that is not much liked by the sysadmins.<br /> <br /> That should be changed and is likely to be changed with the next version, I guess. </div>Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-25836739098682898502012-01-26T20:10:00.000-08:002012-01-26T20:10:38.704-08:002012-01-26T20:10:38.704-08:00<div dir="ltr" style="text-align: left;" trbidi="on">To verify the database server physical drive configuration, use the following command:<br /> <br /> /opt/MegaRAID/MegaCli/MegaCli64 PDList -aALL | grep "Firmware state"<br /> <br /> The output should be similar to for the disks:<br /> <br /> Firmware state: Online, Spun Up <br /> <br /> <br /> To verify the database server virtual drive configuration, use the following command:<br /> <br /> /opt/MegaRAID/MegaCli/MegaCli64 CfgDsply -aALL | grep "Virtual Drive:";/opt/MegaRAID/MegaCli/MegaCli64 CfgDsply -aALL | grep "Number Of Drives";/opt/MegaRAID/MegaCli/MegaCli64 CfgDsply -aALL | grep "^State" <br /> <br /> The output should be similar to:<br /> <br /> Virtual Drive: 0 (Target Id: 0)<br /> Number Of Drives&nbsp;&nbsp;&nbsp; : <your drives="" number="" of=""><br /> State&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Optimal <br /> <br /> </your></div>Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-70549130098301752082012-01-23T01:02:00.000-08:002012-01-23T01:02:20.160-08:002012-01-23T01:02:20.160-08:00<div dir="ltr" style="text-align: left;" trbidi="on">During the application of BP12 on Exadata half rack V2, during the phase of application of db minimal patch, one compute node refused to get patched.<br /> <br /> As the ./install.sh script was run, it failed with :<br /> <br /> <i><b>[WARNING] This update is not applicable for Not Available.</b></i><br /> <br /> Of course it wasn't of much help, so we fished around and then found that because dmidecode command was not returning the system product name at that node, whereas the same command was working at the other nodes, where the patching was successful. <br /> <br /> [root@exanode db_minimal_patch]# dmidecode -s system-product-name<br /> Not Available<br /> <br /> This was resolved with not that much fanfare. We merely had to reset iLOM from an SSH terminal.Though it took several hours to get there. So instrumentation is the key for debugging.</div>Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-23805490166537109142012-01-13T17:47:00.000-08:002012-01-13T17:47:46.386-08:002012-01-13T17:47:46.386-08:00<div dir="ltr" style="text-align: left;" trbidi="on">What to do when you are applying PSU 11.2.0.2.4 on your Oracle 11g 11.2.0.2.0 database, and you get following error while running the opatch apply:<br /> <br /> <br /> <pre><i>Make failed to invoke "/usr/bin/make -f ins_net_client.mk</i></pre><pre><i>client_sharedlib ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1</i></pre><pre><i>"....'genclntsh: genclntsh: Could not locate&nbsp;</i></pre><pre><i>/u01/app/oracle/product/11.2.0/db_1/network/admin/shrept.lst make: *** [client_sharedlib] Error 1 ' Make failed to invoke "/usr/bin/make -f ins_rdbms.mk</i></pre><pre><i>client_sharedlib ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1</i></pre><pre><i>"....'genclntsh: genclntsh: Could not locate&nbsp;</i></pre><pre><i>/u01/app/oracle/product/11.2.0/db_1/network/admin/shrept.lst make: *** [client_sharedlib] Error 1 ' The following make actions have failed : Re-link fails on target "client_sharedlib". Re-link fails on target "client_sharedlib".</i></pre><pre>&nbsp;</pre><pre><b>Solution:</b></pre><pre></pre><pre>Just proceed with the patch installation, it is likely to get completed</pre><pre>successfully with warnings.</pre><pre></pre><pre>After that, go to $ORACLE_HOME/network/admin and see if there is a file shrept.lst?</pre><pre>If there exists a file, make sure that it's permission are set to 644.</pre><pre>If shrept.lst doesn't exist, then create a new file like this:</pre><pre></pre><pre>cd $ORACLE_HOME/network/admin</pre><pre>touch shrept.lst</pre><pre>chmod 644 shrept.lst</pre><pre></pre><pre>Then open the file shrept.lst in text editor, and paste the following lines:</pre><pre>&nbsp;</pre><pre><code class="km">network : snaumihi_inithostinfo network : snaumbg_gmt network : naedpwd_encrypt network : naumbsb_bld_singlebyte network : ztapis network : nlgh</code> </pre><pre>Save and exit the file.</pre><pre>&nbsp;</pre><pre>Now you have to run the relink all command, but before that no oracle process</pre><pre>is running out of that ORACLE_HOME:</pre><pre>&nbsp;</pre><pre>cd $ORACLE_HOME/bin</pre><pre>./relink all</pre><pre>&nbsp;</pre><pre>Now you should be good to go.</pre><pre>&nbsp;</pre><pre>Cheers.</pre><pre>&nbsp;</pre><pre>Reference: MOS Note <span style="font-family: helvetica;"><strong>ID 340978.1</strong></span> </pre></div>Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com0tag:blogger.com,1999:blog-3496259157130184660.post-69229759797323912392012-01-12T19:08:00.000-08:002012-01-12T19:08:00.445-08:002012-01-12T19:08:00.445-08:00<div dir="ltr" style="text-align: left;" trbidi="on">With the announcement of the Oracle Big Data Appliance, Oracle also comes up with some really cool technology stack which is being termed as Oracle Big Data Connectors (OBDC). This piece of software can be used with both Oracle Big Data Appliance and other Apache Hadoop-based systems.<br /> <br /> <span id="more-29975"></span>Among other things in OBDC, There is this Oracle Loader for Hadoop which uses MapReduce processing to load data efficiently into Oracle Database 11g and speeds up the loading by using the Oracle’s internal formats. This should be the big incentive and relief and a very solid business rationale for the decision makers to try out No SQL technology with their existing infrastructure.<br /> <br /> The main reason of fast adoption of Exadata (Medium data)&nbsp; in the businesses is it’s ease and speed by which it gets connected to the OLTP (Small Data). Both of them run the same Oracle 11g. Now with these connectors, its’ easy to integrate the NoSQL (Big Data) with these small and medium data sources.<br /> <br /> Integration with scalability and interoperability are the keywords here.</div>Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com1tag:blogger.com,1999:blog-3496259157130184660.post-80261145372776119842012-01-11T19:08:00.000-08:002012-01-11T19:08:37.546-08:002012-01-11T19:08:37.546-08:00<div dir="ltr" style="text-align: left;" trbidi="on">Applying PSU 11.2.0.2.4 on Oracle 11.2.0.2.0 is often a breezing experience. But sometimes you get a mild jolt kind of thing when at the last step, after a beautifully successful patching session you get following error, while trying to restart the listener:<br /> <br /> /u01/app/oracle&gt; lsnrctl start<br /> lsnrctl: symbol lookup error: lsnrctl: undefined symbol: nlgh<br /> <br /> <br /> If you panic and start getting bad impressions, you are so human.<br /> <br /> But don't worry, just relink all the binaries and try again. But before that, you must shutdown all the databases and there should be no Oracle binary running.<br /> <br /> After making sure that nothing Oracle is&nbsp; running, relink:<br /> <br /> /u01/app/oracle/product/11.2.0/db_1/bin&gt; ./relink all<br /> writing relink log to: /u01/app/oracle/product/11.2.0/db_1/install/relink.log<br /> /u01/app/oracle/product/11.2.0/db_1/bin&gt; lsnrctl start<br /> <br /> And listener should start. <br /> <br /> </div>Fahd Mirzahttp://www.blogger.com/profile/14722451950835849728noreply@blogger.com2