Configuring Multiple Port on Default LISTENER in oracle 10g

• ·         Go to Listening locations tab from drop down menu.
• ·         Press Add Address button and select protocol as IPC.

• ·         Press Add Address again to enter port number.
• ·         Select TCP/IP Protocol and provide PORT number.

• ·         Save and Exit from netmgr.
• ·         You can configure several ports in this way with default LISTERNER.

Your "listener.ora" file should look like the following entries now:


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = TESTDB)
      (ORACLE_HOME = /ultimus/oracle/product/10.2.0/db_1)
    )
    (SID_DESC =
      (GLOBAL_DBNAME =  TESTDB)
      (ORACLE_HOME = /ultimus/oracle/product/10.2.0/db_1)
      (SID_NAME =  TESTDB)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = DBLIVE01)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = DBLIVE01)(PORT = 1522))
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = DBLIVE01)(PORT = 1523))
    )
  )

-----------------------------------------------------------------------------------

have a nice day.