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...
How to Troubleshoot and Fix ORA-00257: archiver error

How to Troubleshoot and Fix ORA-00257: archiver error

This post has been updated from the original content here. The ORA-00257 error is a very common Oracle database error. The error is basically trying to tell us that we have run out of logical or physical space on our ASM diskgroup, mount, local disk, or...
MySQL Error Invalid lost+found Schema

MySQL Error Invalid lost+found Schema

If within a MySQL instance a schema name such as “#mysql#lost+found” or “#lost+found” is listed when the “show schemas” or “show databases” command is run, it’s not a true schema but will appear when MySQL is installed in a...
MySQL User With wildcard and localhost Hosts

MySQL User With wildcard and localhost Hosts

There’s often confusion over why MySQL users are created with a host of localhost in addition to a user created with wildcard, %, for their host. create user ‘some_user’@’localhost’ identified by ‘some_password_here’; create...
What’s a Database Health Check?

What’s a Database Health Check?

As a critical component of your business, a healthy database is vital to staff efficiency and customer satisfaction. If you’ve neglected database maintenance and tuning, chances are you’re running into a litany of performance issues. When your database...