• 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

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/

 

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.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.