MFT CC installation issue while conneting to Oracle DB

[Satish Reddy 7]

Hi All ,

Iam facing issue during performing MFT CC installation on RHEL 7.6 , we are Oracle 12c RAC and below error is being at very first stage while connecting to database.

We have installed below JDK version as part of the pre-requisite and also added urandom property to resovle the issue but still no luck . Can someone please help on this issue , i have been tryign to fix this from 1 week .

 

JDK Version : jdk1.8.0_211-amd64

MFT Version : 8.2.0

Oracle DB : 12c RAC

 

Error :

Failed to establish a connection to the database: java.sql.SQLRecoverableException: IO Error: Connection reset

Check your connection settings and reattempt.

[log

java.sql.SQLRecoverableException: IO Error: Connection reset

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:771)

at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:721)

at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:415)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:26)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:597)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at com.proginet.sift.dbaccess.DBConnection.getConnection(Unknown Source)

at com.proginet.sift.install.installer.ServerInstaller.verifyDatabaseConnection(Unknown Source)

at com.proginet.sift.install.installer.TomcatInstaller.install(Unknown Source)

at com.proginet.sift.install.installer.SIFTInstaller.main(Unknown Source)

Caused by: java.net.SocketException: Connection reset

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:115)

at java.net.SocketOutputStream.write(SocketOutputStream.java:155)

at oracle.net.ns.DataPacket.send(DataPacket.java:242)

at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:211)

at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:298)

at oracle.net.ns.NetInputStream.read(NetInputStream.java:245)

at oracle.net.ns.NetInputStream.read(NetInputStream.java:167)

at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)

at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:119)

at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:75)

at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:444)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:402)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:256)

at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:438)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:648)

[Andy-dont-use Pritchard]

Hi,

 

I'm not sure if we support 12, it's not on the release notes list but i can ask the question.

 

From a backward compatiblity point of view, what driver are you trying to use I have seen issues before that using the latest drive causes issues but if you use the old driver it works just fine.

 

Can you try that And i'll see if we support 12..

 

Andy

[Andy-dont-use Pritchard]

FYI ... In the installation readme file ...

 

Oracle - Customers must provide the Oracle JDBC drivers. Supported drivers are ojdbc6(Oracle 11) and ojdbc7(Oracle 12)which can be downloaded from the www.oracle.com website.

 

Notes for Oracle database use:

The Oracle RAC Single Client Access Name (SCAN) for Oracle RealApplication Clusters is not supported. The following urlprovides additional information:

http://www.oracle.com/technetwork/database/clustering/overview/scan-1290...

The following connection string example explicitly lists theparticipating Oracle RAC:

 

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(FAILOVER=ON)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME= ServiceName)( SERVER=DEDICATED)))

[Satish Reddy 7]

Hi Andy,

 

I have tried multipl combinations - Tried with ojdb7.jar alone but same error.

Tried with ojdbc6.jar ,ojdbc7.kar and ojdbc8.jar - same error

ojdbc8.jar and ojdbc24.jar together - same error.

I saw suggestions from below link about drivers to be used for oracle RAC -classes12.jar and ocrs12.jardrivers but still the same error .(Minimum Database section )

https://community.tibco.com/wiki/tibco-managed-file-transfer-requirements-and-sizing-guide#toc-28

We are able to telnet from TIBCO Vm to Oracle server , so no issues with connectivity . ABle to connect to DB from PL/SQL developer without any issues .

Regards,

Satish Reddy

[Andy-dont-use Pritchard]

Looking up the java error on th enet throws up a lot of similar issues. All related to network/security type issues.

For example:  https://stackoverflow.com/questions/6110395/sqlrecoverableexception-i-o-exception-connection-reset

Which talks about the randomness of the connection values (see that post)

You say you've tested PL/SQL developer ... i assume from the same machine   And have you verified that the connection string is the same same driver  

[Andy-dont-use Pritchard]

FWIW ..... JDK 1.8 you need to be using ojdbc7.jar as the driver ....

 

Are you seeing anything in the Oracle listener log

 

The only very similar case i found in our internal support systems, the customer moved to a different Oracle DB and it worked OK .... but that doesn't help you :-(

[Tom Bauer]

MFT does support Oracle 12C.

This does not appear to be a connectivity issue or an MFT issue.

I noticed this possible fix when running on Red Hat. Update the /server/bin/setenv.sh to add this parameter:

-Djava.security.egd=file:/dev/./urandom

or

-Djava.security.egd=file:/dev/urandom

 

I have seen links suggesting both options. Try first with:

-Djava.security.egd=file:/dev/urandom

Ifthat does not work, try:

-Djava.security.egd=file:/dev/./urandom

Example:

JAVA_OPTS="-Duser.language=en -Duser.country=US -Dfile.encoding=UTF-8 -Dssh.maxWindowSpace=4096000 -Djdk.tls.ephemeralDHKeySize=2048 -Dcom.tibco.tibcrypt.httpshandler=false -Dorg.apache.catalina.session.StandardSession.LAST_ACCESS_AT_START=false -Dorg.apache.catalina.session.StandardSession.ACTIVITY_CHECK=true -Dcom.ibm.jsse2.overrideDefaultTLS=true-Djava.security.egd=file:/dev/urandom-XX:+HeapDumpOnOutOfMemoryError"FIPS_MODE="false"

 

https://stackoverflow.com/questions/6110395/sqlrecoverableexception-i-o-exception-connection-reset

The error occurs on some RedHat distributions. The only thing you need to do is to run your application with parameterjava.security.egd=file:///dev/urandom:

java -Djava.security.egd=file:///dev/urandom [your command]

[Satish Reddy 7]

@Andy , @tbuaer , Thanks a lot for looking into this issue .

Finally we have resolved the issue , as you guys mentioned above this is not MFT issue .

We have observed "Inbound Connection Timeout issue" in DB server logs . connectivity is taking lot of time and it is timing out . As suggeste in below blog , we have enabled connection timeout parameters in DB instance(sqlnet.ora and listener.ora) and now we are able to establish connection with DB during MFT installation . This timeout issue might bedue to network slowness or some other latencythat we will figure it out later :)

http://rafioracledba.blogspot.com/2013/01/warning-inbound-connection-timed-out.html

Thanks again for investing your valuable time on this issue .

Regards.

Satish Reddy

[Tom Bauer]

Is this error happening on Installation or after installation when the server is up and running

Ifthis is happening on installation, then the fix to setenv.sh will not help.

 

Waht error is happening on the Oracle side

Have you opened a case with Oracle

[Tom Bauer]

You can ignore my last comment. I am glad that it is working now.

Seems strange that a local connection gets timeouts.

I assume that the DB is located at the same site as the MFT instance.

Generally speaking, we suggest running MFT in the same location as the DB.