Skip to Content

Facing ORA-03114: not connected to ORACLE when accessing data from source table

Mar 08 at 03:57 AM


avatar image
Former Member

Hi All Experts,

My source database is oracle 11g. I am able to created data store using same database.

also able to import table from oracle database but when i am right click on that source table and select option "view Data" it will shown data first time but when I am trying same process for second time it will give error i.e. ORA-03114: not connected to ORACLE.

When I closed Designer and re-login it. same thing happened which i mention above.

System/Tools Configuration:

SAP Data Services 4.2 SP8 - Installed on platform: SUSE Linux Enterprise Server 12.2 (SP2). Linux Kernel Version: 4.4.21-69-default

Source Database: Oracle 11g

Target Database: Sybase ASE 16.0

SAP Data Services Designer install on Windows Server 2008 R2 Standard

I have already checked below forum links:

Thanks in advance for valuable inputs.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Mar 14 at 09:37 AM

Hello All Experts,

I have analysis of above error and conclusion are as below:

My source database connection is staying with BODS for 20 second only after that it is disconnected and getting above error.

What is problem behind it. please give me solution on it if anyone knows.



10 |10000 characters needed characters left characters exceeded