E-Business Suite R12 Administration Basics

Apps Tiers:

Database Tier ( Database & DB Listener )

Application Tier ( WebServer, Forms, Reports, Concurrent Manager, Discoverer, Apps Listener)

File System:

The major difference between R12 and 11i has been the introduction of INST_TOP with R12, called the Instance Top. This top has all the configuration and log files separate for ease of maintenance and autoconfig doesn’t have to do any changes in APPL_TOP. The other major change is the introduction of 10gAS for both forms and iAS.

APPL_TOP à Product directories (AP,GL), also AD_TOP àAPPL_TOP/ad

COMMON_TOP àCommon file, logs, java, html, etc

ORA_TOP à ORACLE_HOME for 10g (forms) and IAS_ORACLE_HOME for application server 10gAS

DATA_TOP à DB files

DB_HOME à DB file system (ORACLE_HOME)

$INST_TOP/admin/scripts ($ADMIN_SCRIPTS_HOME)
$INST_TOP/appl            ($APPL_CONFIG_HOME)
$INST_TOP/fnd/12.0.0/secure    ($FND_SECURE)
$INST_TOP/certs
$INST_TOP/logs            ($LOG_HOME –  autoconfig logs here by default)
$INST_TOP/ora            ($ORA_CONFIG_HOME)
$INST_TOP/ora/10.1.2
$INST_TOP/ora/10.1.3   ($ORACLE_CONFIG_HOME)
$INST_TOP/pids
$INST_TOP/portal

  

Order of StartUp of Services:
First DB Listener, Database & then Application Tier Services

Order of ShutDown of Services:
First Application Tier Services then Database & DB Listener

Database startup/shutdown scripts:
cd $INSTALL_BASE/db/tech_st/11.1.0
addbctl.sh database startup shutdown script
addlnctl.sh database listener Script

Application Tier Startup/Shutdown Scripts
Source environment from $INSTALL_BASE/apps/apps_st/appl

cd $ADMIN_SCRIPTS_HOME

adalnctl.sh Apps Listener Control Script
adapcctl.sh Apache/Web Server Control Script
adcmctl.sh Concurrent Manager Control Script
addisctl.sh Discoverer Control Script
adfrmctl.sh Forms server Control Script
adrepctl.sh Report Server Control Script
adstpall.sh Stop All Middle/Application Tier
adstrtall.sh Start All Middle/Application Tier

Context File: Used by adconfig.sh for configuring the application.

$INST_TOP/appl/admin is the new location for Context File

If not sure, query FND_OAM_CONTEXT_FILES table.

Log Files:

$LOG_HOME à $INST_TOP/logs

Concurrent Manager

$LOG_HOME/appl/conc àconcurrent requests log and out files
$LOG_HOME/appl/admin à mid tier startup scripts log files

Apache Logs (10.1.3 Oracle Home)

$LOG_HOME/ora/10.1.3/Apache à Apache Error and Access log files
$LOG_HOME/ora/10.1.3/j2ee à j2ee related log files
$LOG_HOME/ora/10.1.3/opmn à opmn related log files

Forms & Reports related logs (10.1.2 Oracle Home)

$LOG_HOME/ora/10.1.2/forms
$LOG_HOME/ora/10.1.2/reports

Finding Application or file Version:

How to find Application Version (R12)

select release_name from apps.fnd_product_groups;

Apache or Application Server in Apps R12
Log in as Application user, set environment variable and run below query

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd –version

Forms & Report version in R12
$ORACLE_HOME/bin/rwrun | grep Release

 Oracle Jinitiator in R12
 Log in as Application user, set environment variable and run below query
grep jinit_ver_comma $CONTEXT_FILE

 Oracle Java Plug-in in R12
 Log in as Application user, set environment variable and run below query
grep plugin $CONTEXT_FILE

File Version on file system
adident Header
strings | grep Header

Discoverer Version for R12 (10g AS)
Check under Application Server Section as 10g AS Discoverer is on standalone

 Workflow Version with Apps
 Connect to Database as apps user
 select TEXT Version from   WF_RESOURCES where  NAME = ‘WF_VERSION’;

Oracle Database

select * from v$version;
$ORACLE_HOME/OPatch/opatch lsinventory –detail

Operating System

Solaris : cat /etc/release
Red Hat Linux : cat /etc/redhat-release