Important config files and other files with locations

Important config files and other files with locations

　

Starting & Stopping Oracle Applications

　

　

Stop/start middle-tier (web-tier)

1) Web Server (Apache) apapcctl.sh

2) Forms Server adfrmctl.sh

　

Stop/start concurrent-tier

3) Concurrent Manager adcmctl.sh

4) Reports & Disocover adrepctl.sh

5) Reports Listener (RRA) adalnctl.sh

　

Stop/start db-tier

6) Database sqlplus

7) Database Listener. lsnrctl

============================================================================================

Important Environment variables which are used widely

============================================================================================

　

$APPL_TOP oracle applications software top directory variable

$FND_TOP sysadmin & aol module product top directory

$GL_TOP general ledger top

$AD_TOP/bin applications dba module product bin directory which holds all the adutilities

$APPLCSF applications common directory

$APPLCSF/admin/scripts/ all the scripts which are needed for managing(start/stop) oracle apps

$APPLCSF/$APPLLOG Log directory which will contain all the concurrent manager/Concurrent Request log files

$APPLCSF/$APPLOUT Out directory which will contain all the concurrent manager/Concurrent Request out files

$APPCPNAM This defines the naming convention for the concurrent request out files

$AU_TOP/resource oracle apps pll and plx files (pll is the source code plx is the runtime)

$AU_TOP/forms/US oracle apps fmb and fmx files (fmb is the source code)

$FORMS60_PATH pll directory path

$OA_JAVA java class files/jar files source code is located (jad.exe to create .java from .class)

$OA_HTML jsp and html files

$IAS_ORACLE_HOME application server(web server) oracle home

$ORACLE_HOME forms server oracle home (APPSORA.env will always connect to db using 806 software)

$ORACLE_HOME RDBMS ORACLE HOME

　

9iAS version 1.0.2.2.2 (Apache module 1.3.18)

　

==============================================================================================

Important Configuration Files in oracle applications

==============================================================================================

　

$APPL_TOP/APPSORA.env will make calls to $APPL_TOP/SID_hostname.env & $ORACLE_HOME/SID_hostname.env

$APPL_TOP/APPSSID_hostname.env (same like appsora.env. New version of appsora.env. appsora.env is no longer supported since AD I mini-pack)

$APPL_TOP/SID_hostname.env this has the actual environment settings and calls to $APPL_TOP/admin/adovars.env and $APPL_TOP/admin/SID_hostname.xml

$APPL_TOP/adovars.env java html top directory settings, class path settings, ld library path settings etc.

$APPL_TOP/SID_hostname.xml autoconfig context configuration file which will contain all the configuration details for oracle apps.

$ORACLE_HOME/SID_hostname.env 806 oracle home environment file which helps in calling the right version of form f60gen tool.

　

$TNS_ADMIN/tnsnames.ora /u01/oracle/crpora/8.0.6/network/admin/CRP_portal . This file is used by

FORMS SERVER, CONCURRENT MANAGER, RRA

　

$TNS_ADMIN/tnsnames.ora /u01/oracle/crpora/iAS/network/admin/CRP_portal. This will is used by Apache

　

$TNS_ADMIN/tnsnames.ora /u01/oracle/crpdb/9.2.0/network/admin/CRP_portal. This will be used by DATABASE LINKS

　

　

$TNS_ADMIN/listener.ora /u01/oracle/crpora/8.0.6/network/admin/CRP_portal . This file is used by RRA

　

$TNS_ADMIN/listener.ora /u01/oracle/crpdb/9.2.0/network/admin/CRP_portal. This is required for creating database session

　

　

$FND_TOP/secure/hostname_SID.dbc for all jsp,java,jdbc sessions this file configuration details will be used,

It has guest username/pwd and jdbc tunning/connection settings,db port,db sid etc.

　

$FND_TOP/resource/appsweb_SID_hostname.cfg forms server port, sign-on form info and the jar files which needs to be downloaded

　

$FND_TOP/reports/*.prt printer configuration files

　

　

　

$IAS_ORACLE_HOME/Apache/Apache/conf/httpd.conf normal httpd mode. This will have the apache port info and the apache log files info.

(or)

　

$IAS_ORACLE_HOME/Apache/Apache/conf/httpds.conf ssl version of the file.This will have the apache port info and the apache log files info.\

$IAS_ORACLE_HOME/Apache/Apache/conf/httpd_pls.conf this is for apache pl/sql listener configuration file

$IAS_ORACLE_HOME/Apache/Apache/conf/oprocmgr.mgr this is the apache mod_oproc module configuration file

$IAS_ORACLE_HOME/Apache/Apache/conf/oracle_apache.conf This will be called from httpd.conf. This makes calls to apps.conf and plsql.conf

$IAS_ORACLE_HOME/Apache/Apache/conf/apps.conf all the virtual directory settings.

$IAS_ORACLE_HOME/Apache/Apache/bin/apachectl oracle apps server startup script adapcctl.sh uses this file to look at httpd.conf and start

the web server. It also uses java.sh to start the java jserv engine for oracle apps.

$IAS_ORACLE_HOME/Apache/Apache/bin/java.sh determines what version of java will be used for java jserv engine.

$IAS_ORACLE_HOME/Apache/modplsql/cfg/plsql.conf contains the pointer to the pl/sql DAD module

$IAS_ORACLE_HOME/Apache/modplsql/cfg/plsql_pls.conf this same like plsql.conf but will be used for plsql pls listener

$IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app contains apps schema username and password for oracle apps

$IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.conf This is master configuration for jserv engine.will have debug info.call to jserv.properties.

jserv startup method and how many jvms will be started will be defined under this

$IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.properties heap size settings, refer to the dbc file using -DJTFDBCFILE call, jvm port range,call to rootzone

through zone.properties configuration file

$IAS_ORACLE_HOME/Apache/Jserv/etc/ssp_init.txt this is required for i-proc module to work

$IAS_ORACLE_HOME/Apache/Jserv/etc/zone.properties this will have servlet details for oracle applications

$IAS_ORACLE_HOME/Apache/Jserv/etc/formservlet.properties if you are running forms server in servlet mode as part of jserv serv engine then you need this.

$IAS_ORACLE_HOME/Apache/Apache/logs/access_log

$IAS_ORACLE_HOME/Apache/Apache/logs/error_log

$IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.log

$IAS_ORACLE_HOME/Apache/Jserv/etc/mod_jserv.log