Oracle DBA Blog for sharing best practices, code examples and innovative solutions. Focusing Specifically on Oracle performance and optimization issues, Oracle Indexes, Database and EBS Administration.
Oracle Database Administration is basically for Database administration for Every DBA.
ORA-02020 too many database links in use means that the database limits the number of open database links on every session. You can increase the parameter for later use. For example, after opening 9 db links, we failed to open the 10th db link. How to fix ORA-02020 too many database links in use. To … Read more
Introduction: – PRCD 1119 failed to create database DEVDEB because the database unique name matches that of database DEVDEB in the first 8 characters. Identify error. While trying to create CDB using dbca, recently we faced error PRCD-1119. Here will cover how to resolve it. As we can see, the error is clearly visible in … Read more
Introduction:- In this article, we will discuss How to drop oracle database while doing cloning, refreshing we need to follow the below steps to complete. Connect oracle database using sys user with sysdba and check whether database open in read write mode. How to drop oracle database. Here we will check and ensure the right … Read more
Introduction:- In this article, we are going to resolve ORA-12547 TNS lost lost contact error. Error:- ORA-12547: TNS:lost contact $ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 25 09:38:40 2021 Copyright (c) 1982, 2013, Oracle. All rights reserved. ERROR: ORA-12547: TNS:ost contact Above error can occur for many reason. In … Read more
Introduction:- In this article we will learn how to resolve the ORA 39213 metadata processing is not available error while trying to export the table in oracle using dataPump utility. Using Datapump utility we can export/import any database objects in oracle. While doing the facing error ORA 39213 metadata processing. Exporting table using DataPump. $expdp … Read more
Introduction:- Basically Backup compress full incremental backup is the feature of Oracle Database which offer more benefit. We can take the oracle rman backup as normal or in compress mode. Restoration process of compressed backup will same as uncompressed backup. Compress Full Incremental backup using RMAN:- Incremental backups can be either level 0 or level … Read more
In this article, we will cover how to recompile invalid objects in oracle database. If Oracle objects package, procedure, function, trigger and views become invalid when dependent object has changed. How to find invalid objects in oracle Check how many invalid objects in oracle database. SQL>select owner,object_name,status,object_type from dba_objects where status=’INVALID’; SQL>select object_name,status from dba_objects where … Read more
Introduction: – RMAN Backup And Recovery Interview Questions| Here is useful RMAN Backup and Recovery Interview Questions/Answers for DBA. Below are oracle rman interview questions. Q⟹ What is RMAN? A⟹RMAN is an Oracle Database client that performs backup, restoration,recovery and administrative tasks in oracle Database. It greatly simplifies the dba jobs by managing the production … Read more
Introduction: – As we know that Oracle introduced multitenant Container Database CDB and Pluggable database PDB Backup and Recovery in 12c. Using RMAN client we can perform the backup of entire Container Database (CDB) or individual Pluggable Database (PDB) and also perform the point-in- time recovery. Before starting the RMAN backup, we should … Read more
In this article we will discuss how to move datafile online in oracle. We know that Oracle introduced moving datafiles online in 12c to minimize the downtime. Prior to oracle 12c, required taking datafile offline and copy it at OS level and bring it back online again. Oracle 12c includes an enhancement to ALTER DATABASE … Read more