Home » RDBMS Server » Backup & Recovery » database link create but not fatch data from link database give me this err
database link create but not fatch data from link database give me this err [message #180153] Fri, 30 June 2006 07:00 Go to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member

Sir I create database link with this command system create link
but when I user query then system give me this error you see in blow


SQL> create database link xyz connect to mfatest identified by mfa786 using 'aamir';

Database link created.

SQL> select * from accbal@xyz;
select * from accbal@xyz
*
ERROR at line 1:
ORA-28546: connection initialization failed, probable Net8 admin error
ORA-02068: following severe error from XYZ
ORA-03113: end-of-file on communication channel


this is same database but diffrent user

scott user
mfatest user

please give me idea how i fatch data from link database/link other user


thank
aamir

Report message to a moderator

Re: database link create but not fatch data from link database give me this err [message #182020 is a reply to message #180153] Wed, 12 July 2006 10:54 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Make sure both databbases are listed in both tnsnames.ora files. Make sure the remote machine can see the local machine (no firewalls).

On one database it is a linkuser(use the correct password) and on the database it is a link object.

Report message to a moderator

Re: database link create but not fatch data from link database give me this err [message #182024 is a reply to message #180153] Wed, 12 July 2006 11:20 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Am I missing something here? Why don't you just do the following:

SQL> select * from mfatest.accbal;

Report message to a moderator

Previous Topic: problem on db import (oracle portal)
Next Topic: my need is I insert all other branch data in head office system not replace with head office data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 11:56:27 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.