Guys before you start cursing me "Search the goddamn form" "google before you post"
I have done all that for the past 1 week. I am simply not able to find a solution for this problem
What All I have done by searching the forums
I have verified the listener file. No trailing slashes are there, I have verified the SID. It has been set properly. Home is also set properly. TNSNAMES.ora file is correct. Has all apt values. SQLNET.ora is verified. No issues with that.
I have cleared the eventviewer (Yes one of the forums listed that eventviewer being full can also cause this error), I have sufficient disk space.
Oracle service starts and listener service starts without any issues. But if I try to login I get this error.
I have tried restarting the services, I have tried restarting the machine itself.
C:\Documents and Settings\user>set oracle_sid=qa01
C:\Documents and Settings\user>sqlplus sys/oracle as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Sun Aug 15 21:40:09 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
C:\Documents and Settings\user>sqlplus sys/oracle as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Sun Aug 15 22:29:14 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> select file#, name from v$datafile;
select file#, name from v$datafile
*
ERROR at line 1:
ORA-01034: ORACLE not available
When I login
C:\Documents and Settings\user>sqlplus system/<password>@qa01
SQL*Plus: Release 10.2.0.3.0 - Production on Sun Aug 15 21:01:49 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
I have tried running startup command from nolog. It says database mounted successfully, still I am not able to loginto my instance. shutdown immediate does not work. It says TNS ADAPTER error or somethign.
I once faced a simmilar issue and this was related to a DBF file being deleted and oracle was not able to find it. After issuing drop commands (alter database datafile 13 offline drop;) I was able to start the database. Any help will be greatly appreciated.
Thanks,
Santhosh
P.S - I am running a VM machine with Win 2003 32 bit