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 Agent is responding properly. In UNIX environments, you will have to start the Agent after the host machine is rebooted. In a Windows environment, the Agent is a Windows service and will be started automatically.
To start the Agent, you have to use the following commands: