change Listener from Dynamic to Static in 10gR2
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: change Listener from Dynamic to Static in 10gR2

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    change Listener from Dynamic to Static in 10gR2

    Hello..

    I need to convert my dynamic Listener to Static Listener in Oracle 10gR2. Can anyone outline the steps on how this can be done ?..

    Any help is appreciated..

    thanks
    Ron

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    put an entry in the listener.ora

  3. #3
    Join Date
    Oct 2002
    Posts
    284
    I already have Listener.ora file created with some entries...
    ==========================================
    [oraosc:/u10/app/ORACLE/product/10.2.0.1/network/admin]cat listener.ora
    # listener.ora Network Configuration File: /u10/app/ORACLE/product/10.2.0.1/network/admin/listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oscora01)(PORT = 1521))
    )
    )
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = extproc))
    )
    )
    )

    LOGGING_LISTENER = OFF

    TRACE_LEVEL_LISTENER = OFF

    =====================================

    i created the database using DBCA and i never made any configuration changes to net services. SO 10g is using Dynamic configuration by default..

    I want to change that to Static. How do we do it ?

    thanks
    Ron

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    as i said, put an entry in the listener.ora for the database

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    and dont use 1521, by default instance auto registers with 1521 port listeners

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width