Apps DBA Interview questions.

1.    What is the use of shared appl_top? Let's assume I have shared my appl_top across 4 nodes. How many times I have to apply  ADpatch ?

2.  How to re-create corrupted oraInventory ?

3. How do I run autoconfig in test mode ( without changing any files and I want to know what will happen, if I run autoconfig) ?

4.  What's the purpose of providing 0 and Y, while changing passwords using FNDCPASS ?

5.  What happen if someone deleted FNDLIBR? how to recover ?

6.  What are .ldf and .ltc files?

7.  How to find out the parameters supplied to JVM ?

8.  How to find out the java Classpath in oracle apps ?

9.  How to troubleshoot java.lang.NoClassDefFound error ?

10. What could be the reason for  "network adapter unable to connect to db" error while doing post clone of appsTier ?

11. What is the purpose of adgendbc.sh file? Syntax for adgendbc.sh ? where it is located?

12. How to fix UTL_FILE error while doing autoconfig?

13. What's the purpose of adbldxml ? Syntax and location.

14. How to find out the status of ICM ? Which script is used for that ?

15. What are the two values given at "compile_all=?" while compiling forms ? what's the significance of each value ?


post your answers quoting the question number.

I will be updating this thread with more questions.

Regards,
Sundar K
at

4 comments:

  1. Sundar KannanJune 18, 2010 at 6:38 PM

    Ans for question #3.
    http://blogs.oracle.com/gverma/2008/01/running_autoconfig_in_test_mod.html

    ReplyDelete
  2. AnonymousMay 30, 2011 at 1:40 PM

    Ans for Q#2.
    cd $ORACLE_HOME/oui/bin
    ./runInstaller -silent -attachHome ORACLE_HOME="" ORACLE_HOME_NAME=""

    ReplyDelete
  3. AnonymousMay 30, 2011 at 2:29 PM

    Q#3: $AD_TOP/bin/adchkcfg.sh - runs autoconfig in test mode.

    ReplyDelete
  4. AnonymousMay 30, 2011 at 2:37 PM

    Ans for Q#4:
    0 is request id (request ID 0 is assigned to request ID’s which are not submitted via Submit Concurrent Request Form.)

    ’Y’ indicates the method of invocation. i.e. it is directly invoked from the command-line not from the Submit Request Form.

    ReplyDelete

Kindly make your valuable and progressive comments here.
Junks will be deleted without notice :-)

Subscribe to: Post Comments (Atom)

  Find below few useful scripts for  Performance  Management:: # Important MOS notes for TRACING: There are several ways to trace a particul...

  • adapcctl.sh: exiting with status 204
    On a new VIS R12.1 installation, the OHS (oracle http server) failed to start and give status 204. Upon querying the status of opmn manage...
  • Ever Hit with ORA-46981 in Oracle EBS Environment ?
    Recently when I was tasked to do a cloning of my production Oracle Apps instance to a target single-node server,  I hit a dead-end with the ...
  • (no title)
    A nice story about RMAN.           The story begins,  when one of my associate DBAs did an RMAN restoration & recovery 2 days back...