Why do I have to bounce my database?
Hi all,
I am using Oracle 9i. Sometime it so happens that my slqplus session hangs and just won't respond. This happens when I try to log in as a user without DBA privilege or when I run a query after logging in as SYS. I can log in to the database without any such concern when i use "SYS AS SYSDBA".
I tried to restart the database and did a 'SHUTDOWN IMMEDIATE' logged in as sys and this hung too. So I opened up another session and did a 'shutdown abort' started the database in mount stage and did a shutdown immediate, started the database and there! the db responded back normally.
This is a test system and not going to affect anyone. But what if this happens in the production? Why is this happening? How did the restart help?
This is the version of Oracle I am using:
SQL> select banner from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
OS I am using is Windows - XP
listener is working fine.
Can anyone help me here please?
-Ananthram