Re: Oracle database links

Mark Heiple wrote:
>
> In article <31C7E733.340A_at_lilly.com>, "Robert W. Swisshelm"
> <swisshelm_at_lilly.com> wrote:
>
> > Mark Heiple wrote:
> > >
> > > I can't get the database links to work. Just how do you create a database
> > > link?
> > > ... some extracted information ...
> > > I've tried CREAT PUBLIC DATABASE LINK LINK_TO_BACKUP USING
> > > 'MYDB_ON_BACKUP' from the PRIMARY machine while logged into the database
> > > MYDB_ON_PRIMARY.
> > >
> >
> > Database links usually contain the username and password needed to
> > connect to the remote database.
> >
> > CREATE DATABASE LINK LINK_T0_BACKUP
> > CONNECT TO username IDENTIFIED BY password
> > USING 'MYDB_ON_BACKUP';
> >
> > If you don't specify the username and password in the link, Oracle uses
> > the username and password that you used to log onto the local database
> > when trying to make the remote connection.
> >
> > I hope this helps.
> > --
> > Bob Swisshelm
> > Eli Lilly and Company
> > swisshelm_at_lilly.com
>
> I tried specifying the connect to... identified by... clauses and it
> didn't help. Actually, I want the database link to use the
> username/password of the person logged into the local database.
>
> I can connect internal/password_at_link_to_backup from the primary machine,
> but whenever i select * from table_at_link_to_backup, it get error ORA_12203.

Hi,
If you have an error ora-12203, your sqlnet v2 is not configured, or LISTENER
don't work (try lsnrctl stat) or you have bad IP address in tnsnames.ora.
Send me, please:         

        Parameter Example

• domain hierarchical structure (xxx.yyy.zzz)
• node name (xetron)
• server type (unix server,netware server, OS/2 server...)
• database name (mydatabase)
• SID (mydatabase)
• oracle home (/home/oracle)

for both database servers.

                Peter. Received on Fri Jun 21 1996 - 00:00:00 CEST