Re: IP of the current instance/DB

From: robert <rchin_at_nietspampanix.com>
Date: Fri, 19 Nov 2004 15:10:00 -0500
Message-ID: <cnljup$ifu$1@reader1.panix.com>

Sybrand Bakker wrote:
>
> 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.

no, no instance + DB all on one box, just being anal when it come to references to "instance" and "database".

SYS_CONTEXT('USERENV','IP_ADDRESS') --> Client IP v$instance --> Just host name Received on Fri Nov 19 2004 - 14:10:00 CST