Error while connecting to an external oracle Database

[Former Member]

Dear Experts ,

I'm facing an issue with the connection to another Oracle database, after saving the connection in the transaction

DBACOCKPIT

it gives me the following error

errors@

FBP

Function SYNCHRONIZE_SYSTEM_DATA failed with return code = ADBC error

i have followed this link

http://wiki.sdn.sap.com/wiki/display/Basis/SAP+DB+Link+to+an+External+Oracle+Database

to be able to connect to an external Database like oracle,
what i've done with this file is that i transfer the info from our Tnsnames.ora file to the other database TNSnames.ora file and in return
(host ip , port , service name and so on )

now i don't know why this error appers to me
is that a confilect
how to implement this connection successfully

i have followed the upper link , but i  think i did something wrong

Best regards,

Haytham

[Former Member]

I don't know what is the meaning of letting the same alias in both TNSnames.ora file

i think that the purpose of Tnsnames.ora file is to make two listeners in the both sides of Databases
so each database has the IP address and service name of the other .
please clearfy  
thanks

[volker_borowski2]

Hi,

first of all, make sure you have the correct tnsnames.ora, as there might be two of them.

For the SAP system it should be the one where the environment TNS_ADMIN for sidadm

is pointing to. Attach it.

Second thing is the listener configuration of the target DB.

Attach listener.ora and sqlnet.ora from that system.

If there is some kind of firewall or packetfilter in between these systems, make

sure that the listener port to the remote system is open.

Volker