Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pentaho ETL and inbound connection timed out

JPADARO_CDEMay 30 2016 — edited May 31 2016

Hi guys.

I have a server with Pentaho 6.0 with a ETL app over a different server with Oracle 11gR2 database.

So, i execute etl and one hour later, etl show an error and alert.log too:

Alert.log

Fatal NI connect error 12170.

VERSION INFORMATION:

TNS for Linux: Version 11.2.0.3.0 - Production

Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

Time: 30-MAY-2016 12:35:34

Tracing not turned on.

Tns error struct:

ns main err code: 12535

TNS-12535: TNS:operation timed out

ns secondary err code: 12606

nt main err code: 0

nt secondary err code: 0

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=pentaho_etl)(PORT=40833))

WARNING: inbound connection timed out (ORA-3136)

Mon May 30 12:35:34 2016

So, if i need increase a timeout, where do i increase timeout parameter? sqlnet.ora server?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 28 2016

Added on May 30 2016

#general-database-discussions

6 comments

2,345 views