Re: Database link not activ

If you are a bloody beginner, you probably forgot to include the backup definition in the tnsnames.ora on the server, like I once did. Database links are handled by the server only. If that doesn't help please post the exact error number.

Hth,

--
Sybrand Bakker, Oracle DBA
Frank an der Heiden <fh_at_energotec.de> wrote in message news:85kb2q$nbf$1_at_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:39:49 CST