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