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. 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. Oracle wait event
26. How to use Oracle logon trigger to stop login from Particular program
27. PSU patch and How to verify the PSU update in the Oracle Home and database
28. Oracle Partitioned table
29. Oracle Partition Index
30. REGEXP string Manipulation
31. Flashback Database
32. How to find how much space is actually used by the lobsegments
33. How to delete duplicate rows from a table?
34. Oracle row migration and row chaining
35. Edition-Based Redefinition in Oracle
36. ISM and DISM usage is Oracle
37. Oracle virtual Private database(VPD)
38. Why pinning objects into the shared pool?
39. How to grant access to v$ views
40. How to check degree of parallelism in oracle
41. how to check parallel session in oracle
42. How to monitor transaction Rollback Progress
43. How to move LOB data to another tablespace
44. Result cache in 11g
45. ORAPWD
46. How to find the database session for JVM PID
47. How to find archive log history
48. 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
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.