Finding IP address in Oracle 7.3.4

[Brian Gebhard]

Hello All,
I need to know how to find the ip address for the connections to oracle 7.3.4. Oracle 8.x uses sys_context('userenv','ip_address') which doesn't work on my 7.3.4 db. Do I need to run any package to get this to work? Is there any other way to find out what the IP addresses are? Thx in advance.

[A. Clay Stephenson]

Usually a netstat -A (or -a) with some grep is sufficient.

[Christopher McCray_1 · Accepted solution]

Hello,

assuming the port for you listener is 1521(substitute as necessary)

# netstat -an |grep 1521

Hope this helps

Chris

[Brian Gebhard]

Thanks guys this was exactly what I needed. Sorry A. Clay I had to give Chris a 10 just because he spelled it out completely as if I was a 3 year old.

[Christopher McCray_1]

I apologize for over-explaining; I like to be thorough and as a result I over-explain and beat things into the ground. I am glad you got what you needed though.


Many happy journeys

Chris

[Brian Gebhard]

By no means was I upset. I'm not a unix admin, just an oracle dba learning unix. I just felt I needed to explain why you received one more point for directing me to the same function.

[Christopher McCray_1]

No offense taken and thank you for your generosity.

Chris