The advice on the web is to wait a while until Oracle has time to startup properly, which can take a while. The admin tools won't connect either. But if after waiting and waiting it still doesn't work, you may need to get out the crow bar.
I got a bit further with the info from this posting:
(from OS command prompt)
sqlplus /nolog
(then at SQL prompt)
shutdown
(get message saying database is not open)
startup
The last startup command will often get things going. OR it will tell you why it's so darn unhappy. In my case there's some old database it's trying to access that is no longer on the disk.
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01110: data file 11: 'D:\ORACLE_DATA\CUSTOMER\DB.ORA'
For me that's an obsolete database, so now I just need to find the command to tell Oracle to not worry about it. More later...
Comments