on 08-31-2007 10:24 AM
Hi gurus,
I need to connect to oracle database which is an external database from sap.
can any one tell the steps for connectivity and for reading the data from the database that resides in the oracle database.
Perhaps something is wrong with the Oracle Net configuration. For example you need a section with the remote <sid> in tnsnames.ora. Often you can find a more
precise error in the work process trace file dev_w<wp_number> (e.g. via transaction ST11).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sorry Naga,
i make a mistake ....
you mean that you want to connect another external ORACLE from SAP via <b>ABAP/4</b> ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes,
i want to get the data from external database which is oracle database in to abap program.
i made entry in dbcon table .
how ever when i tried to connect using connect statement, sy-subrc is giving 4.
all data is maintained in external oracle database....from that database i need to read data from one table in to sap abap program.
The file is usually located in the following path on the central instance (CI) box (if your DB server is on a different box than your app server, this is important to note):
/network/admin
An example entry (Change to fit your Oracle DB)
EXAMPLEDB.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = exampleoraclehostbox)(PORT = 1525))
)
(CONNECT_DATA =
(SID = EXAMPLEDB)
)
)
*Note, the .WORLD suffix may or may not need to be there based on your configuration.
You can run ABAP Program in SE38 called 'ADBC_TEST_CONNECTION' to test the connection (it reads from DBCON, so make sure you have that information there as well).
Hi Naga,
First you have to check the sqlnet.ora this file and choose the connection mode in server side .
And then install an oracle client in your client side , and copy the sqlnet.ora to your oracle directory .
and now you can access the oracle database via 'SQLPLUS' ..
hope it useful ...
But before do this please take care ... i am not recommend you do this for security .
Best Regards,
Carlos
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.