problem with shutdown normal
554899Nov 15 2007 — edited Nov 21 2007I'm using Oracle Release 10.2.0.1.0 on windows XP pro SP2. When I give command shutdown normal; on sql*plus, it hangs for about 30minutes. Then message appears as follows. But when I give shutdown immediate; it is shutdown almost instantly.
SQL> shutdown normal;
ORA-01013: user requested cancel of current operation
SQL> shutdown normal;
ORA-01013: user requested cancel of current operation
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
I think its worth mention that few days back I gave a command shutdown abort; and didn't perform any media recovery after that. Probably since then this problem is occurring.
Let me know what should I do to make thing normal. Thanks in advance.