I'm definitely not an Oracle DBA, but I have a few databases in my lab that I use frequently. I had to restore my main Oracle DB VM from a backup and now I can't connect. I get this error:
An error was encountered performing the requested operation:
ORA-01033: ORACLE initialization or shutdown in progress
01033. 00000 - "ORACLE initialization or shutdown in progress"
*Cause: An attempt was made to log on while Oracle is being started up
or shutdown.
*Action: Wait a few minutes. Then retry the operation.
Vendor code 1033
I've seen that error a dozen times, so I figured I just needed to get things all started up. But once I get the services started, mounted, and open...I still get the error.
I have a CDB and a regular DB on the server. The SIDs are CDBORCL and ORCL. Here's what I get when I start it up:
C:\Users\hypservice>set ORACLE_SID = orcl
C:\Users\hypservice>sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 1 06:39:34 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect / AS SYSDBA
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 5133828096 bytes
Fixed Size 3056280 bytes
Variable Size 1056968040 bytes
Database Buffers 4060086272 bytes
Redo Buffers 13717504 bytes
Database mounted.
Database opened.
SQL>
No issues mounting...
SQL> select status, database_status from v$instance;
STATUS DATABASE_STATUS
------------ -----------------
OPEN ACTIVE
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL>
Everything shows OPEN, ACTIVE, and READ WRITE. So what am I missing? I've searched and searched prior to adding another "can't connect" post... Thanks in advance!