E-Business Suite 11i Administration Basics

I have tried and put together a basic administration know how that any apps DBA should have knowledge of to support a Oracle e-business 11i Instance. It has the start/stop scripts, Log locations, File system structure.

Application Tiers:

Database Tier ( Database & DB Listener )

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

File System:

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 8i (forms) and IAS_ORACLE_HOME for application server 9iAS

DATA_TOP à DB files

DB_HOME à DB file system (ORACLE_HOME)

Order of StartUp of Services:

DB Listener, Database and then Application Tier Services

Order of ShutDown of Services:
Application Tier Services then Database and DB Listener

Database startup/shutdown scripts:
ORACLE_HOME / appsutil/scripts /SID_hostname
addbctl.sh database startup shutdown script
addlnctl.sh database listener Script

Application Tier Startup/Shutdown Scripts
OAD_TOP/admin/scripts/ SID_hostname

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.

DB:$ORACLE_HOME/ appsutil/ scripts $CONTEXT_NAME ($ORACLE_HOME/ appsutil/bin/adconfig.sh )

APP:$COMMON_TOP/admin/scripts/$CONTEXT_NAME ($AD_TOP/bin/adconfig.sh)

Log Files:

$APPLCSF à Application support/scripts file à $COMMON_TOP/admin/

$APPLCSF/$APPLLOG àFor concurrent request out files and logs

$APACHE_TOP/Apache/logs.

Finding Application or file Version:

select release_name from apps.fnd_product_groups;

Web Apache or Application Server in Apps 11i

Log in as Application user, set environment variable 

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

Forms & Report version in 11i
$ORACLE_HOME/bin/f60run | grep Version | grep Forms

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

Oracle Jinitiator in 11i/R12/12i
Log in as Application user, set environment variable
grep jinit_ver_comma $CONTEXT_FILE
Oracle Java Plug-in in 11i/R12/12iLog 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

OA Framework Version
http:// hostname.domainName:port/OA_HTML/OAInfo.jsp (Only for 11i)

adident Header $FND_TOP/html/Ojsp
adident Header $OA_HTML/Ojsp

Discoverer Version for 11i 
Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/disc4ws | grep -i Version

Discoverer Version for 11i 
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