Task: to identify from where all the connections are coming or better to say, who is coming from where?
Reason: Planning to change the database listening port, earlier it was 1521, the default, but making it 1540
Please advise/share what are our best options, thinking of looking into listener.log and extracting all the HOST=<ip address>.
Please do update/reply, if any guru has any better solution to find all the hosts from where connections are coming.
Thanks in advnace.