Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

retrieve data into ABAP program from external Oracle database

Gurus,

I reviewed bunch of links regarding DBCON, tnsnames.ora settings and all that and still could not get the connection working:

Need is to connect from within SAP (SAP_ABA and SAP_BASIS = 640) to a imaging system called Filenet (oracle database). I got the Basis folks to put in tnsnames.ora entry with the SID, server name and Port number.

IDB =

(DESCRIPTION =

(SDU = 4096)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = sap.world)

(PROTOCOL = TCP)

(Host = <Server name>)

(Port = 1521)

)

)

(CONNECT_DATA =

(SID = IDB)

(GLOBAL_NAME = IDB.world)

)

)

I configued an entry in DBCON table:

CON_NAME = 'FILENET'.

DBMS = ORA

User name and password

CONV_ENV = <Server name>

DB_reco = space.

and zeros in max_connections and opt_connections

Then I used this straight forward code in a program:

DATA con_name LIKE dbcon-con_name VALUE 'FILENET'.

EXEC SQL.

CONNECT TO 'FILENET' as 'C1'

ENDEXEC.

EXEC SQL.

SET CONNECTION 'C1'

ENDEXEC.

and I have been getting sy-subrc = 4 on both statements. I didnt write the real SQL code to connect to the tables yet, as I guess there is no point at this time.

My basis folks are lost on this and they are not able to resolve the problem. Can you guys help me with tools to find the problem out.

Do I need any entries in DBCONUSR?

Are Basis guys missing something - some settings?

How do I trace whats happening to the request. The basis guy showed me the log and I wasnt able to grep the server name or the alias (FILENET). Please help me get to the bottom of this.

Thanks

Sri

Tags:

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question