Hey
DBA-Mates,
Work-around:
Answer:
Work-around:
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.
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
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.
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:
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 here: Steps 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.
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
Excellent blog poѕt. I absolutely love this
ReplyDeletewebsite. 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
I could not resist commenting. Exceptionally well written!
ReplyDeleteAmazing things here. I am very happy to see your post.
ReplyDeleteThank you so much and I'm looking ahead to touch you.
Will you kindly drop me a mail?
Dear User,
DeleteThank 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
Perfect piece of work you have done, this site is really cool with superb
ReplyDeleteinformation.
Dear User,
DeleteThank you very much for your valuable feedback and words.
Regards,
ora-data Team
I really like your writing style, good information, regards for
ReplyDeleteputting up :D.
Just wisһ to say your article is as ѕurprіѕing.
ReplyDeleteThe 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 youｒ fｅed tⲟ stay updated with imminent post.
Thank you 1,000,000 and please keep up the reѡarding work.
Dear User,
DeleteThank you very much for your such valuable and kind feedback.
Regards,
ora-data Team
I am glad to be one of several visitants on this outstanding web site (:
ReplyDelete, thanks for putting up.
Everythіng is verｙ open with a very clear clarification of the challenges.
ReplyDeleteӀt was rеalⅼy informative. Your websitｅ is very useful.
Many thanks for sharing!
Superb website on this page! In addition your web sites a whole lot up rapidly!
ReplyDeleteWhatever 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
People essentially lend a hand to create making an attempt article content I’d talk about.
ReplyDeleteIt'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!
Magnificent place.
ReplyDeleteI’ve been surfing on the internet greater than 3 hours
ReplyDeletenowadays, 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.
Thank you for an alternative useful weblog. The place other than them might possibly
ReplyDeletePurchase 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.
Hello, I’m genuinely relieved I’ve observed this info.
ReplyDeleteCurrently 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.
Appreciate it for virtually any amazing content. The destination otherwise may possibly just about anyone get that particular info
ReplyDeletein their normal great way with words? I own a speech right after weeks time, at
this point along at the seek for such info.
You have made a lot of very good issues right now there. I did so a quest on the difficulty determined a
ReplyDeletegood number of people will have similar feeling with the web site.
I'm not much of a number of where you are getting the details,
ReplyDeletehaving 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.
Needing zero cost proxies for your Search engine optimisation programs?
ReplyDeleteIf you choose, then an collection is good for everyone.
Their includes proxy servers for the distributing not to mention cotton wool
swab.
Seriously! This could be the type of of the most effective sites We’ve previously appear all around on this subject matter.
ReplyDeleteBasically Wonderful. I’m too a guru within this topic in order to have an understanding of
your energy.
A person effectively help to help with making very seriously items We'd
ReplyDeletetalk 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!
It’s the right time for making a few plans for future years
ReplyDeleteas 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!
I¡¦ve not too long ago started out a website,
ReplyDeletethe info you offer on this internet site assists me drastically.
Thank you for your current point in time & employment.
It truly is a amazing together with beneficial joint of advice.
ReplyDeleteWe're pleased that you simply embraced this
beneficial info here. Why not keep us recent that way. Appreciation for giving.
aptitudes that may help you youa to make sure you area placement together
ReplyDeletewith good shell out in reputated group in places you could move
on industry and bring possibilities potential customers
I’m delighted to see this. It is the variety of hands-on that has to
ReplyDeletebe 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.
I has gone more than this web page and you then have a great number of terrific facts, was
ReplyDeleteable to save for you to faves (:.
Ahaa, it is decent controversy regarding it piece of writing you'll
ReplyDeletecome to this specific blog site, We have look over all that,
thus everyone too commentinghere.
impressive points forever, you may gotten the latest website reader.
ReplyDeleteWhat may very well one indicate concerning your site for you to created week during the past?
Whatever sure?
how to post on facebook . com as being a pagefb share
ReplyDeleteIt is actually a excellent and also advantageous item of advice.
ReplyDeleteI 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.
The like your story study my mind! Creative ideas
ReplyDeleteknowa 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.
Marvelous internet site. A good amount of important facts there.
ReplyDeleteI¡¦m mailing it again to a few buddies ans likewise discussing during delicious.
And of course, many thanks in your exertion!
No doubt believe for which you talked about. Your cause appeared to be online the easiest thing to be aware of.
ReplyDeleteI 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
Thanks for the good judgments. Myself & my very own next-door neighbor ended up really preparing to search with this.
ReplyDeleteWe 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.
This was it, i was trying to find. Thanks a lot for requiring time to release it on your post.
ReplyDeleteReally 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.