Skip to Content
0
Former Member
Sep 02, 2008 at 10:01 AM

Extracting data from Oracle DB into SAP BI using DB connect

24 Views

Hi,

I want to extract data from Oracle DB to SAP BI, using DB connect. When i tried creating the source system of type Database system (Data and Metadata Using SAP DB Connect), i am getting the following error.

1. Database error 12154 at CON

Short Text:

Database error &6 at &7

After the attempt to call a database operation, the database system has returned the error code specified in the message, which indicates that the operation concerned could not be executed successfully.

2. ORA-12154: TNS:could not resolve the connect identifier

The files tnsnames.ora and SQLNET.ora are present in my system.

Can anyone tell me how to solve this issue.

Is it because of any problem in BI side or is it related to Oracle side?

Thanks in Advance