Skip to content
Skip to content
 

Managing 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

  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • Add to favorites
  • email
  • LinkedIn
  • Live
  • MySpace
  • StumbleUpon
  • Twitter
  • Yahoo! Bookmarks