Command Prompt (CMD)

How to Install Oracle Client Home 21c on Windows

by Ed Chen
December 5, 2022October 27, 2022

Oracle client home 21c 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 Install Oracle Database 21c on Windows

by Ed Chen
September 19, 2022March 20, 2023

For Oracle database 19c installation on Windows, you may go for it. Extract Oracle DB Home 21.3 Image Since release 18c, all database software installation… Read More »

How to Install Oracle Database 19c on Windows

by Ed Chen
April 6, 2022March 20, 2023

For Oracle database 21c installation on Windows, you may go for it. Extract Oracle DB Home 19.3 Image Since release 18c, all database software installation… 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, 2019December 10, 2022
16 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 »