Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: global name question

Re: global name question

From: Luc Bosman <l.bosman_at_iile.be>
Date: Fri, 16 Nov 2001 08:58:34 +0100
Message-ID: <joh9vt8kln9p4a8n37l2elnittpf9tsufq@4ax.com>


On Thu, 15 Nov 2001 13:14:18 -0500, "Vincent Ventrone" <vav_at_brandeis.edu> wrote:

>
>> Here is the scenario
>> in init.ora: db_domain= (not set)
>> db_name=ORCL8
>>
>> select * from global_name give 'ORACLE'
>> How is it possible? And how correct it? I would like 'ORCL8' in
>> place.
>
>The initial value for global_name is set at DB create time based on the
>values of these (2) init.ora parameters at the time the DB is created --
>what was db_name set to when the DB was created? My guess it was either set
>to ORACLE or nothing in which case, on most platforms, the default name is
>ORACLE.
The name was ORCL8.. strange isn'it?

-- 
Luc Bosman
DEV/2000 Software Engineer
Database & Network Administrator
l.bosman_at_iile.be
 ---------------------------------------------------- 
|  -°)                                          (°-  |
|  /\\  Linux the choice of the GNU generation  //\  |
| _\_v                                          v_/_ |
 ---------------------------------------------------- 
Received on Fri Nov 16 2001 - 01:58:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US