Connected to an idle instance Actually, Connected to an idle instance is a message rather than an error, it indicates that the database you entered… Read More »How to Resolve "Connected to an idle instance"
The goal in this post is to install an Oracle database 12.2 on windows server 2012. Here we separate our job into 2 major steps:… Read More »How to Install Oracle Database 12.2 on Windows Server
Whenever you'd like to check disk free space by command prompt in Windows, you can use examples as below: Print datetime C:\Users\edchen>echo Check Time: %date%… Read More »How to Check Disk Free Space Command Prompt in Windows
Here is a quick glance at the default locations of SPFILE and PFILE in different platforms. For instance, Linux and Windows. For Linux/Unix SPFILE <ORACLE_HOME>/dbs/spfile<ORACLE_SID>.ora… Read More »The Default Location of SPFILE and PFILE for Linux and Windows
In my case, I plan to use SPFILE to startup the database instance which used to use a known PFILE to open. But the problem… Read More »How to Point to SPFILE in PFILE to Trick Scripts
A runtime error thrown by Windows is as below when I was starting an application program: The Program can't start because MSVCR110.dll is missing from… Read More »How to Resolve MSVCR110.dll is missing from your computer
Before enabling remote desktop service, please make sure you are a member of Administrators group. The way how to check account information can be followed in… Read More »How to Allow Remote Desktop Connections on Windows
If you are not sure what capabilities of current account can do on Windows 7 or 8, you can use the following command to show… Read More »How to Show Account Information on Windows in Command Line