I have 2 problems with my database.
1. When i try to connect to my database using sql*plus some time it hangs.
2. When i logged in to my (running) database, I got database could not mount in exclusive mode.Then i killed all the oracle backgroung processes and i started up the database.I got " Connected to Idle instance". Now it is working fine.
I think you need to shut everything down, make sure no processes are running / shared memory is cleaned up, then restart as you are in an unknown state
Bookmarks