OraNA :: Oracle News Aggregator

A blog post is a composition in an informal verse, usually characterized by the sharing of ideas, experiences, and opinionated news. This vivid explanation of valuable ramblings about the database technologies is what makes this Log Buffer Edition again.

Oracle:

Owen Allen got a question about the Management Credentials that are used (more...)

The onslaught of the blogs is hard to ignore and underestimate. It is the blogging which has become part of the technologists everywhere including the database professionals and evangelists. This Log Buffer Edition appreciates that and consists of blogs from Oracle, SQL Server and MySQL.

Oracle:

Dass Oracle in Version (more...)

Log Buffer’s collection of blogs from across the world of various databases is all about nifty features, cool tricks, pragmatic tips, real world war stories, and much more.

Oracle:

Ops Center uses an Oracle Database to store product data. Normally you’ll use the Ops Center UI and won’t access the (more...)

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 (more...)

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 Log Buffer Editions, and this Log Buffer #294 continues it. And yes, the coolest 2012 PASS Summit is also there.

Read More.

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 Oracle with 20:20 Foresight.

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. Yury Velikanov presented on Direct NFS, (more...)

The remotest city of the world, the capital of Western Australia, Perth is once again having its premier Oracle conference.

AUSOUG and OAUG 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.

The conference theme is "Technology and Applications Conference for the Oracle User Community".

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 conference program. 

See you there in Perth on (more...)

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.

Thanks to Oracle Technology Network (OTN) and Tariq Farooq of Brain Surface for having me there.

Thanks again.

Following is the detail of the event from the FAST NU website:

Oracle Technology Network (OTN) Expert+ Conference for the Oracle Community @NUCES/FAST Lahore

Oracle Technology Network (OTN) Presents:

Attend4FREE! - 5 Hours of Expert+ Speakers & Sessions!

Oct 16, 2012 5pm - 10pm Pakistan Time

100% LIVE: Attend Physically OR Virtually - @NUCES/FAST Lahore

100% FREE - Attend virtually by clicking on the link shown below:

https://www3.gotomeeting.com/register/452999046

Presented by Oracle Technology Network (OTN), Organized by BrainSurface & hosted at the prestigious National University of Computer and Emerging Sciences (FAST-NU), this is a DO-NOT-MISS event where some of (more...)

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:

=== Session Details ===

Smooth as Silk Oracle Exadata Patching

CON6588

Conference Session

Fahd Mirza Chughtai

Thursday October 4, 2012, 11:15 – 12:15

Moscone West – Rm 3024

The more components a system has, the more challenging its maintenance becomes. Oracle Exadata marries storage with computation through a fast reliable network, and patching all of these seem daunting. (more...)

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 Insync12.

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.

I have decided (more...)

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.

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 (more...)

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 Oracle Exadata 11g Certified Implementation Specialist.

Yes quite a mouthful title, but nonetheless a good one. 

I will be writing another post as how to become an Exadata certified professional without using Exadata soon. 

Fun with knowledge is on and I will be speaking at Insync12 in Melbourne on 22nd August.  I have two sessions to deliver, both related to Exadata, a technology closer to my heart.

About Insync: 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.

Hope to see you there.

The conference program is here.

dbm_configurator.xls is needed to generate databasemachine.xml file which is needed by OEM 12c to discover an exadata cluster.

Following is a step  by step process as how to generate databasemachine.xml file to be used with OEM 12c:

1) Get the dbm_configurator70.xls file from /opt/oracle.SupportTools/onecommand directory from the first compute node of Exadata cluster.

2) Also get config.dat and dbmachine.params file from /opt/oracle.SupportTools/onecommand directory.

3) Open dbm_configurator70.xls file in Microsoft Excel and enabled the ActiveX content and Macros.

4) Make sure that all three files are in one directory and then click (more...)

Short, sweet and very useful.

Was running a shell script in Linux to execute some SQL, and got the following error during start of script:

^M: bad interpreter

Yes, received the script from the windows.

Now to rectify this, open the script file in VI editor and give following command:

:set fileformat=unix

save it with :wq

and run it again.

Should Run like a beaut.