June 2015 archive

Jun 25

TNS-12519 w/o Max Processes Reached

I got a call from someone that they were getting TNS-12519 errors in their application. Sure enough, those messages were in the listener.log file as well. TNS-12519: TNS:no appropriate service handler found For those that aren’t familiar with this error, it typically means one of two things. Either the service name is not registered with …

Continue reading »

Jun 18

ADDM on SearchOracle.com

Here is another article I wrote for SearchOracle.com in case you missed it. This one focuses on how to use ADDM to quickly diagnose a performance problem. http://searchoracle.techtarget.com/tip/Oracle-ADDM-helps-resolve-SQL-performance-problems  

Jun 18

Which Linux Partition?

I’m trying to upgrade a system’s Grid Infrastucture to the latest/greatest version. The OUI says that I need 7GB of free space and I’m a little short. This is on virtual machines so we can grow the disk easily enough. Everything is installed in the root partition (this isn’t production) and my SysAdmin is asking …

Continue reading »

Jun 17

Oracle Certifications

I ran into a question on the forums today asking how to obtain certification information. Oracle includes this if you have a paid support contract. This blog post will show how to see certification information for an Oracle product on http://support.oracle.com for those that have access. After you sign on to My Oracle Support, click …

Continue reading »