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.