Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
Oracle Database Administration is basically for Database administration for Every DBA.
The error ORA-12541: TNS:no listener typically occurs when client cannot connect to an Oracle Database. It means the listener process is not running on the specified server and port. Here are some steps to troubleshoot and resolve this issue: Check Listener Status: Use the command lsnrctl status to check if the listener is running. If … Read more
The ORA-12154 error typically occurs when Oracle cannot resolve the connect identifier specified in your connection string. Here are some steps to troubleshoot and resolve this issue to connect session smoothly. Check the tnsnames.ora File: Ensure that the tnsnames.ora file exists in the $ORACLE_HOME/network/admin directory. Verify that the file contains the correct service name and … Read more
Here we will learn how to check shared pool free status, need to execute below SQL’s. To check shared pool free memory only. To check sga component utilization status. To check history of free shared pool free memory.
In this post we will resolve OPW-00001: Unable to open password-file. We are facing this issue while creating password file in oracle database. Error :- Solution :-1) The reason behind “OPW-00001” is normally syntax error. We have to specify the command in the proper format. In some cases we missed to mention the .ora in file … Read more
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. Fixing ORA-02020 too many database links in use. To fix the … Read more
PRCD 1119 failed to create database DEVDEB because the database unique name matches that of database DEVDEB in the first 8 characters. Identify error PRCD 1119 failed to create database. 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 … Read more
In this article, we will do Duplicate from active database using rman, we can do rman duplicate database using rman in oracle database. Duplicating oracle database from active database doesn’t require RMAN backup. Steps to restore database using duplicate from active database. RMAN can easily duplicate/restore/clone database to target database over the network without any … Read more
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 … 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 my … 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