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
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