Search this site
Embedded Files
Skip to main content
Skip to navigation
Oracle Apps DBA
******* Apps DBA HOME *******
Now writing on www.expertoracle.com
A) ** APPS INTERVIEW QUESTIONS PART 1 **
AA) * APPS INTERVIEW QUESTIONS PART 2 *
B) ***** ORACLE APPS CONCEPTS ******
11i BASELINE patching
ADADMIN
Apache
apache troubleshooting
httpd.conf
Application file VERSIONS
Application Password change
APPS password change
AUTOCONFIG
Customizing Autoconfig
CLEARORBIT PRINTING
CLONING
DB cloning
RAC/ASM cloning
Rapid Clone R12.1.3 Basic steps
RMAN cloning
CONCURRENT PROCESS
CONCURRENT MGR
FNDCRM
FNDFS
FNDIMON
FNDSM
GSM
OPP
PCP
Purge programs
SCHEDULED CONC PROG
Set up PCP in 11i
DBLINKS - Apps seeded ones
EBS restrict access
EBS session
EBS table types
Files of importance
configuration files
.profile
apps.conf
appsweb.cfg
forms.properties
formservlet.properties
httpd_pls.conf
httpd_pls.conf
jserv.conf
jserv.properties
jserv_restrict.properties
mobile.properties
mwa.cfg
oprocmgr.conf
oracle_apache.conf
pasta.cfg
plsql.conf
plsql_pls.conf
security.conf
trusted.conf
wdbsvr.app
zone.properties
zone_restrict.properties
environment files
adovars.env
applsys.env
appsora.env
Contextname.env
INSTenv file
splicer.env
log files
access log
access log pls
adctrl.log
adrelink log file
Error log
error log pls
patch.log
Other imp files
adpwdctl.sh
dbc file
ldap.ora
listener.ora
sqlnet.ora
tnsnames.ora
XML file
FND Utilities
FNDLOAD
Forms Server
Connection mode
Load Balancing
Timeout
INTERCONNECT
Troubleshooting Interconnect
JVM Out of memory issue
NEW LANGUAGE
ISSUES
NOTE ID - Metalink
PROCESS
NLS MLS
IMP PROFILES
IMP TABLES
NLS_NCHAR_CHARACTERSET
oracle apps installation requirement
Page access tracking
Patching
hotpatch
patch during patch
PRINTER
pasta_pdf.cfg
PDF TO PS
Printer Argument
Printer OS requirement
Printer removal
Printer Setup
PROFILE OPTION
R12
11i vs R12
Cache clear in R12
INIT.ORA Parameters for R12
INST_TOP
OC4J instead of Jserv
OPMN
SERVLET OR SCOKET
what is new in R12
Shared App file system
Single Sign On (SSO)
OID
Oracle Application Server
SSO Server
TRACING
Database Level
Form Level
FRD
Listener Level
Report Level
Tracing a running report
Session Level
TKPROF
User level
WORKFLOW
WFLOAD
workflow notification issue
WORKFLOW PURGE
C) ****** DATABASE CONCEPTS ******
10g over 9i
ASM
Add disk to diskgroup
ASM LOG GROUP
ASM new things in 11g
ASM VIEWS
NON-ASM TO ASM
ASMM
AWR
Backup & Recovery
BCV
Data Domain
DATAPUMP
Hot backup
RMAN
RMAN Backup
RMAN Commands
RMAN Backup Commands
RMAN Crosscheck commands
RMAN Recover Commands
RMAN Show Commands
RMAN SQL Commands
Incremental Backup
RMAN CONFIGURATION
RMAN CONVERT
RMAN convert database
RMAN convert datafile
RMAN convert tablespace
RMAN Flash Recovery Area (FRA)
RMAN Format
RMAN Q&A
RMAN recovery
RMAN Restore-Recover
RMAN Scenarios (Case Studies)
RMAN Scripts
RMAN setup
RMAN Tables & Views
Case sensitive password - 11g
DATAGUARD
dbfsize
Gather Statistics
INVALID Objects
UTL_RECOMP
UTLRP.SQL / UTLPRP.SQL
LOAD BALANCING
Hardware Load Balancing
Software Load Balancing
Software Load Balancing
Materialized View
Materialized View Log
Materialized view refresh
Monitor materialized views
OPATCH
Oracle 'SERVICES' concepts
Oracle Files
PERFORMANCE TUNING
CONTENTION
INDEXES
INIT Param
LATCHES
LOCKS
Performance issues
Applications Tuning Doc
Perf Analysis Doc
Wait events
REDO
TABLESPACES
D) **** INSTALL & UPGRADE DOCS ****
a) R12.1.3/11gR2 INSTALL
**R12 Points to remember**
1) INSTALL R12.1.1 WITH 11.1.0.7db
2) UPGRADE DATABASE TO 11.2.0.3
3) UPGRADE APPS TO R12.1.13
Important Note id/docs
ISSUES AFTER INSTALLATION
NLS install for R12.1.1
Performance Tuning R12
Post migration issues
b) 11i - hpux/linux to AIX migration
AIX Issues list
c) Database 9i to 10g upgrade
d) OBIEE 11G Install with Informatica
e) 11.2.0.3 INSTALL ON UNIX
f) DB 11.1.0.7 TO 11.2.0.3 UPGRADE
g) Oracle SOA Suite 10.1.3.5 install
h) AIA 2.5 Foundation pack install
i) AIA 2.5 with Retail-EBS PIP install
j) UC4 Application manager install
k) 10.2.0.1 to 10.2.0.4 DB upgrade
l) (11iApps | 9iDB | AIX) to (R12.1.3|11g|Linux)
1) Upgrade 9i DB to 10g DB on AIX
2) Migrate DB 10g from AIX to Linux
3) Upgrade 11i (11.5.9) to R12.1.1
4) Upgrade database from 10g to 11g
5) Upgrade Apps from 12.1.1 to 12.1.3
6) Add 2nd DB node ( RAC Migration)
a) Install11g Grid Infrastructure
b) RAC Conversion Steps
7) Add 2nd Apps node (Shared Appl_top)
m) Discoverer 11G Install
1) jrockit install
2) Weblogic wls1032 Install
3) Discoverer 11G install
E) ********* UNIX / AIX / LINUX ********
.profile
Basic UNIX docs
CRONTAB
GPG BASICS
KILL command
lsof
mailx
mount command
mount nfs directory
OSWATCHER
TOPAS basics
TOPAS data troubleshoot
User Administration
User Administration
VNC
Start-Stop VNC
F) ******** CERTIFICATIONS *********
OCA syllabus
G) *** ORACLE FUSION PRODUCTS ***
1) <== FUSION MIDDLEWARE ==>
a) Oracle Weblogic Server
b) Application Integration Architecture (AIA)
c) BPEL
d) Oracle Data Integration (ODI)
e) Oracle Access Manager
f) Oracle Internet Directory
g) Service-Oriented Architecture (SOA)
h) WebCenter
2) <== FUSION APPLICATIONS ==>
H) ******** STORAGE **********
EXADATA
EXALOGIC
real vs virtual memory
SAN
SRDF
I) ******** ORACLE RAC DOCS **********
J) ********* ORACLE SCRIPTS **********
1) Oracle Apps Scripts
application user definition
Concurrent manager scripts
check CM backlog
Concurrent queues
queue_status
vusercm (sid by reqid)
which CM ran request
gather stats
Invalids
long running form session
patch related scripts
program which responsibility
2) Oracle Database Scripts
DB Growth Pattern
kill_local.sh
lock
rman monitor
tablespace monitor
venqueue_g
vusersid
vusersidsql
wait event code
3) UNIX Scripts
Z) ******** OTHER STUFF *********
Good Metalink docs
Important Links
Zread
Oracle Apps DBA
a) R12.1.3/11gR2 INSTALL
1)
INSTALL R12.1.1 WITH 11.1.0.7
2)
UPGRADE DATABASE TO 11.2.0.3
3)
UPGRADE APPLICATION TO R12.1.13
Google Sites
Report abuse
Page details
Page updated
Google Sites
Report abuse