How to start monitoring of oracle

The steps to start an Oracle listener are as follows: Check the listener status (using the lsnrctl status command) For Windows, start the "TNS Listener" service in Oracle Services Manager For Linux and Unix, use the lsnrctl start command to start the listener Run the lsnrctl status command to verify that the listener is started

How to start Oracle Listener

The Oracle listener is a daemon that listens for incoming client connection requests and routes them to the corresponding database instance. To start the Oracle listener, follow these steps:

1. Determine the listener status

Check the current listener status using the following command:

 <code>lsnrctl status</code>

If the listener is running, you will see an output like this:

 <code>LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 22-OCT-2021 17:38:03 Copyright (c) 1991, 2018, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 22-OCT-2021 17:37:52 Uptime 0 days 0 hr. 0 min. 11 sec Trace Level off Security ON: Local OS Authentication SNMP OFF</code>

2. For Windows

• Open Oracle Services Manager.
• Right-click the "TNS Listener" service.
• Select the Startup option.

3. For Linux and Unix

• Open a terminal window.
• Navigate to the Oracle home directory, usually /opt/oracle or /u01/app/oracle.
• Run the following command:

 <code>lsnrctl start</code>

4. Verify that the listener is started

Run the <code>lsnrctl status</code> command again to verify that the listener has been started successfully.

Once the listener is started, it will start listening for incoming connections and route them to the corresponding database instance based on its connection parameters.

The above is the detailed content of How to start monitoring of oracle. For more information, please follow other related articles on the PHP Chinese website!