Re: Troubles with database link for local databases

From: ??????? ????? <wadym_at_email.com>
Date: Mon, 11 Mar 2002 11:30:04 +0200
Message-ID: <a6htb9$17a7$1@volcano.apex.dp.ua>

TEST2 - is actually started and CONNECT username/password_at_TEST1 and CONNECT username/password_at_TEST2 from SQLPlus is work. I have Oracle ver. 8.1.6 and WinNT 4 Server (5 service pack). Listener.log and SqlNet.log after connection attempt to TEST1 from TEST2 contain information:

----------------------Listener.log:-----------------------------------------
-----------------

11-MAR-2002 10:37:15 *
(CONNECT_DATA=(SID=test1)(GLOBAL_NAME=test1.WORLD)(CID=(PROGRAM=c:\orantsrv\ bin\ORACLE.EXE)(HOST=GVV)(USER=gvv))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.30.11)(PORT=3881)) * establish * test1 * 0

----------------------SqlNet.log:-------------------------------------------

---

Fatal NI connect error 12631, connecting to:  (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))

  VERSION INFORMATION:
 TNS for 32-bit Windows: Version 8.1.6.0.0 - Production  Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.6.0.0 - Production
 Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.6.0.0 - Production
  Time: 11-MAR-2002 10:37:16
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12631
    TNS-12631: Username retrieval failed     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

----------------------My
Listener.ora:----------------------------------------------------------
LISTENER =


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = gvv)(PORT = 1521))
      )

SID_LIST_LISTENER=
  (SID_LIST=

        (SID_DESC =
         (SID_NAME = PLSExtProc)
         (ORACLE_HOME = c:\orantsrv)
         (PROGRAM = extproc)
        )
        (SID_DESC=
         (GLOBAL_DBNAME=test1.world)
         (SID_NAME=test1)
         (ORACLE_HOME=c:\orantsrv)
        )
        (SID_DESC=
         (GLOBAL_DBNAME=test2.world)
         (SID_NAME=test2)
         (ORACLE_HOME=c:\orantsrv)
        )

  )

----------------------My
tnsnames.ora----------------------------------------------------------

test1.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (COMMUNITY = TCP.WORLD)(PROTOCOL = TCP)(HOST = gvv)(PORT =
1521))

    )
    (CONNECT_DATA =
(SID = test1)
(GLOBAL_NAME = test1.WORLD)

    )
  )

test2.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (COMMUNITY = TCP.WORLD)(PROTOCOL = TCP)(HOST = gvv)(PORT =
1521))

    )
    (CONNECT_DATA =
(SID = test2)
(GLOBAL_NAME = test2.WORLD)

    )
  )

It seems to me that's all. Where is error ? Good luck. Vadim.

"Murali" <oraclems_at_hotmail.com> wrote in message news:22e6597b.0203071216.229477bd_at_posting.google.com...

> Hi,
>
> Make sure your TEST2 database is actually started. Try logging to
> TEST2 using SQLPlus. Also make sure that your TNS entries are
> configured properly. Try connecting to TEST2 using
> username/password_at_connect_string from SQLPlus. If all of the above
> works, but you still cannot connect using the dblink, I dont know
> what's wrong and I cannot give you an answer based on the very small
> amount of information you provided (no OS, version...)
>
> Murali
> http://www.dbaquest.com/

Received on Mon Mar 11 2002 - 03:30:04 CST