Home » RDBMS Server » Server Administration » Problem in Database link
Problem in Database link [message #369674] Sat, 25 March 2000 07:16
N.Suresh
Messages: 3
Registered: March 2000
Junior Member
Hello,

This is N.Suresh.

Can u any one help me. please go through the following and solve me the problem.

I have installed Oracle-8 Personal in my system(A).
And I have installed oracle 8i in another server(B).

I configured to access the Oracle 8i database(B) to my system(A) using net8 easy configuration.
I have given the Service name as Oracle8i.I am able to connect with oracle8i
database(B) from my system(A) like connect scott/tiger@oracle8i.
So i am able to access the 8i database tables from my machine(A).

Similarly I configured to access the Oracle8 Personal database(A) to Oracle 8i server(B)
using net8 easy configuration.
I have given the Service name as Oracle8.I am able to connect with oracle8 personal
database(A) from oracle 8i server(B) like connect scott/tiger@oracle8.
So i am able to access the 8(personal) tables from machine(B).

Then I created a database link in Oracle 8i server(A) to Personal Oracle(A).

Syntex;

SQL> Create Database link Oracle8 connect to scott identified by tiger
2 using 'ORACLE8';

Database link created.

After that i tried to access the rows from Personal Oracle 8(A).
The following error is comming.

SQL> Select * from emp@ORACLE8;
Select * from emp@ORACLE8
*
ERROR at line 1:
ORA-02085: database link ORACLE8 connects to ORACLE.WORLD

Similarly I created a database link from Personal Oracle8 (A) to Oracle 8i server(B).

SQL> Create Database link Oracle8i connect to scott identified by tiger
2 using 'ORACLE8I';

Database link created.

The same error comming for this link also.

This following is the error

************************************************************************************************
ORA-02085 database link string connects to string

Cause: The database link attempted to connect to a database with a different name.
The name of the database link must be the same name as the name of the database.

Action: Create a database link with the same name as the database to which it connects.
************************************************************************************************

Reagrds

N.Suresh
Previous Topic: Munual Database Creation in 8i
Next Topic: Re: Database Aliases
Goto Forum:
  


Current Time: Thu Mar 28 12:46:24 CDT 2024