[Oracle] management of Oracle9i service under Windows: Builder.comWednesday, June 30 2004 6:35 PM
Many services are installed when you install Oracle 9i under Windows operating systems - and some of them are configured to start when Windows starts. When Oracle is running under Windows, it consumes a lot of resources, and some services may not always need. You will find that you can quickly and completely shut down the database without using the Windows graphics interface. As long as you have administrator privileges, you can start a service via Net Start, or stop a service via the NET STOP command, thereby controlling any of the following services. In Windows XP, you can double-click a service to view its properties by changing the startup type parameters you want to disable in the service (OracleraHome ...) of the control panel. For manual. Make the database in the local work The only service that needs to run is an OracleServiceorCL service (where ORCL is SID). This service will automatically launch and stop the database (interrupted using Shutdown). If a database is installed, its default start type is automatic. If it is mainly to access a remote database, the start type can be changed manually. OracleraHome92httpserver service (OraHome92 is the name of Oracle Home) is an Apache server that is automatically installed when you install Oracle. Under normal circumstances we use it to access Web pages under Oracle Apache directories, such as JSP or ModPLSQL pages. OracleraHome92TnsListener Services is only required when the database needs to be remotely accessed (whether through another host or local through the SQL * NET network protocol is remote access). You can access your local database without this service. OracleraHome92ClientCache service cache Oracle Names data for connecting the remote database. Under normal circumstances, the startup type of the service is configured to manually. However, unless there is an Oracle Names server, it is not necessary to run this service. There are four services that are necessary for Oracle Enterprise Manager, which is: OracleraHome92Agent (Smart Agent), the service monitoring database, and an enterprise manager request, the default start type is automatic. OracleraHome92Snmppeerencapsulator and OracleoraHome92Snmppeermasteragent, handle security network management protocol services. OracleraHome92PagingServer makes a warning through a digital pager or email using a modem. OracleMTSRecoveryService is optional that allows the database to act as a Microsoft transaction server, COM / COM object, and resource manager for transactions in a distributed environment. If you just use the database occasionally, you can create a simple script task to start and close the server, so that you can use the script every time you can use the graphical interface. 1. Save a shortcut to automatically load these files. 2. Set the Oracle service to manually avoid starting at Windows startup.
