Luke Smith

Oracle/MySQL Lead DBA & 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 5 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, Lisa.

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

Oracle ORA-01017 Quick Fix The ORA-01017 error seems pretty straight forward, however it can have us banging our heads against our desks for awhile trying to figure out why we can’t seem to type our password in correctly. Here are a few reasons I have personally... read more

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

How to fix ORA-04031 Error As the error states, the system tried to allocate so much shared memory and there was none to allocate. This usually happens when you’re running a rather large package and your shared pool isn’t sized to handle it. I would do one... 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

Oracle ORA-00604: Error Occurred at Recursive SQL Level String

This error is rather common; however, the following error is the error that needs to be resolved. Below you can see several of these errors and their associated error that needs to be resolved. Each of the following errors has their own resolutions. Here the variable... read more