Adsense Ad

Tuesday, 7 March 2017

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;

No comments: