Introduction to Oracle database administration tutorial
This oracle database administration tutorial page gets you to relevant links to content on this website. It could also prove to be helpful even if you are already a DBA or if you want to become one.
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 a key to solving the problems of information management. Many companies have implemented their data in Oracle. Most of them are mission-critical. So Oracle database concept needs 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 Tutorial
Given below is the list of oracle dba tutorials. These tutorials are detailed in nature and a must-read if you are looking for a career as a DBA.
- Oracle Database and Oracle Instance
- ORA-00257
- latch in oracle
- Oracle Shared Pool
- create spfile from pfile
- create Users and Roles in Oracle database 12c
- alter system switch logfile v/s archive log current
- Queries to check locks in oracle database
- Drop a datafile in oracle
- add datafile in oracle
- how to check tablespace in oracle
- shrink the datafile in oracle
- Reserved keywords in oracle
- Oracle Database Health check
- How to login as user without changing the password in Oracle database
- Oracle Shutdown
- Timezone settings
- Oracle Relink
- Materialized view in Oracle
- How to Get Materialized View’s Definition and monitor it
- DBNEWID(nid) utility
- DBA_JOBS facts
- How to identify corrupts blocks in the database
- how to find the semaphore for the Database instance
- How to use Oracle logon trigger to stop login from Particular program
- PSU patch and How to verify the PSU update in the Oracle Home and database
- Oracle Partitioned table
- Oracle Partition Index
- REGEXP string Manipulation
- Flashback Database
- 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
- Edition-Based Redefinition in Oracle
- 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
- How to check degree of parallelism in oracle
- how to check parallel session in oracle
- How to monitor transaction Rollback Progress
- How to move LOB data to another tablespace
- Result cache in 11g
- ORAPWD
- How to find the database session for JVM PID
- How to find archive log history
- oracle locks
Opatch
Oracle RAC Tutorial
- Oracle database RAC
- Instance failure and Recovery
- Oracle Clusterware
- Oracle voting disk
- How to find RAC interconnect Information
- How to add any node to RAC cluster in 10g and 11g
- Oracle SCAN(Single Client Access Name)
- Virtual IP Addresses(VIP)
- 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 Flex Cluster 12c
- How to change Hostname for a Grid Infrastructure Oracle Restart Standalone Configuration
RMAN Backup and Restore
- Recovery Manager(RMAN)
- How to correct error RMAN-20004
- 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
- RMAN Backup commands
- RMAN List backup commands
Oracle ASM
- Automatic Storage Management
- Oracle ASM disks
- Oracle ASM Diskgroups
- ASM Best Practice to add disk to diskgroup
- ASM metadata
- What is raid
- How ASM Failure Groups and CSS provides high availability
- ASM Initialization Parameters: ASM_DISKSTRING,ASM_DISKGROUPS
- How Oracle ASM Rebalance works
- How to move database to ASM storage
- 15 Awesome Oracle ASM Queries every DBA must know
Oracle Database 12c R1 and R2
- Top 10 New Features of Oracle 12c
- Oracle announced its new Cloud based Solaris Version 11
- Oracle Multitenant Architecture
- Oracle Container Database (CDB) and Pluggable Database (PDB)
- How to Create container database
- 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 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
- Top Oracle Enterprise Manager 13c Features
- Useful Oracle 12c pluggable database commands
General Database Related information
- How to find the High Water mark of the Oracle Table
- Downtime Reduction during Patching
- How to find metadata of any objects in oracle
- How to find table whose statistics are locked
- Automatic Workload Repository
- How to recreate redo log files
- how to check alert log errors in oracle
- Oracle database Flashback database
- Oracle Advanced Queuing
- Oracle exadata And Oracle exadata architecture
- how to find the Oracle database version
ORA errors
- ORA-06512
- ORA-00911
- ORA-03113
- ORA-29913
- ORA-00257
- ORA-00054
- ORA-27154
- ORA-01111
- How to grant access to v$ views
- ora-20001
- ORA-29285
- ORA-29280
- ORA-29283
- ORA-01017
- ORA-00900
- ORA-00001
- Snapshot controlfile feature with RMAN and ORA-00245
- ORA-00936
- ORA-28000
Oracle Virtual Box
- Step by Step instructions for Oracle Virtual Box Installation
- Enabling Virtualization in BIOS in Laptop or Desktop for Virtualbox VM
- How to delete Virtual Machine from VirtualBox
- Pre-Built Oracle database for learning and testing using Oracle Developer VM
We really hope you like this oracle database administration tutorial. Please like or share if the content helped you in any way.