Download ISO image for Linux 9: Step-by-Step
Please follow the below steps to download ISO image for Linux 9. 1. Login to the Oracle eDelivery site2. Select the Oracle Linux version3. Select the platform4. Accept the license…
Learn Oracle Administration best practices, configurations, and expert tips for smooth database management. Optimize performance and security today!
How to Check Archive Generation Rate in Oracle:
As a DBA, we often need to find what is the archive generation rate as a part pf the Basic Health checkups in Oracle. Today we will discuss it. Importance…
Resolve ORA-25153: Temporary Tablespace is Empty
In our daily DBA tasks, you may encounter the ORA-25153 error. Today we will discuss the same in detail how to resolve this error. Problem : ORA-25153: Temporary Tablespace is…
Resolve ORA-27086: unable to lock file – already in use
While doing your DBA tasks, you may encounter this ORA-27086 error. Today we will discuss how to resolve this error with steps in detail. First of all, it is not…
Troubleshooting ORA-03113 Error: end-of-file on communication channel
Today in this article, we will discuss how to resolve if you encounter ORA-03113 error. Let's go through this in detail. Problem : SQL> alter database open;alter database open*ERROR at…
ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
Today in this article, we will discuss about how to resolve if you encounter ORA-19802 error. Problem : SQL> alter system set db_recovery_file_dest='/oradata01/TEST1/TEST2/data/fra' scope=both;alter system set db_recovery_file_dest='/oradata01/TEST1/TEST2/data/fra' scope=both*ERROR at line…
ORA-00020: maximum number of processes exceeded
As a DBA, we often encounter the ORA-00020 error. Today we will discuss how to deal with that situation with detailed steps. Steps to resolve ORA-00020 Error : Step 1:…
Grant All Privileges to User in Oracle :
Often in our daily DBA tasks, we may get the requirement to grant all privileges to user in Oracle. Today we will learn about this. Steps to Grant All Privileges…
How to check session details in Oracle
Use the script below to find the active and inactive session details in Oracle database. It script can be used in the Oracle RAC database also. -- Adjust output formatting…
How to check session count in Oracle:
Use the script below to find out the total session count as well as the active & inactive session count in Oracle database. - Adjust formatting set linesize 700 set…