Skip to Content
author's profile photo Former Member
Former Member

Error while connecting to an external oracle Database

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2012 at 07:58 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.