Luke Smith

Oracle/MySQL/Linux Technical Lead and Delivery Manager

Luke’s background in IT reaches back to the late ‘90s. Working with Oracle for nearly 20 years, Luke’s climb up the tech ladder started at helpdesk. He went on to learn PL/SQL application development, and eventually, mastered database administration and management. He has been with XTIVIA for 8 years and currently leads both the Oracle and MySQL Database teams. He is an Oracle Database 10-11g Administrator Certified Professional, an Oracle Application Server: 10g Certified Associate, and an Oracle PS/SQL Developer Certified Associate, to name just a few of his qualifications. Luke moves his teams forward in his high sales record, always pushing for positive changes to improve best practices. He refines DBA processes to maximize efficiency. Acknowledging both sides of the fence, he makes XTIVIA better for both customers and employees. In his spare time, Luke plays online PC gaming and DnD and is also an avid car enthusiast. When the weather's nice, he rebuilds race cars in his garage with his wife.

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... read more

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... read more

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... read more

Database vs Instance vs Schema vs User

Today I wanted to talk about some terminology that applies to multiple database platforms, however, I want to talk specifically to how it relates to the Oracle RDBMS. These four words seem to cause a lot of confusion and are often misused. The specific terminology or... read more

ORA-01017: Invalid Username/Password; Logon Denied

The Oracle ORA-01017: Invalid Username/Password; Logon Denied is an error that comes up pretty frequently it can be caused by several things, though most of the time it’s simply just the wrong password being used. One thing that we should check if we’re... read more

How to Fix ORA-12560: TNS: Protocol Adapter Error

When you see this ORA-12560 error on Windows, you need to check these two things before anything else. Make sure the windows service is up and running Make sure your ORACLE_SID is set to the instance name you’re trying to connect to If either one or two are not... read more