Starting and stopping the repository database

As discussed earlier, the Oracle Management Repository is an Oracle database that stores information about the managed targets. You may need to start/stop the repository database. If you are using Windows then you can start/stop the Windows service to start/stop the DB instance.

However, here are the commands to start the repository database in a UNIX environment:

setenv ORACLE_HOME /scratch/OracleHomes/db10g
setenv ORACLE_SID emrep
setenv PATH $ORACLE_HOME/bin:$PATH
sqlplus /nolog
SQL*Plus: Release 10.1.0.4.0 - Production on Mon Apr 20 14:28:37 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect sys as sysoper
Enter password:
Connected to an idle instance.
SQL> startup

The Oracle database is automatically restarted when you reboot the host machine; you do not have to restart the database repository.

Starting and stopping the Agent

Finally, we will discuss how to start/stop the Agent, and how to verify whether the...