Apps DBA Tutorial 03 - Checking and Maintaining Oracle Applications R12 after fresh Installation

As a DBA you need to check and maintain the following components constantly ->
A. Database and Listener Check
B. Environment File Check

C. DBC File Check
D. HTTP Check
E. JSP Check
F. Checking Forms Server




A. Database and Listener Check
SQL> select open_mode from v$database;
OPEN_MODE
----------
READ WRITE
SQL> select name from v$database;
NAME
---------
DEMOCCC


Check whether database is in read write mode or not. To check the listener issue the following command.

bash-3.00$ lsnrctl status DEMOCCC;
LSNRCTL for Solaris: Version 11.1.0.6.0 - Production on 23-MAR-2011 14:10:53
Copyright (c) 1991, 2007, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx.xxxx.co.in)(PORT=1589)))
STATUS of the LISTENER
------------------------
Alias                     DEMOCCC
Version                   TNSLSNR for Solaris: Version 11.1.0.6.0 - Production
Start Date                15-MAR-2011 19:37:29
Uptime                    7 days 18 hr. 33 min. 23 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /CLIENTDEMOREL12/visrel12/DEMOFNA_CLN/db/tech_st/11.1.0/network/admin/DEMOCCC_xxxx/listener.ora
Listener Log File         /CLIENTDEMOREL12/visrel12/DEMOFNA_CLN/db/tech_st/11.1.0/admin/DEMOCCC_xxxx/diag/tnslsnr/xxxx/democcc/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=*.kol.co.in)(PORT=1589)))
Services Summary...
Service "DEMOCCC" has 1 instance(s).
  Instance "DEMOCCC", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
 
The third thing to check is whether the database is accessible from remote machine or not.


B. Environment File Check
Log in to APPL_TOP and source the env file. Then check APPL_TOP, FND_TOP, AD_TOP, OA_HTML, OA_MEDIA, IAS_HOME.


C. DBC File Check
Check whether DBC file exists in  $FND_TOP/secure [for 11i] and $INST_TOP/appl/fnd/12.0.0/secure.
In DBC file the CLASSPATH should contain $JAVA_TOP
DBC file can be checked using the following command ->
jre oracle.apps.fnd.security.AdminAppServer STATUS  DBC=<full dbc file path>
Some imporatant parameter of DBC file ->
a. TWO_TASK = for thick drivers, name of the database.
b. FND_IN_USE_CONNECTION_TIMEOUT = the maximum number of seconds a connection can be in use.
c. FND_UNUSED_CONNECTION_TIMEOUT = the maximum number of seconds a unused connection will remain in cache.


D. Testing jsp
http://<host name>:<port>/OA_HTML/jsp/fnd/fndping.jsp


E. Check Form Server
Launch a form to check whether forms are working properly after installation.