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

Home -> Community -> Usenet -> c.d.o.misc -> Re: .world domain in database link

Re: .world domain in database link

From: change <changeme_at_changeme>
Date: Wed, 14 Aug 2002 13:52:58 -0400
Message-ID: <aje3kp$83s4@kcweb01.netnews.att.com>

"change" <changeme_at_changeme> wrote in message news:aje2vk$83s3_at_kcweb01.netnews.att.com...
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:ta0jluctqtr6ioqss189g4mov5kde8u1rf_at_4ax.com...
> > On Tue, 13 Aug 2002 16:00:13 -0400, "change" <changeme_at_changeme>
> > wrote:
> >
> > >Prior to Oracle 8.1.7, I created a database link "db1link", the name in
> the
> > >user_db_links was "db1link.world", so the suffix was automatically
> provided
> > >when the link was created as well when it was used.
> > >
> > >After upgrading to Oracle 8.1.7, I couldn't use the existing database
> link
> > >without explicitly providing .world suffix, and when created, the
.world
> was
> > >not added.
> > >
> > > The db_domain parameter was not defined in the init file in both
cases.
> > >
> > >Can somone tell me if there is a difference in 8.1.7 related to this.
> > >
> > >Maher
> > >
> >
> > Yes. The default domain is empty now.
> > You would also need to specify the domain in your tnsnames services
> > ie
> > db1link.world = etc
> > This is of course in the release notes for 8i
> >
> > Hth
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
> First, thank you for the reply.
> I still cant understand why it's working the old way in one of my system
> test servers that was also upgraded to 8.1.7.
>
> PS. I'm new to news group, how do I set the post to have my name instead
of
> "change"
>
> Maher

Please ignore the question about the newsgroup. It's in outlook express setup. Received on Wed Aug 14 2002 - 12:52:58 CDT

Original text of this message

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