Configuring and Creating the Oracle Net Listener

Updated: Aug 15

The Oracle Net Listener is a process that receives requests for connections from the client to the database server and can be configured with one or more addresses that control its runtime behavior.

In this procedure we will use the Network Configuration Assistant (NETCA) as a configuration assistant.

Note:

If you did not install Database you will not be able to perform these steps. See how to install Oracle Database 19c Multitenant Architecture (Learn more...)


We start with the appropriate settings


With your database completely installed, type the following command:

netca

Step 1:

The command will make a call to Oracle Net Configuration Assistant which is a graphical console that will help in the creation and configuration in the new Listener.


Check Listener Configuration "Next" button.




Step 2:

In this part you can either Reconfigure, Delete, Rename if there is a listener.

In this procedure we will create a new click on Add "Next" button.






Step 3:

Enter a name for the Listener.

"Next" button.








Step 4:

Keep protocol connection settings

"Next" button.








Step 5:

Keep the default port 1521, if other software is using, nothing prevents you from changing it to another number.

"Next" button.







Step 6:

The installer asks if you would like to set up another Listener, we mark No

"Next" button.







Step 7:

Wait for a while until it finishes and you receive the message: Listener configuration complete! "Next" button and "Finished" button.






Step 8:

To validate, we execute the following command to verify that the listener is working correctly.

lsnrctl status.


Command for Listener management:


We can see some of the commands to be executed on the console below.

lsnrctl start          --> (Command start o Listener)
lsnrctl stop           --> (Command for Listener
lsnrctl status         --> (Command see Listener status)
lsnrctl help           --> (View all existing commands in the Listener)

Congratulations, we finished the procedure.


See some scripts that can help you administer the Oracle Database:







All Disconnect Session Script DBA Grouth Create a CDB Multitenant


Want to progress in your DBA career, download our Oracle scripts now and collaborate with us, CLICK FOR ALL