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