Updated: Aug 15, 2020
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.
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:
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.
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.
Enter a name for the Listener.
Keep protocol connection settings
Keep the default port 1521, if other software is using, nothing prevents you from changing it to another number.
The installer asks if you would like to set up another Listener, we mark No
Wait for a while until it finishes and you receive the message: Listener configuration complete! "Next" button and "Finished" button.
To validate, we execute the following command to verify that the listener is working correctly.
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)