In this article, we are going to learn how to create a rman restoration script with a set newname parameter. If you try to restore the database on another server using RMAN and the directory structure is different, you can use the below query for restoration. In my case my …
In this article, we will show you how to find redo log members, redo log file size, and redo log status using some simple commands. You can subscribe my YouTube Channel Click Here Step 1. Find redo log file members and group details. Output from above query: Read: How to …
Read moreFind redo log members, redo log file size and redo log status
In this article, we are going to reconfigure oracle restart step by step. Why we need to reconfigure the oracle restart. Actually, in my organization, they rename the server name, if the server renamed and rebooted the ASM instance failed showing error ORA-29701 unable to connect to cluster synchronization service. …
Today I’m just performing the database full backup and suddenly I’m facing an ORA-19502 error message. I didn’t understand why this error came because I did not see any ora error in the alert file. I’m suffering on google but didn’t get any solution then I just checked my mount …
This tutorial from oracle 11g, and we are going to learn how to configure OEM dbconsole manually on the Linux platform. If you previously configured the OEM console but it is not working. So, we need to drop the existing configuration and recreate the OEM repository, start configuration using the …
In this article, we are going to learn how to drop oracle database manually step by step. Perform these steps in UAT first don’t perform on the production database server. How to Create Pluggable Database Oracle Prerequisites Before taking any action you must know the location of datafile, controlfile and …
Actually, in today’s session I am facing the error TNS-00583 Valid Node Checking first time in my career, and unable to find the proper solution. Then I’m suffering on Google and find one solution on oracle support which I am going to discuss with you. Doc-id 1680353.1 ORA-00031: session marked …
Read moreTNS-00583: Valid Node Checking: Unable To Parse Configuration
In this tutorial we will learn how to solve ORA-00031 session marked for kill error. Step 1. Login in Database with administrator (sys) user and find spid to kill at os level. If you have the user details which find the details as per user name using below query. In …
Hello Friends, in this article we are going to learn how to install oracle 19c on OEL 7) step by step. In this installation, we use the oracle-database-preinstall-19c package. Creating Non CDB database in silent mode – ORACLE 19C OS Version OS version which we are going to use in …
Hello guys, in this article we are going to learn how to install, configure and use statspack in oracle. In this activity, I’m going to use the Oracle 12c environment. Introduction to Statspack If the DB server running very slow, then we need to perform DB tuning and it is …
Read moreHow to install, configure, and use Statspack in Oracle