Wednesday, August 29, 2012

Latest Interview Questions

1. Explain the difference between adcfgclone.pl dbconfig and autoconfig?
2. what is local inventory and global inventory?in case of global inventoy corrupted how to apply opatch without creating the global inventory?
optach -invPtrLoc=oraInst.loc
3. what is the use of .patch_storage directory explan in details?
4. Explain the -invptrloc option for optach?
5. Explain some 10g RAC specific parameters?
6. can you talk about local listener and remote listener?local_lister,remote_listener parameters can be placed in the same pfile?
How To Find Out The Example of The LOCAL_LISTENER and REMOTE_LISTENER Defined In The init.ora When configuring the 11i or R12 on RAC ? [ID 744508.1]
http://www.comp.dit.ie/btierney/oracle11gdoc/install.111/b28264/undrstnd.htm

7. What is thread paramer in specific to RAC?
8. Explain database upgradation , While upgrading why we run the gather stats for dictionay?
9. While apps upgrading why we will create appsutil and copy to db home?what is the purpose?
Update database tier nodes with the Release 12.1.2 code level.
After you have upgraded to Release 12.1.2, perform the following post-update steps to update all
database tier nodes with the code level, provided by Release 12.1.2:
10. Explain about online redo log files in RAC environment? where they store,how they work,etc?
11. My ICM is down and i have submitted the concurrent request what will happen to my reuqest?
12. With PCP option enabled in the environemnt if one of my concurent manger server node crashes what will happen to running requests?
13. What is the job of internal monitor?
14. What is the unified appltop in R12?
ANS: http://onlineappsdba.com/index.php/2007/05/18/unified-appl_top-changed-feature-in-oracle-apps-r12/
15. What is the default forms mode in R12 and 11i?what is the difference between servlet and socket modes of forms mode?In 11.5.10 env, if i am business user with forms mode
    in servlet mode whether i need jintiator in my PC or not?
ANS:
====
Default Forms connection mode in Oracle Applications R12 is “SERVLET” where as in Oracle Apps 11i default form connect mode is “SOCKET”
When forms run SOCKET Mode these are dedicated connection between Client Machine & Form Server (Started by adfrmctl.sh).
When Forms run in servlet mode the forms requests are fulfilled by Jserv in Apache .
There will be additional JVM for Forms Request in that case and you won't start form via adfrmctl.sh.
Oracle Form Servlet Overview in apps R12
——————————————
i) In this mode, Java servlet handles communication between forms client(java based) and Oracle Forms Service (10g).
ii) All connection is via HTTP Server so there is no need to start form server and no need to open form server port on firewall between client machine and application tier.
iii) More secure as compared to Forms Socket Mode.
iv) Network traffic is more as HTTP protocol is more chatty so little bit network bandwidth hungry when compared with SOCKET mode
v) No additional certificate requirement during SSL implementation for application tier, single certificate will handle both forms & web connection

16. What is the difference between 11i and R12?

17a) Explain the apps upgradation?
http://onlineappsdba.com/index.php/2008/07/09/upgrade-oracle-apps-11i-to-r1212i-1204-key-points/
18. What CPU patch and PSu patch and explain the difference? what r the addition steps for applying the PSU patch?
19. While upgrading your db what about your dataguard how you operated the dataguard?
20. what is the MRP and RFS process?
21. While applying optach your database what about your datagurad? whether it will be up?
22. what optach apply will do stage by stage?
23. Explain some SSO profiles?
24. What is the diff in starting the db in normal mode and upgrade mode?

1) how to integrate sso with ebiz?
2) after sso login got the page for login credentials again? why?how to resolve it?
3) what is sso cookie?
4) explain about cloning brefily?
5) after cloning my concurrent managers are not coming up? how to resolve it?
6) My concurrent program is running very slow how to resolve it?
7) one user is complaining about one form is running very slow? what are the checks u will do it ?


No comments: