Oracle Apps DBA R12 Interview Questions Q.What do we have in FND_NODES? A: FND_NODES table contains information about node_names and services enabled on a node. In multinode instance if you want to know which node is running what services, You can query the fnd_nodes and get that information. Q. What is multi node system ? [...]

Oracle Apps DBA Interview Questions – VI Q: Why we need to put maintenance mode when we are applying a patch ? A: Maintenance mode provides a clear separation between normal runtime operation of Oracle Applications and system downtime for maintenance. Enabling the maintenance mode feature shuts down the Workflow Business Events System and sets [...]

1. What is the pre-req for applying a rdbms patch? Ans : OraInventory should be set in file oraInst.loc @/var/opt/oracle or /etc 2. What is OraInventroy? Ans: The oraInventory is the location for the OUI (Oracle Universal Installer)’s bookkeeping. The orainventory stores information about: All Oracle software products installed in all ORACLE_HOMES on a machine [...]

Oracle Apps DBA Interview Questions – IV 1. What is the configuration file for adutilities (like adadmin,adconfig etc)? Ans: adconfig.txt @APPL_TOP/admin 2. What is adrelink? Ans : adrelink will relink the executables with the libraries. Generally we will go for adrelink when some patch delivers some library files, or when executables were corrupted. 3. How [...]

Oracle Apps DBA Interview Questions – III 1.  How to determine Oracle Apps 11i Version ? Ans : select RELEASE_NAME from fnd_product_groups; You should see output like RELEASE_NAME———————–11.5.10.2 2.  How to find Database version ? Ans : SQL> select * from v$version; The command returns the release information, such as the following:Oracle9i Enterprise Edition Release [...]

Oracle Apps DBA Interview Questions – II 31.  Where to find Apps 11i JVM logs ? Ans:  JVM log location is defined in java.sh ( found in $IAS_ORACLE_HOME/Apache/Apache/bin) Oracle Apps 11i JVM log file directory is defined by parameter JVMLOGDIR ($IAS_ORACLE_HOME/Apache/Jserv/logs/jvm ) and log file are defined by STDOUTLOG & STDERRLOG. Example of JVM log [...]

Oracle Apps DBA Interview Questions – I Oracle Application DBA 11i Interview Questions – I 1.  I am applying a patch , can I open another session and run adadmin ? Ans:  Yes, unless you are running a process where workers are involved 2.  I am applying a patch , can I open another session [...]