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…