Skip to Content
avatar image
Former Member

Oracle listener

Hi

How can we locate whether a system's Oracle listener is LISTENER or LISTENER_<SID, if it is Listener , i came to know we can change the same to LISTENER_<SID in two palces that is listener.ora and tnsnames.ora.

Please let me know regarding the above. Apart from the above places are there any other places to change the same.

IF we change will the system have any effects and does the change require the shutdown and restart of the system.

Thanks

ram

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 16, 2009 at 01:14 PM

    Hello Ram,

    at first you need to know what the LISTENER or the LISTENER_SID entry means. Pleas check metalinknote #235562.1 - it describes the whole registration (manual or automatic) process very well.

    Normally you only need to change the listener.ora, because of the entries in tnsnames.ora will still point to the same services that the listener provides.

    > IF we change will the system have any effects and does the change require the shutdown and restart of the system.

    If you want that the new configuration is active, you need to restart the listener. The established connections will remain whether you restart the listener.

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2009 at 01:17 PM

    Also check sqlnet.ora file

    Rohit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2009 at 02:57 PM

    Hi,

    At command prompt, execute lsnrctl status and you will get lot of details including any alias.

    Hope this helps.

    Manoj Chintawar

    Add comment
    10|10000 characters needed characters exceeded