General
cancel
Showing results for 
Search instead for 
Did you mean: 

Finding IP address in Oracle 7.3.4

SOLVED
Go to solution
Brian Gebhard
Occasional Advisor

Finding IP address in Oracle 7.3.4

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.
6 REPLIES
A. Clay Stephenson
Acclaimed Contributor

Re: Finding IP address in Oracle 7.3.4

Usually a netstat -A (or -a) with some grep is sufficient.
If it ain't broke, I can fix that.
Christopher McCray_1
Honored Contributor
Solution

Re: Finding IP address in Oracle 7.3.4

Hello,

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

# netstat -an |grep 1521

Hope this helps

Chris
It wasn't me!!!!
Brian Gebhard
Occasional Advisor

Re: Finding IP address in Oracle 7.3.4

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
Honored Contributor

Re: Finding IP address in Oracle 7.3.4

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
It wasn't me!!!!
Brian Gebhard
Occasional Advisor

Re: Finding IP address in Oracle 7.3.4

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
Honored Contributor

Re: Finding IP address in Oracle 7.3.4

No offense taken and thank you for your generosity.

Chris
It wasn't me!!!!