Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: global name question
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