Tuesday, July 5, 2022

Changing Listener Port for Oracle Database

Changing Listener Port for Oracle Database


 1. Change listener.ora


 LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.201.198)(PORT = 1523))
    )
  )

2. Connect to sys as sysdba

3. execute the following command:

    ALTER SYSTEM SET LOCAL_LISTENER = "(ADDRESS=(PROTOCOL=TCP)(HOST=10.11.201.198)(PORT=1523))";

4. execute the following command:


    ALTER SYSTEM REGISTER;


I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim
E-mail : s.m.sahal789@gmail.com

Thank you.

0 comments:

Post a Comment

If you have any doubts, please let me know. I will help you.