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

Connecting to secondary database

I am trying to connect to an external oracle and update data. When I try to access the database (on statement CONNECT TO 'XXX' AS 'A' ), I get sy-subrc = 4. When I check the developer trace, I see an ORA-12154 error.

I have created an entry in the DBCON table. This database is accessible from the R/3 Oracle database. What entry does SAP expect in the DBCON-CON_ENV field? I tried using the full TNS entry which is XXX.WORLD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ip address)(PORT = port number))(CONNECT_DATA = (SID = sid value)))

and the name of the connection as XXX(same as the TNS alias). Is this the right way to configure the table?

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 23, 2005 at 03:16 AM

    The right way to configure external database connections is to use transaction DBCO, where you have to specify:

    "Name of connection" - you enter this name in a native SQL CONNECT statemetn to open connection

    "DBMS" - database system (ORA for Oracle database)

    "User name" - database user

    "DB password" - database user password

    "Conn. info" - for Oracle database short TNS name of the database to which you want to connect with structure "sid.domain" (for examle: prd.world)

    Regards,

    Maxim.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 23, 2005 at 09:44 AM

    Hi,

    look at this OSS-Notes: <b>323151</b>and <b>443867</b>

    regards Andreas

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      What is the conn. info string for this??

      SIGLO.world =

      (DESCRIPTION =

      (ADDRESS_LIST =

      (ADDRESS =

      (COMMUNITY = tcp.world)

      (PROTOCOL = TCP)

      (Host = SIGLO)

      (Port = 1521)

      )

      )

      (CONNECT_DATA = (SID = ORACL)

      )

      )

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.