sqlplus / as sysdba hung state

[Former Member]

Hi All,

When we try to do a sqlplus / as sysdba it gets into hung state.

sapkxqap03:oraqs9 2> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Feb 16 19:06:28 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

We dont get anything after this prompt.Is there a way we can get to know as to what might be the issue.Thanks.

[stefan_koehler · Accepted solution]

Hello Ambarish,

logon to your database with "prelim" option and create a hanganalyze trace and a systemstate dump.

http://tech.e2sn.com/oracle/troubleshooting/hang/how-to-log-on-even-when-sysdba-can-t-do-so

After that check these files or upload them to a file hoster so that we can check them.

Regards

Stefan

[Former Member · Accepted solution]

HI Stefan,

That was simply too good.Finally the issue got resolved by box restart.I dont know why we faced an issue?Its a mystery.The solution proposed by you was simply too good.Thanks.