Oracle listener

[Former Member]

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

[Former Member]

Hi,

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

Hope this helps.

Manoj Chintawar

[Former Member]

Also check sqlnet.ora file

Rohit

[stefan_koehler]

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