Can't connect through db-link using /

From: Terry Dykstra <dontreply_tdykstra_at_cfol.ab.ca>
Date: Tue, 04 Sep 2001 20:18:24 GMT
Message-ID: <kGal7.20709$IU3.3950196@news0.telusplanet.net>

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.

listener.ora

---

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.2.3)(PORT = 1526))
        (ADDRESS = (PROTOCOL = IPC)(KEY = TST8))
        (ADDRESS = (PROTOCOL = IPC)(KEY = PATEST))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = TST8.WORLD)
(ORACLE_HOME = c:\orant8i)
(SID_NAME = TST8)

    )
    (SID_DESC =
(GLOBAL_DBNAME = PATEST.WORLD)
(ORACLE_HOME = c:\orant8i)
(SID_NAME = PATEST)

    )
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\orant8i)
(PROGRAM = extproc)

    )
  )

sqlnet.ora

---

NAMES.DEFAULT_DOMAIN = cfol
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
SQLNET.EXPIRY_TIME = 0 tnsnames.ora

---

TST8.CFOL =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.2.3)(PORT = 1526))
    )
    (CONNECT_DATA =
(SERVICE_NAME = TST8.WORLD)

    )
  )

PATEST.CFOL =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.2.3)(PORT = 1526))
    )
    (CONNECT_DATA =
(SERVICE_NAME = PATEST.WORLD)

    )
  )

--
Terry Dykstra
Canadian Forest Oil Ltd.

Received on Tue Sep 04 2001 - 15:18:24 CDT