Thursday 6 July 2017

Oracle DBA Troubleshooting Tips and Guide


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,

30 comments:

  1. Good and Interesting... Thanks for sharing your ideas and valuable time...

    Oracle Training

    ReplyDelete
  2. What i do not realize is in reality how you are no longer actually much more well-favored than you may be now.

    You 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!

    ReplyDelete
  3. Thanks for sharing your ideas and valuable time..

    ReplyDelete
    Replies

    1. Hi Siva,

      Always welcome :)

      Regards,
      ora-data Team

      Delete
  4. 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.

    ReplyDelete
    Replies
    1. Dear User,
      Thank 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

      Delete
    2. why? oracle core dba is good. why do u want to switch? core dba is more secure then apps dba.

      Delete

  5. Dear 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

    ReplyDelete
  6. I always emailed this website post page to all my
    associates, since if like to read it then my links will too.

    ReplyDelete
  7. I in addition to my guys ended up digesting the great
    information 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.

    ReplyDelete
    Replies

    1. Dear 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

      Delete

  8. Dear User,

    Thank you...

    Regards,
    ora-data Team

    ReplyDelete
  9. Great post. I was checking continuously this blog and I'm impressed!
    Extremely 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.

    ReplyDelete
    Replies
    1. Dear User,

      Thank you for your great feedback...

      Regards,
      ora-data Team

      Delete
  10. Ahaa, its pleasant discussion concerning this paragraph at thnis place at
    this webpage, I have read all that, so at this time me also commentinjg here.

    ReplyDelete
    Replies
    1. Dear User,
      Thank you for your feedback...

      Regards,
      ora-data Team

      Delete
  11. Truly no matter if someone doesn't know then its up to other people that they
    will assist, so here it takes place.

    ReplyDelete
  12. Fantastic website. A lot of helpful info here. I'm sending it
    to a few friends ans additionally sharing in delicious.

    And certainly, thanks on your sweat!

    ReplyDelete
    Replies
    1. Dear User,
      Thank you for your kind feedback.

      Regards,
      ora-data Team

      Delete
  13. What's up all, here every one is sharing such knowledge, so it's
    nice to read this webpage, and I used to pay a quick visit this webpage daily.

    ReplyDelete
    Replies
    1. Dear User,
      Thank you very much for your valuable time and feedback.

      Regards,
      ora-data Team

      Delete
  14. Dear User,
    Thank 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

    ReplyDelete
  15. thank you for this post, I am a big big fan of this site would like to continue updated.

    ReplyDelete
    Replies
    1. Dear User,
      Thank you very much for your valuable and kind words.

      Regards,
      ora-data Team

      Delete
  16. Hello, I do believe your blog may be having internet browser compatibility issues.
    Whenever 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!

    ReplyDelete
  17. I was wondering if you ever thought of changing the structure of your blog?
    Its 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?

    ReplyDelete
  18. Write more, thats all I havce to say. Literally, it seems ass though you relied on the video to ake your point.

    You 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?

    ReplyDelete
  19. I blog often and I really appreciate your information. Your article
    has 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.

    ReplyDelete
  20. Thanks for finally talking about >"Oracle DBA Troubleshooting Tips and Guide" <Liked it!

    ReplyDelete

Thank you for your comments and suggestions. It's good to talk you.