OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Monitor Clients IP (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Monitor Clients IP [message #568554]

Sat, 13 October 2012 20:28

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

Report message to a moderator

Re: Monitor Clients IP [message #568555 is a reply to message #568554]

Sat, 13 October 2012 22:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: Monitor Clients IP [message #568580 is a reply to message #568555]

Sun, 14 October 2012 21:18

bignoy
Messages: 4
Registered: June 2011

Junior Member

Thank you very much.

Report message to a moderator

Previous Topic:	Can same db runs on different hosts.
Next Topic:	ora-12203:TNS: unable to connect to destination

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 00:50:16 CDT 2025