Saturday, 1 September 2018


Hey DBA-Mates,
We are back again with some real time interviews Questions and Answers which are asked by DBA in one of top MNC Companies.
We can’t say they will ask the same questions because interviewers always changed. This is only for some ideas and references for interviews which may useful for you all here.

Note: These questions are for experienced Oracle Apps DBAs.

1. Introduction about your experiences.

2. Application Patching steps in R12.1.3.

Click here for Steps...

3. What is DB link and how to create it.

Click here for Steps...

4. What is SRVCTL.

srvctl  status instance -d <DB_name> -i <instance1>, <instance2>
srvctl status database -d <DB_name>
srvctl stop database -d <DB_name> -o immediate
srvctl start instance -d <DB_name> -i <instance_name>

We tried to categorized which easy to understand.
Fore more Help Click here

5. How to recover a table from full Database backup.

Either from FRA if enabled or from database backup(incomplete recovery) or export / import from clone instance.

6. How to recover a dropped table.

Either from FRA if enabled or from database backup(incomplete recovery) or export / import from clone instance.

7. What is ora-504.

8. what to do for timeout error in OPP.

9. What is difference between R12.1.3 and R12.2 patching process.

10. What is cleanup phase.

11. Can we use adpatch in R12.2.

We use ADOP phases in R12.2, we can't use adpatch in R12.2 even though ADOP internally call adpatch.

12. Whats are the phases in R12.2.

Main phases are PAFCC i.e 
Prepare phase
Apply phase
Finalize phase
Cutover phase and 
Cleanup phase.

Also FS_clone, abort etc...

13. How to import a single table  from 4 tables dump file.

14. How to compile JSP manually.

Please check hereSteps to Compile JSP manually

15. How to Apply patch in RAC.

We can use Rolling process. i.e. stop one instance then apply patch then start it, 2nd again stop another instance , apply patch and start instance. etc...

16. How to apply Database patch.
Using Opatch . Please check here DATABASE OPATCH...

17. What is napply option.

Opatch napply command to apply multiple patches to an Oracle Fusion Middleware Oracle home.

18. How to check database configurations.

19. What to do for long running program in R12.1.3.

20 How can we rollback apps patches.

If it is not mentioned in Readme.html then not possible to revert back the fully applied patch. Partially we can try as per my knowledge.

21. Why we use Rman duplicate , why not restore and recover manually.

22. How check FRA is enabled or not.

sqlplus '/ as sysdba'
SQL> select flashback_on from v$database;

We will keep post or update the Answers for these Questions. Please you all also requested to update/provide answers in comment box which will be useful to all us.

Some more important links:
ora-data Team


  1. Excellent blog poѕt. I absolutely love this
    website. Kеep it up!
    additional hints : Beѕt 4 Tips Foг Encryption Software & Eight Irгeplaceable Тips To
    How To Encrypt A Password For Free Less And Ɗeliver More

  2. I could not resist commenting. Exceptionally well written!

    1. Dear User,
      Thank you for your feedback.

      ora-data Team

  3. Amazing things here. I am very happy to see your post.
    Thank you so much and I'm looking ahead to touch you.
    Will you kindly drop me a mail?

    1. Dear User,
      Thank you for your visit and feedback.
      Sorry, I don't have your email and email for what should I write to you.

      ora-data Team

  4. Perfect piece of work you have done, this site is really cool with superb

    1. Dear User,
      Thank you very much for your valuable feedback and words.

      ora-data Team

  5. I really like your writing style, good information, regards for
    putting up :D.

  6. Just wisһ to say your article is as ѕurprіѕing.
    The clarity for your publish is just great and һat i can think you are an xpert on thiѕ subject.
    Fine togеther with your permission alⅼow me to clutch your feed tⲟ stay updated with imminent post.
    Thank you 1,000,000 and please keep up the reѡarding work.

    1. Dear User,
      Thank you very much for your such valuable and kind feedback.

      ora-data Team

  7. I am glad to be one of several visitants on this outstanding web site (:
    , thanks for putting up.

  8. Everythіng is very open with a very clear clarification of the challenges.
    Ӏt was rеalⅼy informative. Your website is very useful.
    Many thanks for sharing!

    1. Dear User,
      Thank you very much for your kind feedback.

      ora-data Team

  9. Superb website on this page! In addition your web sites a whole lot up rapidly!
    Whatever hold thinking of utilising? May i get the web link to your current
    variety? I wish my site laden up as extremely fast just as your own property hahah

  10. People essentially lend a hand to create making an attempt article content I’d talk about.
    It's the very first time that I really went to see internet document for that reason a good deal?
    Simply put i fascinated using the examination you've made to produce this particular publish astonishing.
    Wonderful actions!

  11. Magnificent place.

  12. I’ve been surfing on the internet greater than 3 hours
    nowadays, but Irrrve never found every attention-grabbing posting including
    one. It’s beautiful worthy of adequate i believe.

    In my opinion, in case pretty much all online marketers and additionally writers created fantastic material as
    you have, cyberspace will undoubtedly be additional helpful previously.

  13. Thank you for an alternative useful weblog. The place other than them might possibly
    Purchase that type of info developed in this kind of ideal means?
    I’ve an assignment that i'm at the moment working on, in addition to I’ve experienced the looks available for the purpose
    of many of these knowledge.

  14. Hello, I’m genuinely relieved I’ve observed this info.
    Currently blog release only around gossip in addition to netting and this
    is basically disheartening. An outstanding blog through
    remarkable content, that’s things i might need. Thank you for attempting to keep this url, I’ll possibly be seeing them.

    Happens must be? Won't be able to think it is.

  15. Appreciate it for virtually any amazing content. The destination otherwise may possibly just about anyone get that particular info
    in their normal great way with words? I own a speech right after weeks time, at
    this point along at the seek for such info.

  16. You have made a lot of very good issues right now there. I did so a quest on the difficulty determined a
    good number of people will have similar feeling with the web site.

  17. I'm not much of a number of where you are getting the details,
    having said that terrific subject matter. I has got to devote more time to
    studying a lot more and also physical exercise way more. Appreciate spectacular knowledge I seemed to be looking
    for these records for my voyage.

  18. Needing zero cost proxies for your Search engine optimisation programs?

    If you choose, then an collection is good for everyone.
    Their includes proxy servers for the distributing not to mention cotton wool

  19. Seriously! This could be the type of of the most effective sites We’ve previously appear all around on this subject matter.

    Basically Wonderful. I’m too a guru within this topic in order to have an understanding of
    your energy.

  20. A person effectively help to help with making very seriously items We'd
    talk about. Here is the new When i used your web
    page and so a lot? I personally shocked when using the exploration you have made for making
    this actual publish astonishing. Awesome physical activity!

  21. It’s the right time for making a few plans for future years
    as well as being time for it to be very glad. I’ve understand this posting in case I'm able to That i desire to advise most people various unique points and
    even ideas. You could may prepare future articles or blog posts preaching about this informative article.
    I will keep reading aspects of doing it!

  22. I¡¦ve not too long ago started out a website,
    the info you offer on this internet site assists me drastically.
    Thank you for your current point in time & employment.

  23. It truly is a amazing together with beneficial joint of advice.
    We're pleased that you simply embraced this
    beneficial info here. Why not keep us recent that way. Appreciation for giving.

  24. aptitudes that may help you youa to make sure you area placement together
    with good shell out in reputated group in places you could move
    on industry and bring possibilities potential customers

  25. I’m delighted to see this. It is the variety of hands-on that has to
    be presented and not typically the unique stories that’s around the some other blogs and forums.

    Appreciate your posting this approach very best medical doctor.

  26. I has gone more than this web page and you then have a great number of terrific facts, was
    able to save for you to faves (:.

  27. Ahaa, it is decent controversy regarding it piece of writing you'll
    come to this specific blog site, We have look over all that,
    thus everyone too commentinghere.

  28. impressive points forever, you may gotten the latest website reader.
    What may very well one indicate concerning your site for you to created week during the past?
    Whatever sure?

  29. how to post on facebook . com as being a pagefb share

  30. It is actually a excellent and also advantageous item of advice.
    I am just content that you simply common this beneficial information and
    facts with us. I highly recommend you stop us modern such as this.
    We appreciate your giving out.

  31. The like your story study my mind! Creative ideas
    knowa large amount about it, just like you written it on it something like that.I
    believe which you can utilize a couple pictures
    to get the material residential home some, nevertheless insteadof of which, this can be outstanding blogging site.
    An excellent learn. I’ll positively be back.

  32. Marvelous internet site. A good amount of important facts there.

    I¡¦m mailing it again to a few buddies ans likewise discussing during delicious.

    And of course, many thanks in your exertion!

  33. No doubt believe for which you talked about. Your cause appeared to be online the easiest thing to be aware of.
    I explain to you, I undoubtedly find distressed although folks give
    consideration to doubts that they can simply do far from know about.
    Anyone was able smack a fasten when the most notable and also
    classified out your entire thing with out complication ,
    persons could take an alert. Is going to be back up in read more.

  34. Thanks for the good judgments. Myself & my very own next-door neighbor ended up really preparing to search with this.
    We started some sort of get a guide from a local stockpile nevertheless
    presume I actually uncovered clearer using this publish. My organization is fairly seriously
    happy to determine those outstanding knowledge staying mutual freely on the market.

  35. This was it, i was trying to find. Thanks a lot for requiring time to release it on your post.
    Really Appreciated. I will be visiting your blog site once
    again as i just found you publish such a fantastic things here.

    Likewise i figured out a site which is devoted to individuals who aspire to loose weight eventually.
    It's about Keto Body Tone that is getting popular in the USA,
    and they are concerning other nations too.

    Hope you may like to examine it out and share your views about
    Keto Body Tone Diet Product.


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