Oracle Connection Lost

dataservices administration
1

Hi,

We are using BO Rapidmarts for Oracle APPS, Few months back the code is moved to a NewServer.

When we are executing ETL jobs in New Environment, they get terminated at the end of the load with the following error :
“SQL submitted to Oracle Server resulted in error <ORA-03135: connection lost contact>”

So can anyone help me on this.

Thanks

jaswanthknv (BOB member since 2011-02-09)

2

Were you able to ping/tnsping the new server and the databases? Ever tried connecting to the new server using the SQL Plus applications from your DI Server?

ganeshxp :us: (BOB member since 2008-07-17)

3

Yes we are able to ping the NewServer, When we are executing the job, the data is getting loaded and at the end of the load it throws the error.

We are also able to Query the same table in the NewServer.

jaswanthknv (BOB member since 2011-02-09)

4

That sounds like an oracle timeout, have you compared all your setting between old / new servers? The SQLNet.ora on the old have any special settings you didn’t carry forward? Firewall differences?

If you don’t resolve this here. may be worth a case with Oracle support…

B

bdouglas :switzerland: (BOB member since 2002-08-29)