mzh

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

To see the available command in listener control utility: LSNRCTL> HELP The following operations are available An asterisk (*) denotes a modifier or extended command: exit quit reload services set* show* spawn start                          status stop trace          version RELOAD Purpose To reread the   listener.ora   file. This command enables you to add or change statically configured services without actually stopping the listener. Syntax From the operating system: lsnrctl RELOAD listener_name From the Listener Control utility: LSNRCTL> RELOAD listener_name SERVICES Purpose To obtain detailed information about the database services, instances, and service handlers (dispatchers and dedicated servers) to which the listener forwards client ...