The same method works in 7.3.4 and 8.0.5. All I've done is upgrade the
databases to 8.1.7 and now it doesn't work anymore.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Lothar Dickhoff" <dickhofl_at_ada.de> wrote in message
news:OEql7.7$Xi3.362_at_news.ecrc.de...
>
> Terry Dykstra schrieb in Nachricht ...
> >I have two 817 databases: PATEST & TST8 on the same NT4 server. For both
I
> >have in init.ora
> >remote_os_authent = true
> >remote_login_passwordfile = shared
> >os_authent_prefix = 'OPS$'
> >
> >In PATEST I create a database link:
> >create database link TST8 using 'TST8'
> >
> >When I login to PATEST using connect ops$tdd/xxx_at_PATEST then I can run a
> >query over the dblink, e.g. select count(*) from mytable_at_TST8
> >But when I login to PATEST using connect /@PATEST, then the same query
> fails
> >with ora-01017
> >
> >I can login to TST8 using connect /@TST8.
> >I've included the listener.ora, tnsnames.ora and sqlnet.ora from the
> server.
>
> Hi Terry,
>
> ORA-01017 means: invalid username/password; logon denied
>
> your database link was not created correctly.
> Please create it as follows:
>
> CREATE DATABASE LINK <linkname>
> CONNECT TO <username> IDENTIFIED BY <password>
> USING '<sqlnetname>'
>
> this should work.
>
>
>
> an alternate:
>
> CREATE DATABASE LINK <linkname>
> CONNECT TO CURRENT_USER
> USING '<sqlnetname>';
>
> if you use the current user mechanism with stored procedures, views or
> triggers.
>
>
>
> Regs. Lothar
>
>
Received on Wed Sep 05 2001 - 12:14:55 CDT
