Scribd
Upload
157 views7 pages

Server Side Configuration

The listener is a separate process that runs on the database server and receives client connection requests, managing traffic to the database. It acts as the "gatekeeper" by authenticating all incoming client requests. The listener configuration file contains parameters needed to run the listener process and is located under $ORACLE_HOME/network/admin. Multiple listeners can be configured for load balancing or to handle connections for multiple databases. To configure a listener, the netca command is used to specify the name, protocols, and port number during setup.

Uploaded by

Ayesha Talat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
157 views7 pages

Server Side Configuration

The listener is a separate process that runs on the database server and receives client connection requests, managing traffic to the database. It acts as the "gatekeeper" by authenticating all incoming client requests. The listener configuration file contains parameters needed to run the listener process and is located under $ORACLE_HOME/network/admin. Multiple listeners can be configured for load balancing or to handle connections for multiple databases. To configure a listener, the netca command is used to specify the name, protocols, and port number during setup.

Uploaded by

Ayesha Talat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 7

Server side configuration

Listener
The listener is a separate process that runs on the database sever computer.it receives coming clients
connection request and manages the traffic of these request to the database server .

Listener process
Whenever a new connection in the database the first connection is is to relay on the oracle listener
process. It acts like human ear in the database which will be listen all the incoming connection. It’s
responsibility is to hand over these connection in database. It’s kind of gatekeeper which will check k
authentication of all incoming request of client. There is no relation between database and listener.
Listener us not depend on database.

Listener configuration
Configuration file is reside under the $ORACLE_HOME/network/admin/location
 Listener is hands over new connection through PMON.
 Single listener can handle connection for multiple databases.
 You can configure multiple listeners for single database for load balancing.
 You can configure multiple listeners for multiple database.
Configuration file name is listener.ora. It contain all parameters that is important for run the listener
process .listener can take all credential.
 Listener can run in OS or not
Command = #ps-ef|greptens
 Connect listener utility
# lsnrctl
 There are two types of listener configuration
Manual
Netmgr utility

Session
A session represents the connection between an application and the relational database that stores its
persistence object. It is used for single user and single database application.
Database session class
An application must create an instance of the database session class. A database session class stores the
following information.
 An instance of project and database login which stores database.
 An instance of database accessor which wraps the JDBC connection and handles database
access.
 The descriptor for each of the application’s persistence class.
 The identity maps which maintain object and act as a cache

Creating listener
To configure follow below steps.
Login to system as ORACLE user.
now execute netca command and follow below steps.

Click on Next
Again Next

Give the name of listener and click on next


Select protocols you want and click next
Give port number you want to use for oracle. by default it will use 1521

If you want to configure another listener then select yes else No


Click on next
Click on Finish as process is completed.

Comments and suggestion are welcome

You might also like