Dead Connection Detection

Dead connection detection (DCD) is a Oracle net feature which is primarily intended for environments where clients power down their systems or client machine crashes unexpectedly without gracefully closing the connections from the Oracle database. In cases where client machine abruptly crashes with properly disconnection the sessions from Oracle databases the resources locked by such…

Troubleshooting TNS-12519 TNS-12516 ORA-12519 ORA-12516

This is a quick post to troubleshoot ORA-12519 TNS:no appropriate service handler found & ORA-12516 TNS:listener could not find available handler with matching protocol stack. Most common reasons for the ORA-12516 and ORA-12519 errors is the configured maximum number of PROCESSES and SESSIONS limitation being reached. When this occurs, the service handlers for the TNS listener become “Blocked”…

ORA-28040: No matching authentication protocol exception

This is a quick post to resolve ORA-28040 & ORA-03134, specially if you have recently upgraded to 12c. ORA-28040: No matching authentication protocol error. ORA-03134: Connections to this server version are no longer supported error. Actually from 12c the default setting for allowed logon version is 11, that means by default you can only connect…

Adding & Removing Voting Disk

This is a quick article on managing Voting Disk, the voting disk internals are explained in Voting Disk Internals post. From 11g release 2, voting disks can be stored on either on ASM diskgroups or on cluster file systems, following are the steps to add/delete/move a voting disk:- How to add a Voting Disk When voting disk…

Oracle Books

This post is to share the links for Oracle books for better understanding of Oracle Internals and other exam guides to prepare for Oracle exam. Oracle 12c Books:- OCP Upgrade to Oracle Database 12c Exam Guide (Exam 1Z0-060) OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) OCA Oracle Database 12c Installation…

Datapump Export (Everything you need to know)

This post is to describe all the clauses available with Oracle datapump export (expdp). This article assumes that the reader has basic knowledge of database administration. If not gone through yet please go through the articles Oracle datapump Architecture & Internals so that you have basic architecture understanding of datapump. Oracle 12c datapump have following clauses, which…

Queries to Monitor Datapump Jobs

This post is to cover the queries that could be used to monitor the running Datapump Jobs. Without wasting anytime just posting the methods/queries which can be used to monitor the details of the datapump jobs:- 1) Using the datapump client (expdp & impdp) STATUS command:- When the export or import job is running press +C…