Thursday, 6 July 2017

Oracle DBA Troubleshooting Tips and Guide

Hey Buddies, 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.


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.


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:

ora-data Team.


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

    Oracle Training


    1. Hi Venkat,

      Thank you.

      ora-data Team.

  2. My developer is trying to convince me to move to .net from PHP.
    I have always disliked the idea because of the expenses.
    But he's tryiong none the less. I've been using WordPress on numerous websites for about
    a year and am concerned about switching to another platform.

    I have heard excellent things about Is
    there a way I can import all my wordpress posts into it?
    Any help would be really appreciated!

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

  4. Thanks for sharing your ideas and valuable time..


    1. Hi Siva,

      Always welcome :)

      ora-data Team


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