Re: host_name from v$instance mystery

Which didn't resolve it as Oracle stores the db_domain in the control file once.
If you really want to change it use
alter database rename global_name to '<database name including domain>'

Hth,

Sybrand Bakker, Oracle DBA

<kal121_at_my-deja.com> schreef in berichtnieuws 8e4rtc$qkv$1_at_nnrp1.deja.com...
> When I created the database, yes - I set domain_name =
> dev.mycompany.com.
>
> But I've since commented out this parameter and restarted the database.
>
> In article <38F770A2.DD468992_at_0800-einwahl.de>,
> Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de> wrote:
> > Did you specify domain_name = dev.mycompany.com or similar in
 init.ora in the
> > instance's machine where you have the full qualification?
> >
> > Martin
> >
> > kal121_at_my-deja.com wrote:
> > >
> > > Where does Oracle get the host_name in the v$instance table?
> > >
> > > The reason I ask is, on one machine, the host_name is simply the
> > > machine name, for example: DARTHVADER
> > >
> > > On another machine, the host_name is the fully qualified domain
 name,
> > > for example: LEIA.DEV.MYCOMPANY.COM
> > >
> > > Why is this? I like to display the host_name in my prompt, but
 having
> > > the full name display is too long! How can I fix it so that it only
> > > shows LEIA, not LEIA.DEV.MYCOMPANY.COM?
> > >
> > > Thanks
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Apr 25 2000 - 00:00:00 CDT