Re: database link - newbie

The tnsnames.ora on the server needs to be correct, and it isn't. Database links are a server to server connection. I would definitely not use sys as username, the password will end up unencrypted in the dictionary,

Hth,

--
Sybrand Bakker, Oracle DBA
Anja Müller <amueller_at_pironet.com> wrote in message news:3857CBA3.64248DE2_at_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 - 12:27:28 CST