This category contains posts about oracle errors I have encountered and some of the steps I have taken to resolve them
INTRODUCTION I was recently confronted with an error ORA-01502 error. This occurred as I was attempting to perform a DML operation on a table. Initially, I was surprised but after some digging I managed to get to the bottom of the issue. Here’s what happened. SETUP Firstly, we create a sample table, create a unique […]
BACKGROUND Working in IT is one of those things: you love it, but sometimes it can annoy the hell out of you, and that is extremely frustrating. You wake up in the morning, come to work, have plans of what you’re going to do, and then. All hell breaks loose. It can be exciting, and
The ORA-01017 invalid username/password; logon denied Read More »
I was attempting to do some work on one of the databases on a sandbox environment that had been shutdown for a few weeks; so I log on to the server, set my environment, connect as sys, issue the startup command and… I get the ORA-03113: end of file on communication channel! This was somewhat
