Topics to have a touch for Oracle Apps DBA interview ( 3+ yrs ):
Linux : Basic Commands
1. ls
2. ln
3. ps ( ucx, -eaf, -fx )
4. grep
5. awk,sed
6. lsof
7. netstat
8. find
9. top, sar, vmstat
10. uptime
11. free
12. cpuinfo, meminfo
13. uname ( -a, -ms) ( 32 bit/64 bit )
14. sysctl.conf
15. hosts
16. hostame ( -i, -f )
17. mount/umount
Oracle DBA ( 10g/11g) :
1. 10g Architechture
2. Installation of Oracle 10g/11g ( Kernal Parameters significance )
3. Upgradation from 9i – 10g
4. Tablespace management
5. Backups ( Physical [Hot/Cold] , Logical [Exp/Imp/RMAN])
6. Recovery Scenarios
1. System datafile loss
2. Non-System Datafile Loss
3. Redo logfile loss
4. Table loss
7. Cloning ( Hot/RMAN )
8. Exp/Imp Options also expdp/impdp advancements
9. tkprof, explain plan, statspack, awr
10. RMAN configuration and bkps
11. Datagaurd modes/parameters/configuration
12. ASM ( concept/RAID/how to add disk group dynamically )
13. RAC basics ( Architechture/ Cmnds )
14. 11g New feautures
Oracle Apps DBA ( 11i/R12 ) :
1. Installation 11i/R12
2. 11i/R12 Architectural differences
3. Apps Patching ( Types of Patches, Reduce downtime, Issues )
4. DB Patching ( Types, Apply/Rollback, Issues )
5. Inventory ( Local/Global )
6. Concurrent Mgr ( Types, Custom Conc Mgr, PCP, Issues )
7. Forms ( Servlet/Socket, In R12 how to shift bw them, Config files in 11i/R12)
8. Apache ( Main Config files 11i/R12, Locations, Issues like 500 Internal server Error, Blank Pg, Slow etc )
9. Point Release and Major Upgrades to R12
10. Application Cloning ( Issues, Post Steps )
11. Add node
12. Custom Top Creation
13. Register Conc Prog/Form
14. Logfiles and Config files locations
15. Autoconfig ( Concept/ Templates/XML files )
- In the above listed topics some may be missing ( some are intentionally missed as they are supposed to be known to you and interviewer may not stress )
- Please suggest any more to be added.
Thanks,
Kiran
No comments:
Post a Comment