Oracle database administration tutorial Last updated on October 8th, 2019 at 06:10 pmAn 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 Oracle tutorial: Oracle Database and Oracle Instance ORA-00257: archiver error. Connect internal only, until freed. Enqueue latches Memory Structure : Shared Pool decoded How to create spfile from pfile How to create Users and Roles in Oracle database 12c alter system switch logfile v/s archive log current Queries to check locks in oracle database How to Drop a datafile from Tablespace in Oracle How to add datafile to tablespace in Oracle Tablespace Name ,Size ,Free space,datafiles ,growth in Oracle Database How to shrink the datafile in Oracle Reserved keywords in Oracle Important Database Health check How to login as user without changing the password in Oracle database Oracle Shutdown steps decoded Timezone settings Oracle relink what is materialized view and Materialized View Log? How to Get Materialized View’s Definition and monitor it How to change the DBNAME /DBID using DBNEWID(nid) utility for Oracle database Oracle DBA: DBA_JOBS facts How to identify corrupts blocks in the database how to find the semaphore for the Database instance How to easily find the database startup and shutdown time using sqlplus Most common wait event descriptions How to use Oracle logon trigger to stop login from Particular program What is a PSU patch and How to verify the PSU update in the Oracle Home and database Oracle Partitioning Explained -Tables (Part -I) Understanding Partitioned Indexes (Part II) REGEXP string Manipulation Flashback Database explained and limitation 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 Oracle tutorial: Edition-Based Redefinition in Oracle Database 11g Release 2 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 Parallel Query Opttion Parallel Processing Data Dictionary views Lesson 1 Parallel Processing Data Dictionary views Lesson 2 How to monitor transaction Rollback Progress How to move LOB data to another tablespace Result cache in 11g All details about ORAPWD utlity How to find the database session for JVM PID How to find archive log history enqueue and locks Internals Opatch Opatch help How to run Opatch in non interactive form Oracle RAC Oracle database RAC Instance failure and Recovery What is the Oracle Clusterware? What is voting disk in Oracle clusterware How to find RAC interconnect Information How to add any node to RAC cluster in 10g and 11g SCAN Explained Virtual IP Addresses 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 Oracle DBA:RMAN basetables RMAN and media manager software How to correct error RMAN-20004 RMAN benefits over manual backup 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 How ASM works How to prepare the Oracle ASM disks Oracle ASM Diskgroups : Create and Alter diskgroup ASM Best Practice to add disk to diskgroup How to collect 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 ASM metadata How to move database to ASM storage Top 5 ASM queries every DBA should know 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 Database 12c – Multitenant Architecture Oracle database 12c: Container Database (CDB) and Pluggable Database (PDB) Oracle database 12c: How to Create container database Oracle database 12c: 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 12c 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 How to find table whose statistics are locked AWR information How to recreate redo log files alert log files in 11g Oracle database Flashback database Oracle Advanced Queuing Oracle exadata And Oracle exadata architecture how to find the Oracle database version and version of various Oracle utilities ORA errors How to resolve ORA-06512 at line num ORA-00911: invalid character Common Issues and Resolution ORA-03113: end-of-file on communication channel How to resolve ORA-29913 with external tables How to resolve the ORA-00257 error in Oracle database ORA-00054: resource busy and acquire with NOWAIT specified in Application ORA-27154: post/wait create failed during startup ORA-01111 in MRP in Standby How to grant access to v$ views ora-20001 in Gather schema stats on 11g(FND_HISTOGRAM_COLS) How to resolve ORA-29285: file write error How to Solve ORA-29280: invalid directory path How to solve ORA-29283 : invalid file operation ORA-01017: invalid username/password; logon denied Tips How to resolve ORA-00900 ORA-00001 unique constraint violated Snapshot controlfile feature with RMAN and ORA-00245 How to resolve the ORA-00936 missing expression How to solve ORA-28000 the account is locked Oracle Cloud What is Cloud Computing Cloud Computing Basics: iaas paas saas Oracle Cloud :Infrastructure-as-a-Service Concepts Identity domain Concept in Oracle Cloud Must Read Oracle Database Cloud Service Overview and various options Oracle E-Business Suite on Oracle Cloud Overview Top FAQ about Oracle E-Business Suite on Oracle Cloud 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