Re: host_name from v$instance mystery

I'm afraid that didn't work. Any other ideas???

In article <956695516.22525.0.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Apr 25 2000 - 00:00:00 CDT