Skip to Content
0
Former Member
Apr 05, 2006 at 03:39 PM

retrieve data into ABAP program from external Oracle database

189 Views

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