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))
       )
   )

First, change the HOST value to the IP address for the IP Resource (e.g., 10.10.10.10).

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))
       )
   )

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment