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

Feedback

Thanks for your feedback.

Post your comment on this topic.

Post Comment