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/ |
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
1/15
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox