Tuesday, April 05, 2016

ERROR: ORA-01033: ORACLE initialization or shutdown in progress

I recently ran across this error, which led me to this article in DBForums.
Unfortunately, it's been a while and I can't figure out my login, so I'm posting this here.

In my case, it was very definitely a user error :(
This was Oracle 12c, local development database on my laptop.
Because of space constraints, I had moved the USER tablespace to an external drive, and then forgot about it!

Oracle very happily started up and gave no visible objection, but when I tried to connect, it have this message.

So, long story short, if you get this, check that you can connect to all of your Oracle data files!

Happy databasing ;-)

No comments:

The Database is not accessible after creating Always On Availability Group

 Having created a fully functional SQL Server Always On Availability Group, I connect using SSMS. Upon trying to expand the database, I get ...