Oracle Apps Dba Training Sar
Location: Saudi Arabia
Job Description:
ORACLE R12 EBS APPS DBA
1 Oracle EBS APPS R12 Architecture
2 Installation of R12 on single node
3 Installation of R12 on multi node
4 Startup and Shutdown of Database
5 Startup and Shutdown of Applications
6 Setting and Enabling OS level environment
7 Important directories and background processes
8 TAR and SCP utilities
9 Autoconfig Utility
10 Filesystem Layout -1 (All TOPs)
11 Filesystem Layout -2 (Context files and Environment Files)
12 Adadmin Utility
Generate Applications Files menu
Generate message files
Generate form files
Generate report files
Generate graphics files
Generate product JAR files
Maintain Applications Files menu
Relink Applications programs
Create Applications environment file
Copy files to destinations
Convert character set
Maintain snapshot information
Check for missing files
Compile/Reload Applications Database Entities menu
Compile APPS schema
Compile menu information
Compile flexfields
Reload JAR files to database
Maintain Applications Database Entities menu
Validate APPS schema
Re-create grants and synonyms for APPS schema
Maintain multi-lingual tables
Check DUAL table
Maintain Multiple Reporting Currencies schema
Change Maintenance Mode
Enable Maintenance Mode
Disable Maintenance Mode
13 Rman Backup for DB
14 Datapump backup for DB
15 Full Hot backup of Oracle EBS
16 Full Cold backup of Oracle EBS
17 Cold Backup restore/cloning
18 Hot backup restore/cloning
19 Adpatch Utility with RUP level and Hotpatches
20 Submitting and monitoring Concurrent requests
21 Oracle EBS R12 Application Manager Management
22 DB & Apps Listener Management
23 Apps & DB Alert log Management
24 Running ADM reports
25 Deleting/Dropping EBS APPS R12
26 Oracle Application Manager’s System Administration – 1 (Managing Security, Users)
27 Oracle Application Manager’s System Administration – 2 (Profile Options, Responsibilities)
28 Oracle EBS R12 Performance Tuning techniques
29 OS level EBS R12 Load Monitoring and Management
30 Database level EBS R12 Load Monitoring and Management