This post summarizes on how to start, stop and to check the status of Oracle database services.
Oracle 10g
-
Oracle Listener:
To Start, execute the following command:
$ su – oracle
$ lsnrctl start
To Stop, execute the following command:
$ su – oracle
$ lsnrctl stop
- Grid Control for Database Management:
To Start, execute the following command:
$ su – oracle
$ emctl start agent
To Stop, execute the following command:
$ su – oracle
$ emctl stop agent
-
Database Control for Database Management:
To Start, execute the following command:
$ su – oracle
$ emctl start dbconsole
To Stop, execute the following command:
$ su – oracle
$ emctl stop dbconsole
-
iSQL*Plus:
To Start, execute the following command:
$ su – oracle
$ isqlplusctl start
To Stop, execute the following command:
$ su – oracle
$ isqlplusctl stop
-
Ultra Search:
To Start, execute the following command:
$ su – oracle
$ searchctl start
To Stop, execute the following command:
$ su – oracle
$ searchctl stop
-
Oracle Database:
To Start, execute the following command:
$ su – oracle
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> startup
To Stop, execute the following command:
$ su – oracle
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown
Oracle 9i
-
Oracle Listener:
To Start, execute the following command:
$ su – oracle
$ lsnrctl start
To Stop, execute the following command:
$ su – oracle
$ lsnrctl stop
-
Oracle Enterprise Manager Console:
To Start, execute the following command:
$ su – oracle
$ oemctl start oms
To Stop, execute the following command:
$ su – oracle
$ oemctl stop oms EnterpriseManagerUserName/EnterpriseManagerPassword
To Check Status, execute the following command:
$ su – oracle
$ oemctl status oms EnterpriseManagerUserName/EnterpriseManagerPassword@OEMHostName
To Ping , execute the following command:
$ su – oracle
$ oemctl ping oms
-
Oracle Database:
To Start, execute the following command:
$ su – oracle
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> startup
To Stop, execute the following command:
$ su – oracle
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown
Oracle 8i
-
Oracle Listener:
To Start, execute the following command:
$ su – oracle
$ lsnrctl start
To Stop, execute the following command:
$ su – oracle
$ lsnrctl stop
-
Oracle Database:
To Start, execute the following command:
$ su – oracle
$ svrmgrl
SVRMGR> connect internal
SVRMGR> startup
To Stop, execute the following command:
$ su – oracle
$ svrmgrl
SVRMGR> connect internal
SVRMGR> shutdown