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

FilePath
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

FilePath
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

FilePath
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

FilePath
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

FilePath
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

FilePath
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

FilePath
appsweb_SI D_HOST.cfg$OA_HTML/bin/
ICXINDEX.htm$OA_HTML/US/