My Oracle Support Banner

User Fails to Login With Error "The Session Has Been Terminated. Please Login Again" With Fatal NI Connect Error 12170 in DB Alert Log (Doc ID 2467143.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

Agile Users could not login to the PLM login page.
The application login page was up and running, however when user tries to login, gets below error.
The problem happens once in a while. After restarting Agile Application Server and database server, the system is running fine.

Error

The session has been terminated. Please login again

Summary of related error messages found in application server logs around the time the problem happened:
javax.transaction.xa.XAException: The connection has been administratively diabled. Try again later. The action was taken by a console or administrative command. java.lang.Exception: It was disabled at Tue Oct 02 03:03:06 GMT 2018
javax.transaction.xa.XAException: Two rollbacks failed. The first one threw Closed Connection. The second one threw Closed Connection
<Test "SELECT 1 FROM DUAL" set up for pool "ContentDataSource" failed with exception: "java.sql.SQLRecoverableException: IO Error: Connection reset".>
<Test "ISVALID" set up for pool "opss-audit-DBDS" failed with exception: "isValid returns false".>
<Test "ISVALID" set up for pool "opss-audit-viewDS" failed with exception: "isValid returns false".>
<Test "ISVALID" set up for pool "opss-data-source" failed with exception: "isValid returns false".>

From the DB logs:
***********************************************************************
Tue Oct 02 03:06:20 2018
***********************************************************************
Fatal NI connect error 12170.




Steps

The issue can be reproduced at will with the following steps:
1. Launch browser, access to Web Client and login


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.