<ORA-03114: not connected to ORACLE

dataservices administration
1

Hi all,
I am using DI 6.5.14 to design a job to extract data from Oracle to target data is Oracle too.
When I run my job, It occur error:
<ORA-03114: not connected to ORACLE

How can I fix this proplem
Cheer!
Dinh
[/b]

pddinh (BOB member since 2005-01-12)

2

Is the Oracle client installed and configured properly on your Job server? If you log into the Job server’s console, can you then log into the Oracle query client using the same username/password specified in the job?

dnewton :us: (BOB member since 2004-01-30)

3

Of course my client conected to Oracle,
and all DataStore connected to Oracle too.
When I run my Job, First it’s well. But after 2 hours, this proplem is occur
Pls help!!!
Dinh[/b]

pddinh (BOB member since 2005-01-12)

4

Go to the computer where job server is installed, open Oracle SQL PLus and try to connect…

Check the Oracle Alert log of your database???

Werner Daehn :de: (BOB member since 2004-12-17)

5

Go to the computer where job server is installed, open Oracle SQL PLus and try to connect…

Of course, my server connect to Oracle sucessfully:cry:
Crying or Very sad

pddinh (BOB member since 2005-01-12)

6

Are you saying the job will run successfully at first, but then you later get this error?

Does the job run for 2 hours constantly? Or, do you mean the job starts and finishes successfully, and then later when you try to run it again, you get the error?

dnewton :us: (BOB member since 2004-01-30)

7

Hi,

talk to your friendly Oracle DBA. Connections that have no activity can time out, they do not need to though.
I believe it is something in user-profiles or whatever.

You can verify by leaving an sql-plus session open and doing nothing for a few hours.

Cheers!

slowbsure (BOB member since 2004-09-27)