Home » RDBMS Server » Networking and Gateways » Monitor Clients IP (Oracle 11g)
Monitor Clients IP [message #568554] Sat, 13 October 2012 20:28 Go to next message
bignoy
Messages: 4
Registered: June 2011
Junior Member
Hi to all,

Is there any logs or query where I can monitor client's IP previously connected to the database? I have created 2 listener with 10.1.2.x and 10.1.100.x network. I would like to separate the oracle traffic to the 10.1.100.x alone. As of now both can connect to the database. I like to monitor if everybody is already transferred to the 10.1.100.x network before I will disable the 10.1.2.x. Thank you very much.

Best regards,
Noel
Re: Monitor Clients IP [message #568555 is a reply to message #568554] Sat, 13 October 2012 22:22 Go to previous messageGo to next message
BlackSwan
Messages: 22427
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>Is there any logs or query where I can monitor client's IP previously connected to the database?
listener log file records every connection request that gets to the listener.
The challenge is that there is NO user details included in the log record.

does system have at least two separate Network Interface cards in it?

> I have created 2 listener with 10.1.2.x and 10.1.100.x network.
Single listener can support multiple IP#s, multiple ORACLE_HOME, & multiple instances.
So little reason ever exists that necessitates having multiple listener.

Re: Monitor Clients IP [message #568580 is a reply to message #568555] Sun, 14 October 2012 21:18 Go to previous message
bignoy
Messages: 4
Registered: June 2011
Junior Member
Thank you very much.
Previous Topic: Can same db runs on different hosts.
Next Topic: ora-12203:TNS: unable to connect to destination
Goto Forum:
  


Current Time: Sat Jul 12 03:15:58 CDT 2014

Total time taken to generate the page: 0.16144 seconds