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: Names Servers - How To Remove

Re: Names Servers - How To Remove

From: Chris \( Val \) <chrisval_at_bigpond.com.au>
Date: Thu, 24 Apr 2003 23:57:20 +1000
Message-ID: <b88qfu$7klci$1@ID-110726.news.dfncis.de>

"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message news:MPG.19105d657249705e98974a_at_news.la.sbcglobal.net...

| "Chris \( Val \)" <chrisval_at_bigpond.com.au> said...

| >
| > "Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message
| > news:MPG.190f086695a37db2989746_at_news.la.sbcglobal.net...
| > | "Chris \( Val \)" <chrisval_at_bigpond.com.au> said...
| > | >
| > | > I still have a lot to learn in Oracle, no doubt about it.
| > | >
| > | > I am trying to create a database link in PL/SQL using 9i
| > | > on one machine to 9i on another. I'm not sure I understand
| > | > these configuration files enough to do it without some help.
| > | >
| > | > Can you offer some suggestions to get me on the right track ?
| > | >
| > | > Thanks.
| > | > Chris Val
| > | >
| > | Using sqlplus on the source database, you create a database link to the
| > | target database. You only have to do this once, so PL/SQL is probably
| > | not the best choice; use sqlplus.
| > |
| > | You use a different syntax depending on whether you want to connect as
| > | the same userid (an identical Oracle userid must exist on both the
| > | source and the target db) or as a different userid (in which case, you
| > | supply the userid/password in the database link).
| > |
| > | You can find the syntax in the SQL Reference manual at tahiti.oracle.com
| > | (create database link <name>...).
| >
| > Hi Karsten.
| >
| > My problem is not really the syntax, as shown below, that
| > seems fairly straight forward. My problem however, is that
| > I'm not sure how to configure the 'sqlnet_string' below.
| >
| > CREATE DATABASE LINK link_name
| > CONNECT TO username IDENTIFIED BY password
| > USING sqlnet_string;
| >
| > I'll have a look in the reference manual you suggested, but
| > if you think its a fairly simple thing to do, then I would
| > be glad to see a brief example if possible ?.
| >
| > Thank you for your help.
| >
| > Cheers.
| > Chris Val
| >
| You probably already discovered this while I was home (no, I don't work
| 24 hours a day), but...
|
| The "sqlnet_string" is the tnsnames.ora alias name you assigned. For
| example, if you have the following entry in the tnsnames.ora file on
| your source computer:
|
|   target_db = (description...
|
| Then you create your database link on the source computer like this:
|
|   create database link target_link
|     connect to scott identified by tiger
|     using 'target_db';

Hi Karsten, thanks for the tips.

I did some reading about this 'tnsnames.ora' file, and your reply confirms that is what I need to configure. I will try this out over the weekend, and see how I get on :-).

Thanks again.
Chris Val Received on Thu Apr 24 2003 - 08:57:20 CDT

Original text of this message

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