Oracle Apps DBA (R12.
2)
File System & Consoles
Atul Kumar Amit Sharma
Oracle ACE & Cloud Expert Oracle AppsDBA Expert
© Copyright 2018 | K21 Academy | All Rights Reserved
/company/k21academy /k21academy /k21academy /k21academy
[email protected] 1
Atul Kumar
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
2
Amit Sharma
Obsessed with learning new things in Oracle
Started implementing Fusion Middleware Products like SOA,
OBIEE, IAM , WebCenter etc
Trained 300+ trainees and 30+ corporate clients
Oracle Certified Professional
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
3
Join Private Facebook Group
http://k21academy.com/community
Making Best of Your
Training
Get Support: [email protected] (New Mail for Different Issue)
Add Yourself in WhatsApp Group
Unlimited Retake for Next 1 Years
Request for VPN when ready (30 Days start from Day you receive
details)
Before Coming to Class: Watch Video & Look at Activity Guide
Ask as Many Questions as you can & make session interactive
Remind Us to Record the Session
Do Lots of Hands-On (You Must Request VPN)
Feedback Good/Bad to Trainer for improvement
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
5
Getting Help
[email protected]
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
6
Agenda: Course
Module I: Architecture & Changes in Oracle E-Business Suite
R12.2
Module II: R12.2 Staging & Installation
Module III: File System & Important Files in R12.2
Module IV: Start/Stop in R12.2
Module V: AD Administration
Module VI: Patching in Apps DBA – ADOP, ADPATCH, OPATCH
Module VII: Cloning in EBS R12.2 (DB & Apps Tier)
Module VIII: Concurrent Managers
Module IX: AutoConfig – Apps & DB Tier
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
7
Agenda: Course
Module X: Password Management (Schema, End User)
Module XI: Troubleshooting
Bonus: FMW Concepts in Apps DBA – WebLogic & OHS
(bonus*)
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
8
Agenda: Module
File System: DB & Apps Tier
Dual File System
Non Edition File System
Instance Home
FMW Home
APPL TOP
COMMON TOP
LOG Home
Environment Files
Consoles (WebLogic & FMW
Control)
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
9
R12.2 File System
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
10
EBS File System
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
11
EBS File System
s_ebs_base
Database Tier
12.1.0
data
Application Tier
fs1
fs2
fs_ne
Dual File System
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
12
EBS File System
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
13
EBS File System: Key Points
R12.2 has Dual File System.
Run File system & Patch File System are Identical
To Support Online Patching (ADOP)
Single Non Edition File System which has AD exe, PATCH_TOP
Instance Top excludes Weblogic and OHS files
No support for Read Only APPL_TOP Access across Instances
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
14
Apps Tier File System
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
15
Dual File System
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
16
Non Edition File System
APPL_TOP_N
E
PATCH_TOP
PATCH_LOG
APPLCSF
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
17
INST_TOP: Instance Home
$BASE/[fs1|fs2]/inst/a
pp
s/$CONTEXT_NAME
Mainly for
Configuratio
n
Weblogic & OHS
configurations are
NOT stored in
INST_TOP
In Multi-Node Install,
keep Instance Home on
Local File System
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
18
FMW_HOME: Fusion Middleware
$BASE/[fs1|fs2]/FMW_Home
WL_HOME
DOMAIN_HOME
ORACLE_HOME
INSTANCE_HOME
COMMON ORACLE_HOME
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
19
FMW_HOME Files
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
20
COMMON_TOP
$BASE/[fs1|fs2]/EBSapps/com
n
admin: CM default log & out
_pages: complied jsp
java: classes & jar
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
21
APPL_TOP
$BASE/[fs1|fs2]/EBSapps/appl
Core Technology Files &
Directories
Product Files & Directories
Environment Files
Product Tops
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
22
LOG_HOME
$BASE/[fs1|fs2]/inst/apps/$CONTEXT_NAME/lo
gs
Log Files for: Start/Stop, RunTime generated
Log File NOT for: OHS, WLS, CM, Patching
AutoConfig logs are under
$INST_TOP/admin/logs/<MMDDhhmm>
Patch Logs are under
$BASE/fs_ne/EBSapps/log/adop/<adop_sessio
n_id>/<phase_timestamp>/$CONTEXT_NAME
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
23
R12.2 Environment Files
Filename Location Path Filename Filename Location Path Environment Purpose
Environment Location Path
Environment
<CONTEXT_NAME>.env 12.1.0 <s_base>/12.1.0 Database Environment
ORACLE_HOME Variables
<CONTEXT_NAME>.env OracleAS 10.1.2 <sbase>/inst/apps/<CONTEXT_NAME>/ora/10.1.2 10.1.2 Environment
ORACLE_HOME Variables
EBSapps.env BASE <s_base> Set ENV as per Edition
<CONTEXT_NAME>.env APPL_TOP <s_base>/EBSapps/appl Oracle Application Stack
environment variables
APPS<CONTEXT_NAME>.env APPL_TOP <s_base>/EBSapps/appl Master env file which
calls all the above
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
24
Consoles
WebLogic & FMW
Control
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
25
R12.2 Admin Server & Console
Only one Admin server possible in an EBS Environment
Single Point of Failure, ADOP cannot be triggered if Admin server is
down
Hosts Weblogic Console (/console) & FMW Conrol (/em)
Admin Console URL: http://<adminHost>:<adminPort>/console
EM Console URL: http://<adminHost>:<adminPort>/em
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
26
Weblogic Console: Server
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
27
Weblogic Console: Data Source
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
28
Data Source: Connection Pool
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
29
Data Source: Connection Pool
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
30
FMW Control: EM
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
31
Summary: Module
File System: DB & Apps Tier
Dual File System
Non Edition File System
Instance Home
FMW Home
APPL TOP
COMMON TOP
LOG Home
Environment Files
Consoles (WebLogic & FMW Control)
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
32
Find Us
http://facebook.com/k21Academy
http://twitter.com/k21Academy
https://www.linkedin.com/company/k21Acade
my https://www.youtube.com/k21academy
www.k21academy.com/community ©©Copyright
Copyright2018
2019| |K21
K21Academy
Academy| All
| AllRights
Rights Reserved
Reserved
33