My Oracle Support Banner

Agile Application Server Service Fails to Start After Database Refresh With Error Caused By: oracle.security.jps.JpsException And ORA-01017: Invalid Username/Password (Doc ID 2498851.1)

Last updated on FEBRUARY 17, 2024

Applies to:

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

Symptoms

Application server service cannot be started after a database refresh with below error in Agile Application Server log:

ERROR

Caused By: oracle.security.jps.JpsException: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-01017: invalid username/password; logon denied





Steps

The issue can be reproduced at will with the following steps:
1. Take backup of all the RCU schemas, Agile schema and Agile users password of the target instance
2. Refresh the database schema
3. Imported database schema from the source instance
4. Updated Agile user password



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
Cause
Solution


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