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 himsel
Read more

Hello From Singapore….

-
Yes, I am at Singapore . Its been a while since I have come to this office where I am sitting right now, Suntec Tower 4 . The last time when I came here was in 2006. That was the first time when I came overseas for delivering a training program and this time again, the reason is same. Its so good to be back here and meet few persons whom I had met long time back and who actually taught me the few of the first lessons about the tactics of delivering a sessions. The session which I am handling right now is a VERY tough one and I am trying my best to keep things running smoothly. Hope all remains and goes fine. Its time to go for lunch. Been very long that I have seen food courts here at Suntec . Hope will find something to eat :-) .
Read more