Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to config server to server sql*Net
If you have global_names set to false in both your init<sid>.ora, you can
give the two databases distinct tns aliases which are different from the
sid/dbname.
i.e.
tnsname: db1
host 90.0.0.2
port 1526
sid ORCL
tnsname: db2
host 90.0.0.3
port 1526
sid ORCL
You can then reference db1 or db2 in the dblinks.
À¹ºaµq wrote in message <75gitg$ru3_at_netnews.hinet.net>...
>I have two database running on two platform (2 risc /6000), the oracle
>version is 8.05
>I want to create Database Link . But I have problem with my sql*net.
>first, my databases have the same name on two platform, and the
tnsnames.ora
>are the
>same in two platform,thet have the same service name . but the lsnrctl.ora
>is different .
>So I can connect to each database using Sql*plus , but when I want to
create
>Database link
>I was confused.
>
>May I reconstruct the TNSNAMES.ORA on two platform without affect my
client
>pc Easy*net configuration . And by giving each TNSNAMES unique service name
>, will i solve this problem.
>
>
>
>
Received on Mon Dec 21 1998 - 19:58:13 CST