database link create but not fatch data from link

[mfa786]

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

[imranhad]

you first write this command

check your database global name

SQL> select * from global_name;
GLOBAL_NAME
------------------------------------------------------------------
MFA.US.ORACLE.COM
IF UR SID=MFATEST THEN
SQL>alter database rename global_name to MFATEST.US.ORACLE.COM;

SQL>CREATE PUBLIC DATABASE LINK "CITY.US.ORACLE.COM" CONNECT TO
"MFA" --SCHEMA NAME
IDENTIFIED BY MFAA
USING 'MFA_TNS' ;

SQL>select * from accbal@MFATEST.US.ORACLE.COM;

Then u will ur requird result
thanks

Imran Hyder