database link - newbie

From: Anja Müller <amueller_at_pironet.com>
Date: Wed, 15 Dec 1999 18:10:59 +0100
Message-ID: <3857CBA3.64248DE2@pironet.com>

Hi,

maybe one of you can help me?

(platform: Solaris 2.6, Oracle: 8.0.5)

I tried to create a database link with the schema manager as I already did before with other databases.

My entries were:

Name: opfer04.piro.net (or what I want) Username: sys
Password: sys'password
Service Name: opfer04 (according to the service name in tnsnames.ora, right?)

When I use the same tnsnames entry on my local PC (Win NT 4.0), I can make a connection to storage manager, ... so I think the syntax must be ok. But I always get the message that the database link is not active. Is there maybe a problem, because the target database in on NT 4.0 and the source on Solaris 2.6?

With best regards and thanks in advance,

Anja Mueller

listener.ora at target computer:
LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL= IPC)


          (KEY= oracle.world)


        )
        (ADDRESS=


          (PROTOCOL= IPC)


          (KEY= ORCL)


        )
        (ADDRESS=


          (PROTOCOL= IPC)


          (KEY= EXTPROC0)


        )
        (ADDRESS=


          (COMMUNITY= NMP.world)


          (PROTOCOL= NMP)


          (SERVER= OPFER04)


          (PIPE= ORAPIPE)


        )
        (ADDRESS=


          (PROTOCOL= TCP)


          (Host= opfer04)


          (Port= 1521)


        )
        (ADDRESS=


          (PROTOCOL= TCP)


          (Host= opfer04)


          (Port= 1526)


        )
        (ADDRESS=


          (PROTOCOL= TCP)


          (Host= 127.0.0.1)


          (Port= 1521)


        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME = opfer04)
      (SID_NAME = ORCL)

    )
    (SID_DESC =

      (SID_NAME = extproc)
      (PROGRAM=extproc)

    )
  )
PASSWORDS_LISTENER = (oracle)

tnsnames.ora at source computer:

OPFER04 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(Host = opfer04)(PORT = 1521))     (CONNECT_DATA = (SID = ORCL)(GLOBAL_DBNAME = opfer04))   ) Received on Wed Dec 15 1999 - 11:10:59 CST