Oracle database administration tutorial

Introduction to Oracle database administration tutorial

In this oracle database administration tutorial page, gets 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 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 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.

1. Oracle Database and Oracle Instance
2. ORA-00257
3. Enqueue
4. latches
5. Shared Pool
6. create spfile from pfile
7. create Users and Roles in Oracle database 12c
8. alter system switch logfile v/s archive log current
9. Queries to check locks in oracle database
10. Drop a datafile
11. add datafile
12. Tablespace Name ,Size ,Free space,datafiles ,growth in Oracle Database
13. shrink the datafile
14. Reserved keywords
15. Important Database Health check
16. How to login as user without changing the password in Oracle database
17. Oracle Shutdown
18. Timezone settings
19. Oracle relink
20. materialized view and Materialized View Log?
21. How to Get Materialized View’s Definition and monitor it
22. DBNEWID(nid) utility
23. DBA_JOBS facts
24. How to identify corrupts blocks in the database
25. how to find the semaphore for the Database instance
26. How to easily find the database startup and shutdown time using sqlplus
27. wait event descriptions
28. How to use Oracle logon trigger to stop login from Particular program
29. PSU patch and How to verify the PSU update in the Oracle Home and database
30. Oracle Partitioning Explained -Tables (Part -I)
31. Understanding Partitioned Indexes (Part II)
32. REGEXP string Manipulation
33. Flashback Database
34. How to find how much space is actually used by the lobsegments
35. How to delete duplicate rows from a table?
36. Oracle row migration and row chaining
37. Edition-Based Redefinition in Oracle Database 11g Release 2
38. ISM and DISM usage is Oracle
39. Oracle virtual Private database(VPD)
40. Why pinning objects into the shared pool?
41. How to grant access to v$ views
42. Parallel Query Option
43. Parallel Processing Data Dictionary views/a>
44. Parallel Processing Data Dictionary views Lesson 2
45. How to monitor transaction Rollback Progress
46. How to move LOB data to another tablespace
47. Result cache in 11g
48. ORAPWD utlity
49. How to find the database session for JVM PID
50. How to find archive log history
51. enqueue and locks Internals

Opatch

1. Opatch help
2. How to run Opatch in non interactive form

Oracle RAC Tutorial

1. Oracle database RAC
2. Instance failure and Recovery
3. Oracle Clusterware
4. voting disk
5. How to find RAC interconnect Information
6. How to add any node to RAC cluster in 10g and 11g
7. SCAN(Single Client Access Name)
8. Virtual IP Addresses(VIP)
9. why-database-not-startup-automatic in 11gR2 cluster
10. How to setup diag wait in cluster
11. How to Recreate Central Inventory in Real Applications Clusters
12. Cluster command in 10g and 11g
13. Oracle Flex Cluster 12c
14. How to change Hostname for a Grid Infrastructure Oracle Restart Standalone Configuration

RMAN Backup and Restore

1. Oracle DBA:RMAN basetables
2. RMAN and media manager software
3. How to correct error RMAN-20004
4. RMAN benefits over manual backup
5. RMAN connection decoded
6. How to create recovery catalog and register database
7. How to debug RMAN session
8. How to recover corrupt blocks using RMAN

Backup and Recovery

1. Introduction to Database backup
2. Recovering a Standby database from a missing archivelog
3. how to Flashback when we have dataguard
4. open resetlogs checks for the database
5. Oracle backup type and strategy
6. Mechanism Followed by Oracle when taking hot backup
7. What is undo and redo in Oracle
8. Oracle database recovery
9. How to recover database using Rman
10. RMAN Backup commands
11. RMAN List backup commands

Oracle ASM

1. How ASM works
2. How to prepare the Oracle ASM disks
3. Oracle ASM Diskgroups : Create and Alter diskgroup
4. ASM Best Practice to add disk to diskgroup
5. How to collect ASM metadata
6. What is raid
7. How ASM Failure Groups and CSS provides high availability
8. ASM Initialization Parameters: ASM_DISKSTRING,ASM_DISKGROUPS
9. How Oracle ASM Rebalance works
10. ASM metadata
11. How to move database to ASM storage
12. Top 5 ASM queries every DBA should know
13. 15 Awesome Oracle ASM Queries every DBA must know

Oracle Database 12c R1 and R2

1. Top 10 New Features of Oracle 12c
2. Oracle announced its new Cloud based Solaris Version 11
3. Oracle Database 12c – Multitenant Architecture
4. Oracle database 12c: Container Database (CDB) and Pluggable Database (PDB)
5. Oracle database 12c: How to Create container database
6. Oracle database 12c: How to Create Pluggable database
7. Step by Step Oracle 12c Database Installation on Linux
8. Top Oracle 12c New Features for developers
9. 5 Simple (But Important) Things To Remember About Oracle Database 12c views ,parameters and packages
10. Online move of active datafile in 12c
11. approx_count_distinct : Oracle Database 12c
12. Oracle Database Interactive Quick Reference Guide | 11g & 12c
13. Local Undo in Oracle Database 12c R2(12.2)
14. PDB Relocate in Oracle database 12c Release 2
15. Flashback PDB in Oracle Database 12c Release 2
16. Oracle Flex Cluster 12c
17. Hot PDB cloning in Oracle database 12.2
18. How to remotely clone a PDB or non-CDB in Oracle Database 12.1
19. Refreshable PDB in Oracle Database 12.2
20. Top Oracle Enterprise Manager 13c Features
21. Useful Oracle 12c pluggable database commands

General Database Related information

1. How to find the High Water mark of the Oracle Table
2. Downtime Reduction during Patching
3. How to find metadata of any objects
4. How to find table whose statistics are locked
5. AWR information
6. How to recreate redo log files
7. alert log files in 11g
8. Oracle database Flashback database
9. Oracle Advanced Queuing
10. Oracle exadata And Oracle exadata architecture
11. how to find the Oracle database version and version of various Oracle utilities

ORA errors

1. ORA-06512
2. ORA-00911
3. ORA-03113
4. ORA-29913
5. ORA-00257
6. ORA-00054
7. ORA-27154
8. ORA-01111
9. How to grant access to v$ views
10. ora-20001
11. ORA-29285
12. ORA-29280
13. ORA-29283
14. ORA-01017
15. ORA-00900
16. ORA-00001
17. Snapshot controlfile feature with RMAN and ORA-00245
18. ORA-00936
19. ORA-28000

Oracle Cloud

1. What is Cloud Computing
2. Cloud Computing Basics: iaas paas saas
3. Oracle Cloud :Infrastructure-as-a-Service Concepts
4. Identity domain Concept in Oracle Cloud
5. Must Read Oracle Database Cloud Service Overview and various options
6. Oracle E-Business Suite on Oracle Cloud Overview
7. Top FAQ about Oracle E-Business Suite on Oracle Cloud

Oracle Virtual Box

1. Step by Step instructions for Oracle Virtual Box Installation
2. Enabling Virtualization in BIOS in Laptop or Desktop for Virtualbox VM
3. How to delete Virtual Machine from VirtualBox
4. 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.