Start and Stop oracle database from command line


Start and Stop oracle database from command line

In this Oracle tutorial we will learn how to Start and Stop oracle database from CMD (command line) in windows.



Start oracle database from CMD (command line) in windows >

C:\Users\ankitmittal01>Set oracle_sid=ORCL

C:\Users\ankitmittal01>net start oracleserviceORCL
The OracleServiceORCL service is starting...
The OracleServiceORCL service was started successfully.

Set Oracle_Sid
  • C:>set oracle_sid=ORCL
Then, type net start command.
  • C:>net start oracleserviceORCL



Stop oracle database from CMD (command line) in windows >

C:\Users\ankitmittal01>Set oracle_sid=ORCL

C:\Users\ankitmittal01>net stop oracleserviceORCL
The OracleServiceORCL service is stopping...
The OracleServiceORCL service was stopped successfully.


Set Oracle_Sid (If already set, don’t do it again)
  • C:>set oracle_sid=ORCL
Then, type net stop command.
  • C:>net stop oracleserviceORCL


So in this Oracle tutorial we learned how to Start and Stop oracle database from CMD (command line) in windows.

No comments:

Post a Comment