2085, 00000, "database link %s connects to %s"
// *Cause: a database link connected to a database with a different name.
// The connection is rejected.
// *Action: create a database link with the same name as the database it
// connects to, or set global_names=false.
.
Init.ora file holds this information
Need to try and set the global_names = false.
What is it set to at the moment
It was set to TRUE
Change that and restart the database.
"The Views expressed here are my own and not necessarily those of Oracle
Corporation"
<avbpk1_at_yahoo.com> wrote in message news:80s0kn$5sm$1_at_nnrp1.deja.com...
> Dear Friends,
>
> I have installed oracle 8i on two different machines which have windows
> NT 4.0 workstation. I tried to create a database link and tried to
> access data from the database in the neigbouring machine with the
> following command
>
> SQL> create database LINKNAME
> connect to system identified by manger
> using SERVICENAME
>
> After creating the link successfully, i tried to execute the following
> command through sqlplus
>
> SQL> select *from v$session_at_LINKNAME
>
> I am getting the following error message
> ora-02085: Database link LINKNAME connects to ORACLE
>
> Any suggestions to handle this error and why it is occuring
> Thanks and Regards
> Kumar
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 16 1999 - 22:38:59 CST
