The listener is a separate database server process that runs locally on the database server or remotely on the Oracle RAC environment. When a client request comes, the listener first receives it.
And then it establishes a connection between the client and the database instance. Once the client is connected to the database instance successfully, it hands over the client connection to the server process. This output shows that two database services, sales. Client connection requests to sales. All handlers have a status of ready , indicating that they are ready to receive connections. Client connection requests to hr. When you notice any of the following conditions, review and monitor the listener log file for the following:.
Note: A version 9 listener is required for an Oracle9 i database. See Also: "Listener Architecture". Note: While service information is not required in the listener. See Also: Oracle9i Net Services Reference Guide for further information about identifying listeners by unique names and creating multiple listener entries in the listener. Note: If a listener.
Note:: The default number of concurrent connection requests is system specific. See Also: "Configuring Service Registration" for more information about configuring dynamic service registration of Oracle9 i and Oracle8 i databases Chapter 15, "Enabling Advanced Features of Oracle Net Services" for more information about statically configuring the listener for external procedures and Heterogeneous Services Oracle Enterprise Manager Configuration Guide for further information about Oracle Enterprise Manager.
See Also: Table for a description of the fields. See Also: "Configuring a Naming Method". Note: Multiple addresses are supported, but connect-time failover and client load balancing features are not supported. All Rights Reserved. Book List. Master Index.
See Also: Chapter 2, "Connectivity Concepts" for a description of how the listener is used during an initial connection request Chapter 4, "Architecture of Oracle Net Services" for an architectural overview of the listener. Global Database Name.
Use to identify the database service. Oracle Home Directory. Specifies the following: Name of the listener Version of listener Start time and up time Tracing level Logging and tracing configuration settings listener. Listening Endpoints Summary. Lists the protocol addresses the listener is configured to listen on. Specifies the name of the instance associated with the service along with its status and number of service handlers associated with the service Status can be one of the following: A READY status means that the instance can accept connections.
If this parameter is set, you cannot use the Oracle database listener to spawn Oracle Database. The following sections describe advanced configuration procedures specifically for Oracle Net Services on Windows operating systems:.
Oracle Net Services provides authentication methods for Windows operating systems using Windows Native Authentication. This section supplements generic information provided in Oracle Database Net Services Administrator's Guide to configure a listener on Windows operating systems to exclusively handle external procedures. For a higher level of security, you are instructed to start the listener for external procedures from a user account with lower privileges than the oracle user.
When you return to the list of services, stop this service before proceeding to the next step of this procedure. Start the listener by clicking Start. You must start the listener in this way because you cannot use the Listener Control utility to start the listener running as an unprivileged local user. For example: sqlnet. ImagePath Specifies fully qualified path name of the executable started by service and any command line arguments passed to executable at run time.
ObjectName Specifies logon user account and computer to which service should log on. About Listener Requirements In Oracle Database, the listener is set to start automatically at system restart. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Helping communities build their own LTE networks.
Podcast Making Agile work for data science. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related 5.
0コメント