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