Re: IP of the current instance/DB

On Fri, 19 Nov 2004 12:20:42 -0500, robert <rchin_at_nietspampanix.com> wrote:

>How do I get the IP of the server on which the intsance/db
>I am logged in/my plsql code executing, is running ?
>
>for 8.1.7.4 and 10.1.0.3.0
>
>thanks

You read the manual under SYS_CONTEXT
and/or check out the v$instance view.
I'm not sure why you want to know this, in a well-configured environment you definitely don't have instances and databases with identical names living of different hosts. I have the strange feeling your situation doesn't adhere to that standard.

--
Sybrand Bakker, Senior Oracle DBA