Key Files Locations

1. Database Tier 1.1. Set Environment Variables $ cd /u01/oracle/ visdb/9.2.0 $. ./VIS_vision.env $ echo $ORACLE_HOME /u01/oracle/ visdb/9.2.0 1.2. Files in ORACLE_HOME 1.2.1. My SID = VIS and HOST is Vision To view SI D $ echo $ORACLE_SID VIS To view Host $ hostname -s vision

File	Path
SID_HOST.env	$ORACLE_HOME/
init.ora	$ORACLE_HOME/dbs/
initSID.ora	$ORACLE_HOME/dbs/
SID_HOST_ifile.ora	$ORACLE_HOME/
addbctl.sh	$ORACLE_HOME/appsutil/ scripts/SID_HOST/
addlnctl.sh	$ORACLE_HOME/appsutil/ scripts/SID_HOST/
adautocfg	$ORACLE_HOME/appsutil/ scripts/SID_HOST/
adautocfg.sh	$ORACLE_HOME/appsutil/ scripts/SID_HOST/
adchknls.pl	$ORACLE_HOME/appsutil/ scripts/SID_HOST/
adexecsql.pl	$ORACLE_HOME/appsutil/ scripts/SID_HOST/
adlsnodes.sh	$ORACLE_HOME/appsutil/ scripts/SID_HOST/
adpreclone.pl	$ORACLE_HOME/appsutil/ scripts/SID_HOST/
adstopdb.sql	$ORACLE_HOME/appsutil/ scripts/SID_HOST/
adstrtdb.sql	$ORACLE_HOME/appsutil/ scripts/SID_HOST/

    1.3. Files in TNS_ADMIN 1.3.1. To view the TNS_ADMIN, $ echo $TNS_ADMIN /u01/oracle/ visdb/9.2.0/network/admin/VIS_vision

File	Path
listener.ora	$TNS_ADMIN/
sqlnet_ifile.ora	$TNS_ADMIN/
sqlnet.ora	$TNS_ADMIN/
tnsnames.ora	$TNS_ADMIN/
listener_ifile.ora	$TNS_ADMIN/

    2. Application Tier 2.1. Set Environment Variables $ cd /u01/oracle/ visappl $. ./ APPSORA.env $ echo $ORACLE_HOME /u01/oracle/ visora/8.0.6 2.2. Files in ORACLE_HOME

File	Path
SID_HOST.env	$ORACLE_HOME/
forms60_server	$ORACLE_HOME/
CGIcmd.dat	$ORACLE_HOME/ reports60/ server/
REP60_SID.ora	$ORACLE_HOME/ reports60/ server/
runform.htm	$ORACLE_HOME/ tools/web60/html/
runrep.htm	$ORACLE_HOME/ tools/web60/html/

  2.3. Files in TNS_ADMIN 2.3.1. To view the TNS_ADMIN, $ echo $TNS_ADMIN /u01/oracle/ visdb/9.2.0/network/admin/VIS_vision   2.4. Files in APPL_TOP 2.4.1. To view the APPL_TOP, $ echo $APPL_TOP /u01/oracle/ visappl

File	Path
APPSORA.env	$APPL_TOP/
APPSSID_HOST.env	$APPL_TOP/
SID.env	$APPL_TOP/
SID_HOST.env	$APPL_TOP/
adconfig.txt	$APPL_TOP/admin/
adovars.env	$APPL_TOP/admin/

  2.5. Files in FND_TOP 2.5.1. To view the FND_TOP, $ echo $FND_TOP /u01/oracle/ visappl/ fnd/11.5.0

File	Path
HOST_SID.dbc	$FND_TOP/ secure/
appsweb.cfg	$FND_TOP/ resource/

   2.6. Files in COMN_TOP 2.6.1. To view the COMN_TOP, $ echo $COMN_TOP /u01/oracle/ viscomn

File	Path
adalnctl.sh	$COMN_TOP/admin/scripts/SID_HOST/
adapcctl.sh	$COMN_TOP/admin/scripts/SID_HOST/
adaprstctl.sh	$COMN_TOP/admin/scripts/SID_HOST/
adautocfg.sh	$COMN_TOP/admin/scripts/SID_HOST/
adcmctl.sh	$COMN_TOP/admin/scripts/SID_HOST/
addisctl.sh	$COMN_TOP/admin/scripts/SID_HOST/
adexecsql.pl	$COMN_TOP/admin/scripts/SID_HOST/
adfmcctl.sh	$COMN_TOP/admin/scripts/SID_HOST/
adfmsctl.sh	$COMN_TOP/admin/scripts/SID_HOST/
adfrmctl.sh	$COMN_TOP/admin/scripts/SID_HOST/
adpreclone.pl	$COMN_TOP/admin/scripts/SID_HOST/
adrepctl.sh	$COMN_TOP/admin/scripts/SID_HOST/
adstpall.sh	$COMN_TOP/admin/scripts/SID_HOST/
adstrtal.sh	$COMN_TOP/admin/scripts/SID_HOST/
adtcfctl.sh	$COMN_TOP/admin/scripts/SID_HOST/
gsmstart.sh	$COMN_TOP/admin/scripts/SID_HOST/
jtffmctl.sh	$COMN_TOP/admin/scripts/SID_HOST/
adgendbc.sh	$COMN_TOP/admin/ install/SID_HOST/
aplogon.html	$COMN_TOP/admin/portal/SID_HOST/
applist.html	$COMN_TOP/admin/portal/SID_HOST/

    2.7. Files in OA_HTML 2.7.1. To view the OA_HTML, $ echo $ OA_HTML /u01/oracle/ viscomn/html

File	Path
appsweb_SI D_HOST.cfg	$OA_HTML/bin/
ICXINDEX.htm	$OA_HTML/US/