retrieve data into ABAP program from external Oracle database
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.
(SDU = 4096)
(COMMUNITY = sap.world)
(PROTOCOL = TCP)
(Host = <Server name>)
(Port = 1521)
(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'.
CONNECT TO 'FILENET' as 'C1'
SET CONNECTION 'C1'
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.