Re: host_name from v$instance mystery

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