• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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/

 

Summary
Review Date
Reviewed Item
Key Files Locations
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Key Files Locations"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.