Unanswered: Service started but databse is not running
I´m struggling with a nasty problem with Oraclöe 10gR2 on a W2003 Server (VMWare!!!)
I installed the software and created an instance ervything looks o.k, the database is up and running, I created several users, tablespaces, did some imports without any problems.
I restarted the server several times and everything was working but without any changes, the windows-service for the instance is up ad running but I have no acces to the database. The service is up and running, but the instance is not started. I checked the registrykeys for this instance and the values for autostart are set to "TRUE".
Does anyone has an idea how to fix it? Maybe it´s a problemwith VMWare and Oracle???
I had the same problem on a newly created database (using 10gR2 & running on W2003) - I couldn't find out what was causing the problem, so created a scheduled windows job that ran a SQL script to startup the database. Then a couple of days later it starting behaving itself!
So, not sure how to 'cure' the problem, but it may go away on its own in a day or so - sorry I can't help more.
90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.