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 FEBRUARY 13, 2022

Applies to:

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


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.


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.


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




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

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