Techgoeasy

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

Oracle database administration tutorial

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 tutorials

Oracle Database

  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

  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