Database link not activ

From: Frank an der Heiden <fh_at_energotec.de>
Date: Thu, 13 Jan 2000 12:03:05 +0100
Message-ID: <85kb2q$nbf$1@oxygen.technet.net>

hello together,

after reading, eating, sleeping, reading .... the oracle documentation (thank you for nothing "oracle" ;-)) i am really frustrated.
i want to create a database link to the table
"pms" on an other database on an other workstation.

i tried: create public database link backup_db

            connect to pms identified by <password_for_pms>
            using 'backup'

where 'backup' is the service containing:

protocol: tcp/ip
hostname: testserver (the workstation where the database with the schema
"pms"

                is running)

port-no: 1521 (default ?!?)
sid: orcl

after executing the sql-command i get the message: database link created, but if i want to test it with the schema manager application, i get all time the message-panel "database link not activ"

is it necessarry to activate a database link manually? if yes, how can i do this?

thanx in advance from a bloody beginner

--
MfG / best regards

Frank an der Heiden
Energotec Systeme und Automation GmbH
Tel.: +49 0211 91440-19
email: fh_at_energotec.de Received on Thu Jan 13 2000 - 05:03:05 CST