Re: OracleOraHome9iTNSListener, OracleOraHome9iAgent batch file ?

> These services are started at boot time:
> OracleOraHome9iAgent

This service is Oracle's Intelligent Agent. It is primarily used by Oracle Enterprise Manager for job scheduling and event notification. If you are not using OEM, you can turn this service off. This does not need the instance to be running.

> OracleOraHome9iTNSListener

This is Oracle's listener. Without it, remote connections are not possible. The instance does not need to be running for this service to start.

> OracleServiceGENERAL

This is your Oracle instance. If you want your instance to startup when you reboot your machine set this to AUTOMATIC. If you manually want to start your instance, set this to MANUAL.  

As far as being services, each of these are independent of each other. However, without the listener remote connections to your database are not possible. Without the instance running, remote clients can "hit" the listener but will receive a message stating that Oracle is unavailable.

HTh,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"