This post describes the procedures for Enable/Disable Oracle Disk Manager driver for Oracle Database 11g. We assume the Veritas ODM driver is already installed, mounted, and available. Follwo the steps outlined below to enable/disable ODM for Oracle database (note that with different versions of the Solaris OS, the path may change to the ODM files). […]
Oracle 11g
How to Drop Existing Temporary Tablespace and create new in Oracle 11g
A temporary tablespace is responsible for various database sorting operations. A temporary tablespace is part of the physical database files, which the Oracle control file will expect to exist under normal operations. Because the temporary tablespace doesn’t have any permanent objects stored within it, there is no change in the system change number (SCN) from […]
Real-time SQL Monitoring for Developers – Oracle Database 19c New Feature
The real-time SQL monitoring is an 11g new feature that enables DBAs to monitor the performance of SQL statements while they are executing, Please refer the following post for details. Understanding Real-Time SQL Monitoring in Oracle 11g Beginners Guide to Monitoring SQL Statements with Real-Time SQL Monitoring in Oracle Database Because a primary job duty […]
Beginners Guide to Monitoring SQL Statements with Real-Time SQL Monitoring in Oracle Database
The post explains how to use Real-Time SQL Monitoring to monitor queries. The Oracle 11g Database or later versions have a new interface to monitor long-running SQL commands. The feature is called Real-Time SQL Monitoring. By default, SQL monitoring is automatically started when a SQL command runs parallel, or when it has consumed at least […]
Understanding Real-Time SQL Monitoring in Oracle 11g
The real-time SQL monitoring is an Oracle database 11g new feature that enables you to monitor the performance of SQL statements while they are executing. Real-time SQL monitoring is automatically started when a SQL command runs in parallel or when it has consumed at least 5 seconds of CPU or I/O time in a single […]
ORA-12518: TNS:listener Could Not Hand Off Client Connection
On : 11.2.0.4 version, Clusterware, when attempting to connect to database via listener, the following error occurs: ERROR ———————– ERROR: ORA-12518: TNS:listener could not hand off client connection 15-AUG-2017 01:40:01 * (CONNECT_DATA=(CID=(PROGRAM=myapp)(HOST=__jdbc__)(USER=admin))(SERVER=DEDICATED)(SERVICE_NAME=oracle)) * (ADDRESS=(PROTOCOL=tcp)(HOST=11.22.33.44)(PORT=1521)) * establish * oracle * 12518 TNS-12518: TNS:listener could not hand off client connection TNS-12536: TNS:operation would block TNS-12560: TNS:protocol adapter […]
How to Identify Different File types and space used in Flash Recovery Area
Question: How to find out the existence of different types of files and backups available with the usage of space in the Flash Recovery Area? Starting with Oracle 10G Release 2, a new view has been made available: V$FLASH_RECOVERY_AREA_USAGE. V$FLASH_RECOVERY_AREA_USAGE shows the percentage of the total disk quota used by different types of files, and […]
Database Crashed With ORA-19815, ORA-19809, ORA-16038
The Problem Instance terminated due to error 16038 as its not able to archive the log in FRA: ORA-19815: WARNING: db_recovery_file_dest_size of 99614720000 bytes is 100.00% used, and has 0 remaining bytes available. Sat Mar 8 00:57:07 2008 ************************************************************************ You have following choices to free up space from flash recovery area: 1. Consider changing RMAN […]
Rman Backups Failing with RMAN-20004
The Problem Recovery catalog has been configured. Production Database has been cloned and a connection has been made from the clone to Catalog database using rman. DBID of the clone instance has not been changed, (so is identical with source DBID). Rman backup fails with: RMAN-00571: RMAN-00569: RMAN-00571: RMAN-03002: failure of resync command at 01/5/2009 […]
Oracle Database – How to Rename a Datafile with Special Characters Created by Mistake
Question: We have mistakenly create a datafile with special charatcers. Also we get error ORA-01516 when we try to rename it using the normal method: sql> alter database rename file ‘old_file_name’ to ‘new_file_name’; The Solution 1. Bring the Tablespace offline. sql> alter tablespace [tablespace name] offline; 2. Copy/Move the File at the OS level specifying […]