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

4 comments:

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

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

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

    ReplyDelete
  4. 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 :-)

 SPACE MANAGEMENT :: 1. Table space usuage: ============== SELECT tablespaces.tablespace_name,          allocated.total_alloc allocated_mb, ...