Create an Oracle Listener with Oracle Network Configuration Assistant : In this article we will see how to Create an Oracle Listener with Oracle Network Configuration Assistant. In order t remote connections to an Oracle database the database must be registered with an Oracle Listener. If you will need to create a Listener manually.
This document will detail the steps to create an Oracle Listener using the Oracle netca.
Start the Oracle Network Configuration assistant with netca.
Step : 1
The Oracle NETCA includes wizards to Create and Manage an Oracle Listener. Click on the Listener configuration option and click the Next button to continue.
Step : 2
On the Listener Operations dialog you have the options to Add, Reconfigure, Delete or Rename the listener. Click the Next button to continue.
Step : 3
Next we provide a name for the listener. The default name is LISTENER. Provide a name for the Listener and click the Next button to continue.
Step : 4
On the Select Protocols dialog you can select which protocols the Listener will use. by default TCP is selected. For this document TCP is the only protocol we are going to use for this Listener. Click the Next button to continue.
Step : 5
The default port number used by an Oracle Listener is 1521. Click on add and the Next button to continue.
Step : 6
If needed you can configure other Listeners.
Step : 7
The Listener configuration is complete. Click the Next button to complete the Listener configuration wizard and to return the Welcome page. On the Welcome page you can exit the Oracle NETCA by clicking the Finish button.
Check Listener Status :
[oracle@vm-4 ~]$
[oracle@vm-4 ~]$ . oraenv
ORACLE_SID = [ORCL] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@vm-4 ~]$
[oracle@vm-4 ~]$
[oracle@vm-4 ~]$ netca
Oracle Net Services Configuration:
Configuring Listener:LISTENER
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
[oracle@vm-4 ~]$
[oracle@vm-4 ~]$
[oracle@vm-4 ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 26-DEC-2020 23:18:22
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vm-4.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 26-DEC-2020 23:10:25
Uptime 0 days 0 hr. 7 min. 56 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/vm-4/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vm-4.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Services Summary...
Service "ORCL" has 2 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "ORCLXDB" has 1 instance(s).
Instance "ORCL", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@vm-4 ~]$
[oracle@vm-4 ~]$
I hope my written content will helped you. Your suggestions/feedback are most welcome from orakldba.com.
Keep learning… Have a great day!!!
Please comment here for your any query related to above content. You could write to mail me through : orakldba@gmail.com.