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/ |
