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