Hey DBA-Mates, hope you all are doing well!!!
Oracle DBA troubleshooting is very important and advance for DBA’s life. We all should know and understand the troubleshooting ways. Here we have some points and the ways which can be helpful in troubleshooting.
One thing I would like to share here that troubleshooting
is not a rocket science but people make it like a rocket science
hehehh. Even if rocket science also we can do it friends.
Friends, please just try once and follows
these below points. I am sure it will be very
useful. There are many more points technical but I tried to explain in very
simple ways to kick start.
As per my experiences I have seen some
people feel as troubleshooting is either hard or they afraid.
WHY TROUBLESHOOTING IS HARD:
1. You feel as you can’t do it even without any try. Already they have mindset.
2. You think it will take time but it takes time for everyone.
You know one SECRET, no one know everything, even seniors
also check in metalink or google. Only
one thing is different i.e. Observations as per experiences. Otherwise everything
is same. Whatever we/they do, you can also do.
3. You afraid
about mistakes but we need to try on test server which everyone does it.
Never give up. Today if you try for 1
hr and got solution, tomorrow you will be king of it. If you do not get
solution in 1 hr, take it as challenge and try till get the solution. Every one
learns like this only.
Simple Steps to START TROUBLESHOOTING:
1. You must Read error carefully.
2. Must check alert logs accordingly.
3. Check for related error either in Metalink
or Google.
4. Understand or observe the error 100%. Do
not be hurry in investigations.
After checking Metalink or Google, never do
hurry to execute solution. First understand the solution 100% thoroughly. Check
what is required in the given solution.
Some Important Suggestions:
For Example: Suppose, there is given
any “rm” command in solution. As per my DBA
experiences never ever use “rm or rm –rf” command. If required check 7 times before using this command.
Actually I forget this command; I don’t
know “rm or rm-rf” command hehehh.
If it is very necessary, then take the backup
of file and then remove.
Before executing solution check for any SQL DDL command or any other SQL SCRIPTS statements which can impact like
DDL or any Transactional etc…
And if you are not sure then check on test
servers and check with your seniors.
I guarantee that just follow these simple
above steps. You will see yourself changes. If any more suggestions, I will
keep update here.
And also if you have any more points please
let us know which will be helpful for all of us.
Some more useful links:
Regards,
Good and Interesting... Thanks for sharing your ideas and valuable time...
ReplyDeleteOracle Training
DeleteHi Venkat,
Thank you.
Regards,
ora-data Team.
What i do not realize is in reality how you are no longer actually much more well-favored than you may be now.
ReplyDeleteYou are so intelligent. You realize thus considerably relating to this subject, made me in my
opinion imagine it from a lot of numerous angles.
Its like men and women aren't fascinated unless it's one thing to do with Girl gaga!
Your individual stuffs great. Always maintain it
up!
Thanks for sharing your ideas and valuable time..
ReplyDelete
DeleteHi Siva,
Always welcome :)
Regards,
ora-data Team
excellent..thanks to share valuable information..please do let me know what are the scenario that i should be store enough to change the carrier from oracle dba to oracle apps dba.
ReplyDeleteDear User,
DeleteThank you for your feedback.
Oracle Apps DBA is very easy, mostly you should know Apps architecture, patching, cloning, CM concepts and details, Apps log file details and some more details...
Regards,
ora-data Team
why? oracle core dba is good. why do u want to switch? core dba is more secure then apps dba.
Delete
ReplyDeleteDear Friend,
If you are good in Oracle DBA then you can learn easily Oracle Apps DBA in 1 or 2 months max.
We will be very happy to help you here, please let me know for any further guidance.
We may not check comments daily but you can send us email on Contact Us box.
It may delay but we are sure we will try our best to help here...
Regards,
ora-data Team
I always emailed this website post page to all my
ReplyDeleteassociates, since if like to read it then my links will too.
I in addition to my guys ended up digesting the great
ReplyDeleteinformation and facts located on your web site and then quickly I got a horrible feeling I never expressed respect to the web blog owner for those techniques.
All of the men ended up so excited to see all of them and already have clearly been using them.
Appreciate your turning out to be considerably thoughtful as well as for
deciding upon this sort of important resources millions of
individuals are really desperate to discover. Our own sincere regret for not saying thanks to
you earlier.
DeleteDear User,
Thank you very much for your valuable feedback.
Thank you for your kind words.
We are trying to put very clear topics which we have post recently, please check:
R12.2 Cloning Steps
FNDCPASS ERROR
Regards,
ora-data Team
ReplyDeleteDear User,
Thank you...
Regards,
ora-data Team
Great post. I was checking continuously this blog and I'm impressed!
ReplyDeleteExtremely useful info specially the last part :) I care for such info
a lot. I was looking for this certain info for a very long time.
Thank you and good luck.
Dear User,
DeleteThank you for your great feedback...
Regards,
ora-data Team
Ahaa, its pleasant discussion concerning this paragraph at thnis place at
ReplyDeletethis webpage, I have read all that, so at this time me also commentinjg here.
Dear User,
DeleteThank you for your feedback...
Regards,
ora-data Team
Truly no matter if someone doesn't know then its up to other people that they
ReplyDeletewill assist, so here it takes place.
Fantastic website. A lot of helpful info here. I'm sending it
ReplyDeleteto a few friends ans additionally sharing in delicious.
And certainly, thanks on your sweat!
Dear User,
DeleteThank you for your kind feedback.
Regards,
ora-data Team
What's up all, here every one is sharing such knowledge, so it's
ReplyDeletenice to read this webpage, and I used to pay a quick visit this webpage daily.
Dear User,
DeleteThank you very much for your valuable time and feedback.
Regards,
ora-data Team
Dear User,
ReplyDeleteThank you for your visiting and commenting here.
Till now I don't have any refer , Sure I will share if get any such stuff.
Regards,
ora-data Team
thank you for this post, I am a big big fan of this site would like to continue updated.
ReplyDeleteDear User,
DeleteThank you very much for your valuable and kind words.
Regards,
ora-data Team
Hello, I do believe your blog may be having internet browser compatibility issues.
ReplyDeleteWhenever I take a look at your website in Safari, it
looks fine however, if opening in Internet Explorer, it's got some overlapping issues.
I merely wanted to give you a quick heads up! Apart from that, wonderful site!
I was wondering if you ever thought of changing the structure of your blog?
ReplyDeleteIts very well written; I love what youve got to
say. But maybe you could a little more in the way of content so people could connect
with it better. Youve got an awful lot of text for only having 1 or
two images. Maybe you could space it out better?
Write more, thats all I havce to say. Literally, it seems ass though you relied on the video to ake your point.
ReplyDeleteYou obviously know what youre talking about,
why waste ykur intelligennce on just posting videos
to your site when you could be giving us something informative to read?
I blog often and I really appreciate your information. Your article
ReplyDeletehas truly peaked my interest. I will book mark your site
and keep checking for new details about once a week.
I subscribed to your Feed too.
Thanks for finally talking about >"Oracle DBA Troubleshooting Tips and Guide" <Liked it!
ReplyDelete