Command Prompt (CMD)

How to Install Oracle Database 19c on Windows

by Ed Chen
April 6, 2022May 10, 2022

Extract Oracle Home 19.3 Image Since release 18c, all database software installation packages become image-based to reduce installation time, so we start the procedure from… Read More »

How to Install Oracle Client Home on Windows

by Ed Chen
December 15, 2021April 7, 2022

Oracle client home 19c is an image-based installer which is required to be directly uncompressed into Oracle Client Home, then setup itself and register with… Read More »

How to Resolve "Connected to an idle instance"

by Ed Chen
November 9, 2019October 1, 2021
6 Comments

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 CMD Check Free Disk Space

by Ed Chen
April 1, 2018October 3, 2021

Free Disk Space in Windows Whenever you'd like to check disk free space by command prompt in Windows, you can use examples as below: Print… Read More »

How to Execute SQL Statements in One CMD Line

by Ed Chen
June 3, 2016August 22, 2018

If your query contains just only one statement, you can do this:C:Usersed>echo select name from v$database; | sqlplus scott/tiger@orclWhen the query is finished, the command… Read More »

How to Show Account Information on Windows in Command Line

by Ed Chen
August 28, 2014May 17, 2019

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 Open Command Prompts with Administrator Privileges (Elevated Mode) on Windows

by Ed Chen
August 27, 2014February 27, 2021

For opening command prompts in elevated mode, you must be a member of Administrators group. The way how to check account information can be found in… Read More »