Managing Oracle database services

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

Leave a Comment

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.