Key Files Locations
1. Database Tier1.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/ |