Common Oracle commands

Oracle uses the following command line in windows:
Net startOracleserviceorcl // start the ORACLE service [oracleserviceorcl is the actual service name]
Net stopOracleserviceorcl // stop the ORACLE service
Net startOracleoradb10g_home1tnslistener // start the ORACLE listener service
Net stopOracleoradb10g_home1tnslistener // stop the ORACLE listening service
Net startOracledbconsoleorcl // start the ORACLE console service (EM)
Emctl startDbconsole // start the ORACLE console service (EM) (the function is the same as the command above)
Net stopOracledbconsoleorcl // stop the ORACLE console service (EM)
Emctl stopDbconsole // stop the ORACLE console service (EM) (same command)

Common service names are as follows (if ORCL is ORACLE_SID at installation ):

　　

 

Lsnrctl [start | stop | status]//StartListener: Stop the listener and view the listener status;
Tnsping <tns name>// Test whether tns can be connected successfully
Net [start | stop]Oracleserviceorcl // start the Database Service

Example:

E: \> lsnrctl status // check the listener status:
E: \> net start OracleServiceORADB // start the Database Service
E: \> sqlplus/Nolog
SQL> connSystem/qqqqqq @ oradb as sysdba
SQL> exit

E: \> oemapp console
E: \> net stop OracleServiceOEMREP // stop the Database Service