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:

DBT-50000 when using DBCA.bat on Windows (Oracle 19.11)

I’ve been having some trouble getting DBCA to run in order to create databases. Thought I’d share it with you, and thus document it for la...