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
database link create but not fatch data from link
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
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
Who is online
Users browsing this forum: No registered users and 10 guests