Encounter With ORA-00600

-

In one of my last programs, we had to be face to face with ORA-00600. Well its not a nice error message to see and that too when you had least expected it.  So what happened? Well our machines were not in the network. We didn't need the network too so we didn't bother.  In one of the discussions, there was a requirement that asked for network to be up. Those were Linux machines and students didn't know how to enable network over there. Well I know a little about Linux so I did make it enable and also enabled the use of DHCP . Nothing seems to be wrong, network was up, internet also came up and Oracle was working fine. I would mention here that our /etc/hosts file was empty as the host information was not required and was picked up by DHCP. After one scenario, we needed to bounce the database. After instance startup, we were greeted with ora-00600[keltnfy-ldmInit],[46],[1]. Well ora-00600 is an internal error ( as it is told in the description also) and the time it comes, its always suggested to contact support to find the cause and remedy for it. The problem was I couldn't call support for me and the other solution was to re-install all the machines. Well I did read some where that all the codes of ora-00600 doesn't mean that oracle needs to be contacted to rectify it. So I opened that document and found that this error code that came to us is Oracle's way of saying that it couldn't find the information of the host on which it was sitting. So it stopped the mounting of the database. So the solution was that we edited the /etc/hosts file and entered the host information with host name as "local host" and the IP address that we were getting at that time. As the machines wouldn't be rebooted so it was safe to enter that value. Tried starting oracle and voila! We were back in the business!It was a good feeling to get rid of an ora-00600. But just to be clear, I am no-way-at-all an Oracle expert. Yes I learned one thing, if one knows about some thing and uses that information at the right time and place, most of the things are manageable. So at least for once, we won over ora-00600 ;-)!

Comments

Post a Comment

Popular posts from this blog

A Poetic MasterPiece By Faraz.....

-
I am a big fan of good poetry. I am not a poet myself  but where ever I do find anything good written, I try to collect and share it. Surely enough, my first preference would always be Punjabi poetry. But there is no such thing that I wont read from any where else. Whatever is good, I try to make sure that I don't miss it! There are some poets which have created history with their writings. Late Ahmed Faraz is among those handful which wrote timeless pieces from his pen. Saying anything about him would like showing torch to the sun. So without wasting any more time, I would like to share a poetic masterpiece from him which I read today only and instantly fell in love with it. This is in Hindi and I shall translate it English in a while. Please note, this does has lots of words from Urdu as well.I shall put the meanings of those words in the end of both Hindi and English versions. First, in Hindi, Dost ban kar bhi nahin saath nibhane wala, Wohi andaaz hai jaalim ka jamane...
Read more

Feelings Revealed Truly & Musically....

-
In music, out of the most pure forms of it, one is Qawalli . This is that form of music which is sung by the people who are not mere singers but devotees of God. This form of music was not a part of commercial music industry some time ago but due to its magic, its now very common to hear this in almost every where. Despite its used now in the commercial music industry, still the original form of it with minimum music instruments and claps of the singers while singing is the most popular one and remains untouchable. There are many singers who sing this form of music but some have made it a household name due to their singing. Late Nusrat Fateh Ali Khan   is among those very few who singers who are known as the masters of this devine music form. Out of millions of Qawalli songs available, there are some which hit straight in the heart. There is one that I am listening from some time and thought to share with you all. This one was specially recommended to me by my friend Sumit who hi...
Read more

Shiv Kumar Batalvi, A Legend....

-
There are so many writers in this world and there is just an ocean of literature. But despite the fact that all the writers are good and the entire literature of the world is nice, I still love Punjabi literature and its writers the most. You may call it whatever you want but this is what I really love and it has reasons. And out of all, the foremost reason is that no culture is as rich in its wealth as Punjabi culture and I have yet to read some thing which is as romantic or as painful or as joyful as Punjabi writer's writing are. There is no disrespect to anyone else or any other language but this is what my choice is! There are a lot of writers but few only have power to become immortals with their work. Only some chosen ones have a power to write fire with their words. Out of those few, Shiv Kumar Batalvi  stands apart. It wont ever happen that anyone would be able to touch even the heights where he is with his writing. Its a pity that Shiv had to leave this world so early b...
Read more