Startup and Shutdown

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

Posted on
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 Production on Wed Oct 30 00:55:22 2019 Copyright (c) 1982, 2016, Oracle.  All rights reserved. […]

How to Open Port on Windows Server

Posted on
After our Oracle database 12.2 has been created on Windows server, we should open port 1521 on firewall for incoming connections. For Linux, you can refer to : How to Open Ports and Survives from Reboots Use ⊞ Win + F to search for “Windows Firewall with Advanced Security”, then click it. In “Inbound Rules”, […]