INSTALLATION
Configure kernel Parameters – Oracle
Database 11g installation on Solaris
Database 10gR2 o Solaris install..
Installing Grid Agent to a target host
RMAN
RMAN – Veritas NetBackup Integration
Oracle 11gR2, RMAN, NetBackup, and the Media Layer (MML)
Duplicating a database has never been so easy! (11gR2 new feature)
Disaster Recovery..Netbackup, oracle10g
Duplicate database on Same host
Restore the RMAN backup of a RAC to a Single Instance
How To Restore RAC Database to Single Instance On Another Node
Cloning RAC ASM to non-RAC ASM
How to Duplicate a Standalone Database: ASM to ASM
RAC
Recovering ASM based OCR & Voting disk 11gR2
RMAN cold backup for RAC, how ?
Oracle RAC Load balancing and fail over
Run jobs in a particular instance using services
Simple steps to install RAC on Solaris
OPatch supported patch methods in RAC environment
TAF – Transparent Application Failover
Cloning RAC database (RAC – RAC)
Configuration example of Oracle ASM on Solaris…..
How to create ASM on Solaris Volume Manager
Monitoring
TOP 100 sql for DBA -pdf
TUNING
Tuning ‘logfine sync’ Event waits
Troubleshooting / SQL plan files
Oracle session-level performance snapshot utility
ADDM (Automatic Database Diagnostic Monitor) in 10g
How to create AWR report Manually
Ordering sequence of execution plan steps
Solve database Tuning Problems….
BACKUP & RECOVERY
RMAN Data Recovery Advisor in Oracle 11g – scenario based explanation
Data block Corruption and performing block media Recovery
RMAN backup restore and ALL SCRIPTS ….
Disaster Recovery, RMAN, (11gR2)
Dataguard Creation in 10g using RMAN
SCRIPTS
APPLICATION SERVER
Setting up OID (LDAP) for TNS resolution
Installing identity management 11gR1
OTHER
Veritas Netbackup -command line
Restoring a Database from Veritas NetBackup
Oracle Internals, Investigations, scripts
Oracle Internet Directory (OID) 11g installation….