Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can i change the IP Adresse of a public database link ?
Yeah,
why do it the official way, if you can also hack it in?
Regards
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address
On Tue, 18 Jun 2002 19:22:45 +0200, "cf" <news_at_sitinfo.com> wrote:
>select owner,db_link,host from all_db_links;
>
>PUBLIC
>CF.WORLD
>(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.100.3.2)(PORT=1521))(CONNECT_DA
>TA=(SERVICE_NAME=cf)))
>
>In my tnsname IP 10.100.2.1
>Regards
>
>"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> a écrit dans le message de
>news: kaqugukgefrt5cs1pvsmeorlig3pfvim0a_at_4ax.com...
>> On Tue, 18 Jun 2002 15:58:52 +0200, "cf" <news_at_sitinfo.com> wrote:
>>
>> >Can i change the IP Adresse of a public database link ?
>> >
>> >The public database link is use in oracle replication.
>> >
>> >Thanks in Advance..
>> >With My Best Regards...
>> >Christophe
>> >
>> >
>> Question: does a database link have an IP-address.
>> Answer : a database link is a *logical* connection not a physical one
>> Question: did you use the hardcoded IP-address in your host= section
>> when defining the service.
>> You now know why that was plain stupid.
>>
>> Regards
>>
>>
>> Sybrand Bakker, Senior Oracle DBA
>>
>> To reply remove -verwijderdit from my e-mail address
>
Received on Tue Jun 18 2002 - 15:07:09 CDT