Startup and ShutdownWindows Server

How to Resolve “Connected to an idle instance” on Windows

Connected to an idle instance

Let’s check oracle database services on Windows server.

Oracle Services are Running on Windows
Oracle Services are Running on Windows

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 12.2.0.1.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:

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.

Leave a Reply

Your email address will not be published. Required fields are marked *