Skip to Content
0
Former Member
Feb 16, 2009 at 01:02 PM

Oracle listener

135 Views

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