Connected to an idle instance
Let’s check oracle database services on Windows server.
It appeared that all oracle services are running on this Windows server.
Let’s try to connect to the database locally:
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 126.96.36.199.0 Production on Wed Oct 30 00:55:22 2019
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
“Connected to an idle instance”? It’s confusing. The statuses between above two are inconsistent. What happened?
The reasons to the inconsistency could be:
- Someone shut it down manually by SQL or RMAN command without notifying DBA.
- Instance shutdown itself for some reason.
You can just startup the instance either by SQL command or Windows Services.
This would be a little complicated because the running instance decided to shutdown itself due to some severe incidents.
By the way, if you tried to connect to the stopped database from an outside client, the listener could refuse to establish the connection. In such moment, you have to know how to connect to an idle database remotely.