I am stuck with a little Oracle problem. My PC was shut down improperly after my graphics card freaked out, which caused Oracle 11g Express to not properly close down. This means that I get the above error when I try to connect. My PC has been on for 3 hours, and I still get the error, so it is safe to assume that there's something wrong.
The usual way of remedying the problem is to use the following sequence of commands from the command line:
sqlplus /nolog SQL> connect / as sysdba SQL> shutdown abort SQL> startup nomount SQL> alter database mount; SQL> alter database open;
However, when I give the shutdown command, I get the error
ORA-12560: TNS:protocol adapter error
So now, I can't mount my db. ANy help would be appreciated.