Re: Determing Server IP or Host name from within Oracle

From: Keith Jamieson <Keith.Jamieson_at_phoenix.ie>
Date: Tue, 21 Nov 2000 09:49:10 -0000
Message-ID: <8vdgj2$28s$1@kermit.esat.net>

I had a similar problem a few months ago, where I had to identify which server I was on. My solution was to have a table on both servers which contained the serverid amd any other information. I created a view on each server which only returned the information for the local serverid.

Sauron wrote in message ...
>Here is poser I have been working on for several days and no clear
>resolution.
>
>I have two servers configured the same, (drives, folder structure, etc).
>One is my current production server, the other is my soon-to-be new
>production server.
>
>My "want" is to be able to do a SQL query that returns me the IP or
hostname
>of the current server I am on. BTW, the instance is the same on both
>machines. I know that I can tell by looking at my v$sga since I made the
>sga bigger on the new server. But, is there another way?
>
>Thanks
>Bob
>
>
Received on Tue Nov 21 2000 - 03:49:10 CST