Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
Sajid QuamerRMAN-08137: WARNING: archived log not deleted, needed for standby is a warning (not an error) from RMAN during a log deletion operation. It means that RMAN did not delete an archived redo log file because it is still required by a standby database (e.g., Data Guard standby or downstream database). Why It Happens This is … Read more
Renaming a Pluggable Database (PDB) in Oracle 19c when Transparent Data Encryption (TDE) is enabled requires extra care to preserve encryption keys and wallet configurations. Here’s a step-by-step guide to help you do it safely: Step 1: Export TDE Encryption Keys Before renaming, export the encryption keys from the source PDB. Step 2: Unplug and … Read more
AutoConfig is a tool that simplifies and standardizes configuration management tasks in an Oracle E-Business Suite. A fresh installation of Release 12 includes AutoConfig as a standard and required configuration management tool. A number of key configuration and control scripts are developed in an AutoConfig environment. AutoConfig creates several directories for these scripts and their … Read more
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
To clear the whole shared pool, you would issue the following command from a privileged user. Is flushing shared pool is good hobbit? Flush Shared pool meaning flushing cached execution plan and SQL Queries from memory. Flush buffer cache meaning flushing cached data from memory. Database bounce/restart which internally flush both shared pool and buffer … 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.
To restore tablespace including table using RMAN (Recovery Manager), we should follow these steps: 2. RMAN Backups Required for Table Recovery: 3. Restoring Specific Tablespace:
RMAN (Recovery Manager) backup solutions for Oracle databases. RMAN is a powerful tool that simplifies backup, restore, and recovery tasks. Here are the key concepts and steps to get you started: Understanding RMAN Backup Concepts: Viewing Current RMAN Configuration: Modifying RMAN Configuration Parameters: Taking Backup: To take a consistent backup of both the database and … Read more
Recently we have faced performance issue in middle tier while running report. We know that Low JVM heave memory size in Oacore may cause low performance for WebLogic domain. To increase the oacore memory in R12.We must follow the below steps. Check java default heap size in Oacore. Steps to increase oacore java heap memory. … Read more