Menu

oracle database administration tutorial

Last updated on December 17th, 2017 at 07:35 am

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

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

what is materialized view and Materialized View Log Lesson 1

How to Get Materialized View’s Definition and monitor it

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

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

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

RMAN

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

ASM Best Practice to add disk to diskgroup

How to collect ASM metadata

ASM : Lesson 4 Failure Groups and CSS

How to move database to ASM storage

Oracle ASM queries

Oracle Database 12c R1 and R2

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

Step by Step Oracle 12c Database Installation on Linux

Top Oracle 12c New Features for developers

5 Simple (But Important) Things To Remember About Oracle Database 12c views ,parameters and packages

Online move of active datafile in 12c

approx_count_distinct : Oracle Database 12c

Oracle Database Interactive Quick Reference Guide | 11g & 12c

Local Undo in Oracle Database 12c R2(12.2)

PDB Relocate in Oracle database 12c Release 2

Flashback PDB in Oracle Database 12c Release 2

Oracle Flex Cluster 12c

Hot PDB cloning in Oracle database 12.2

How to remotely clone a PDB or non-CDB in Oracle Database 12.1

Refreshable PDB in Oracle Database 12.2

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