Database Security Best Practices for Technical DBA

Database Security Best Practices for Technical DBA

As a database administrator (DBA), maintaining the security of your organization’s data is one of your most important responsibilities. Unfortunately, data breaches and other security incidents are too common in today’s digital age, and the consequences...
ORA-04031: Unable to Allocate nn Bytes of Shared Memory

ORA-04031: Unable to Allocate nn Bytes of Shared Memory

The Oracle error ORA-04031: unable to allocate nn bytes of shared memory is telling us that Oracle tried to allocate a specific amount of memory for a process and it was unable to do so. I see this more often with legacy or very large and complex ETL processes. The...
ORA-12560 Error Message TNS Protocol Adapter Error

ORA-12560 Error Message TNS Protocol Adapter Error

This post has been updated from the original content here. When getting an ORA-12560 for an Oracle database on windows, there are a couple of things we should check before doing anything else. The error is telling us that we are trying to connect to the wrong...