Command Prompt (CMD)

How to Install Oracle Database 21c on Windows

by Ed Chen
September 19, 2022September 19, 2022

Extract Oracle DB Home 21.3 Image Since release 18c, all database software installation packages has become image-based to save installation time, so we start the… Read More »

How to Install Oracle Database 19c on Windows

by Ed Chen
April 6, 2022September 13, 2022

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

How to Install Oracle Client Home 19c on Windows

by Ed Chen
December 15, 2021October 19, 2022
2 Comments

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, 2019November 10, 2022
12 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, 2014October 20, 2022

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 »