where is this GLOBAL_NAME value coming from?

From: Ed Stevens <nospam_at_noway.nohow>
Date: Tue, 16 Mar 2004 08:19:45 -0600
Message-ID: <a12e501dpkn4hpe47iilefmnvd9jr0sh2k@4ax.com>

Server Platform: Oracle EE 9.2 on Solaris 8 Client platform: Oracle 8.1.7 on Win2k

On my desketop I have a login.sql file with the following:

column global_name new_value gname
set termout off
select lower(user) || '@' ||
decode(global_name, 'ORACLE8.WORLD', '8.0',

                    'ORA8I.WORLD', '8i',
                    global_name) global_name from global_name;

set sqlprompt '&gname> '
set termout on

This has worked quite nicely to set my sql prompt to keep me informed of who and where I am. Until now.

While I have been maintaining some Unix based databases that I inherited, yesterday I did my first creation of a db on Unix. Used dbca and netca and everything went swimmingly. But when I connect from my desktop with SQLPlus and the above login.sql file, my prompt looks like this:

system_at_VITSB01.US.ORACLE.COM>

So my question is, where did this 'us.oracle.com' in the global_name come from? There is no reference to it anywhere in my INIT<sid>.ORA file (not using an spfile, btw), nor in my TNSNAMES.ORA file.

The relevant entries: are:
###########################################
# in INIT<sid>.ORA Database Identification
###########################################
db_domain=""
db_name=VITSB01

###########################################
# TNSNAMES.ORA (with spoofed server name)
###########################################
VITSB01.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = VITSB01)
    )
  )

###########################################
# LISTENER.ORA
###########################################
There are no explicit references to this or any db in LISTENER.ORA

###########################################
Server-side SQLNET.ORA
###########################################
NAMES.DIRECTORY_PATH= (TNSNAMES)
###########################################
Client-side SQLNET.ORA
###########################################
NAMES.DEFAULT_DOMAIN = world
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES) Received on Tue Mar 16 2004 - 08:19:45 CST