Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

Oracle database administration tutorial

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 administration tutorials

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. latch in oracle
  4. Oracle Shared Pool
  5. create spfile from pfile
  6. create Users and Roles in Oracle database 12c
  7. alter system switch logfile v/s archive log current
  8. Queries to check locks in oracle database
  9. Drop a datafile in oracle
  10. add datafile in oracle
  11. how to check tablespace in oracle
  12. shrink the datafile in oracle
  13. Reserved keywords in oracle
  14. Oracle Database Health check
  15. How to login as user without changing the password in Oracle database
  16. Oracle Shutdown
  17. Timezone settings
  18. Oracle Relink
  19. Materialized view in Oracle
  20. How to Get Materialized View’s Definition and monitor it
  21. DBNEWID(nid) utility
  22. DBA_JOBS facts
  23. How to identify corrupts blocks in the database
  24. how to find the semaphore for the Database instance
  25. How to use Oracle logon trigger to stop login from Particular program
  26. PSU patch and How to verify the PSU update in the Oracle Home and database
  27. Oracle Partitioned table
  28. Oracle Partition Index
  29. REGEXP string Manipulation
  30. Flashback Database
  31. How to find how much space is actually used by the lobsegments
  32. How to delete duplicate rows from a table?
  33. Oracle row migration and row chaining
  34. Edition-Based Redefinition in Oracle
  35. ISM and DISM usage is Oracle
  36. Oracle virtual Private database(VPD)
  37. Why pinning objects into the shared pool?
  38. How to grant access to v$ views
  39. How to check degree of parallelism in oracle
  40. how to check parallel session in oracle
  41. How to monitor transaction Rollback Progress
  42. How to move LOB data to another tablespace
  43. Result cache in 11g
  44. ORAPWD
  45. How to find the database session for JVM PID
  46. How to find archive log history
  47. oracle locks

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. Oracle voting disk
  5. How to find RAC interconnect Information
  6. How to add any node to RAC cluster in 10g and 11g
  7. Oracle 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. Recovery Manager(RMAN)
  2. How to correct error RMAN-20004
  3. RMAN connection decoded
  4. How to create recovery catalog and register database
  5. How to debug RMAN session
  6. 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. Automatic Storage Management
  2. Oracle ASM disks
  3. Oracle ASM Diskgroups
  4. ASM Best Practice to add disk to diskgroup
  5. 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. How to move database to ASM storage
  11. 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 Multitenant Architecture
  4. Oracle Container Database (CDB) and Pluggable Database (PDB)
  5. How to Create container database
  6. 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
  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 in oracle
  4. How to find table whose statistics are locked
  5. Automatic Workload Repository
  6. How to recreate redo log files
  7. how to check alert log errors in oracle
  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 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.