Oracle Database Concepts
Introduction to Oracle Database
Installing Oracle 10g on Windows
Oracle Database Storage Structures - Part 1
Oracle Database Storage Structures - Part 2
Oracle Database Storage Structures - Part 3
Roles and Sysdba privilege
Understanding Use of Indexes
Database Vs. Instance
Oracle Instance Memory Structure
Performance Tuning
Understanding Database Performance Tuning
High CPU usage or Load on Database Server
Tracing a User Session
Real Application Clusters (RAC)
Convert Single Instance Database to RAC Database manually
Sample Init, Listener.ora, tnsnames.ora file in RAC
General
Troubleshooting Client Connectivity Issues
Creating an HTML or Excel Format report
Scripts
Find Session level details using PID
Monitor Tablespace usage and send alert to DBA
Monitor Alert log file and send email to DBA
ORA- Errors
ORA-1017: Invalid username password
ORA-00040: active time limit exceeded
ORA-00600: internal error code, arguments: [17059]
ORA-600 [kdcrmk:columninfobuffers2]
ORA-01142: cannot end online backup
ORA-1146 signalled during: alter database begin backup
ORA-07445: exception encountered: core dump
ORA-12542: address already in use
ORA-07445: _intel_fast_memcpy
ORA-31693: Table data object failed to load/unload and is being skipped
TNS-12545: Connect failed because target host or object does not exist
TNS-03505: Failed to resolve name
