Check the Listener Status
Check the current status of the Listener with following command:
Stop Listener if it is Running
Edit the Configuration File
The configuration file is located at /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora.
The content of this file should be similar to the example shown below:
# listener.ora Network Configuration File: /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = node-a)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )
See Creating an IP Resource to confirm which IP address was previously set.
Also, an additional section for the SID_LIST_LISTENER1 resource is needed. The updated file should look similar to the example below:
# listener.ora Network Configuration File: /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER1 = (SID_LIST = (SID_DESC = (SID_NAME = orcl) ) ) LISTENER1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )
Post your comment on this topic.