Saturday, 1 September 2018

ORACLE APPS DBA INTERVIEW QUESTIONS AND ANSWERS ON 31stAug2018

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.

Work-around:
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.

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

6. How to recover a dropped table.

Work-around:
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.

Answer:
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.

Work-around:
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.

Answer:
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:
Regards,
ora-data Team

40 comments:

  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

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

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

      Regards,
      ora-data Team

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

    ReplyDelete
    Replies
    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.

      Regards,
      ora-data Team

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

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

      Regards,
      ora-data Team

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

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

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

      Regards,
      ora-data Team

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

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

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

      Regards,
      ora-data Team

      Delete
  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

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

    ReplyDelete
  11. Magnificent place.

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

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

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

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

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

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

    ReplyDelete
  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
    swab.

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

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

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

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

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

    ReplyDelete
  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

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

    ReplyDelete
  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 (:.

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

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

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

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

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

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

    ReplyDelete
  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.
    Thx

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

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

    ReplyDelete

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