I wanted to do a small post on using the DOS command line tool ADRCI to quickly locate problems from the alert log and acting on them to fix the issue(s) when using Oracle on Windows. It should not be much different on Linux. This is a 100 level post. The call: Timeouts Another normal day … Continue reading Oracle On Windows – Simple Timeout To Crisis To Moving Data Files to Another Drive
The v$session view If you do not know already, to check who is connected and since when, what their connection status is etc., you would use dynamic view v$session. The view has the following columns: You would kill the required session by issuing Note: The IMMEDIATE option of the above command just returns control … Continue reading Oracle – My KILL’ed Session Continues To Stay On In KILLED Status, Why?
Usually, when you connect to Oracle, you get errors that give you some feedback on what is happening. Today, I ran into an issue where everything just hung. TNSPing, SQLPlus... you name it. The issue had to be connectivity related but what is it? In our case, we use an LDAP server as a directory … Continue reading SQLPlus, TNSPing & everything just hang without errors