oracle database administration tutorial

Last updated on November 29th, 2016 at 09:00 pm

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.Many companies has implemented their data in Oracle. Most of them are mission critical. So Oracle database concept need to be very clear to manage these mission critical things. At the same time Oracle database needs to deliver high performance also. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

oracle database administration tutorial


Oracle Database

Oracle tutorial: Oracle Database and Oracle Instance
ORA-00257: archiver error. Connect internal only, until freed.
Memory Structure : Shared Pool decoded
Reserved keywords in Oracle
Important Database Health check
How to login as user without changing the password
Oracle Shutdown steps decoded
Timezone settings
Oracle relink
what is materialized view and Materialized View Log Lesson 1
How to Get Materialized View’s Definition and monitor it
NID Utility
Oracle DBA: DBA_JOBS facts
How to identify corrupts blocks in the database
how to find the semaphore for the Database instance
How to easily find the database startup and shutdown time using sqlplus
Most common wait event descriptions
Trigger to stop login from Particular program
What is a PSU patch and How to verify the PSU update in the Oracle Home and database
Oracle Partitioning Explained -Tables (Part -I)
Understanding Partitioned Indexes (Part II)
REGEXP string Manipulation
Flashback Database explained and limitation
How to find how much space is actually used by the lobsegments
How to delete duplicate rows from a table?
Oracle row migration and row chaining
Oracle tutorial: Edition-Based Redefinition in Oracle Database 11g Release 2
ISM and DISM usage is Oracle
Oracle virtual Private database(VPD)
Why pinning objects into the shared pool?
How to grant access to v$ views
Parallel Query Opttion
Parallel Processing Data Dictionary views Lesson 1
Parallel Processing Data Dictionary views Lesson 2
How to monitor transaction Rollback Progress
How to move LOB data to another tablespace
Result cache in 11g
All details about ORAPWD utlity
How to find the database session for JVM PID
How to find archive log history
enqueue and locks Internals


Opatch help
How to run Opatch in non interactive form

Oracle RAC

Oracle database RAC
Instance failure and Recovery
What is the Oracle Clusterware?
What is voting disk in Oracle clusterware
How to find RAC interconnect Information
How to add any node to RAC cluster in 10g and 11g
SCAN Explained
Virtual IP Addresses
why-database-not-startup-automatic in 11gR2 cluster
How to setup diag wait in cluster
How to Recreate Central Inventory in Real Applications Clusters
Cluster command in 10g and 11g


Oracle DBA:RMAN basetables
RMAN and media manager software
How to correct error RMAN-20004
RMAN benefits over manual backup
RMAN connection decoded
How to create recovery catalog and register database
How to debug RMAN session
How to recover corrupt blocks using RMAN

Backup and Recovery

Introduction to Database backup
Recovering a Standby database from a missing archivelog
how to Flashback when we have dataguard
open resetlogs checks for the database
Oracle backup type and strategy
Mechanism Followed by Oracle when taking hot backup
What is undo and redo in Oracle
Oracle database recovery
How to recover database using Rman

Oracle ASM


How ASM works
ASM lesson 1
ASM lesson II
ASM lesson III
ASM Best Practice to add disk to diskgroup
How to collect ASM metadata
What is raid
ASM : Lesson 4 Failure Groups and CSS
ASM parameters
ASM rebalance
ASM metadata
How to move database to ASM storage
ASM queries
Oracle ASM queries

Oracle Database 12c

Top 10 New Features of Oracle 12c
Oracle announced its new Cloud based Solaris Version 11
Oracle Database 12c – Multitenant Architecture
Oracle database 12c: Container Database (CDB) and Pluggable Database (PDB)
Oracle database 12c: How to Create container database
Oracle database 12c: How to Create Pluggable database

General Database Related information

Table unsed space in a ASSM tablespace
Downtime Reduction during Patching
How to find metadata of any objects
How to find table whose statistics are locked
AWR information
How to recreate redo log files
alert log files in 11g
Oracle database Flashback database
Oracle Advanced Queuing
Oracle exadata And Oracle exadata architecture

ORA errors

How to resolve ORA-06512 at line num
ORA-00911: invalid character Common Issues and Resolution
ORA-03113: end-of-file on communication channel
How to resolve ORA-29913 with external tables
How to resolve the ORA-00257 error in Oracle database
ORA-00054: resource busy and acquire with NOWAIT specified in Application
ORA-27154: post/wait create failed during startup
ORA-01111 in MRP in Standby
How to grant access to v$ views
ora-20001 in Gather schema stats on 11g(FND_HISTOGRAM_COLS)

I have given good amount of articles for oracle database administration tutorial

Please do comment me and let me know what you feel about these oracle database administration tutorial