My Oracle Support Banner

ODI Domain Upgrade to 12.2.1.x Fails at "OPSS Processing" Phase Execution with "ORA-01017: invalid username/password; logon denied" (Doc ID 2635636.1)

Last updated on SEPTEMBER 09, 2021

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

As part of the Oracle Data Integrator (ODI) upgrade process, the domain reconfigure step fails at "OPSS Processing" with the following error:

CFGFWK-64254: Error occurred in "OPSS Processing" phase execution.

Encountered error: oracle.security.opss.tools.lifecycle.LifecycleException: oracle.security.jps.JpsException:
JPS-06606: Could not create keystore service instance. Reason oracle.security.jps.service.keystore.KeyStoreServiceException:
oracle.security.jps.service.policystore.PolicyStoreException: Can not connect DB with URL
[jdbc:oracle:thin:@//<DATABASE_HOST>:<DATABASE_PORT>/<DATABASE_SERVICE>]
  ...
Caused by: oracle.security.jps.service.policystore.PolicyStoreException: Can not connect DB with URL [jdbc:oracle:thin:@//<DATABASE_HOST>:<DATABASE_PORT>/<DATABASE_SERVICE>]
  at oracle.security.jps.internal.policystore.util.JpsDataManagerUtil.getDBConnection(JpsDataManagerUtil.java:412)
  at oracle.security.jps.internal.policystore.util.JpsDataManagerUtil.isNewSchema(JpsDataManagerUtil.java:246)
  at oracle.security.jps.internal.core.datamanager.DataManagerFactoryImpl.isNewSchema(DataManagerFactoryImpl.java:252)
  at oracle.security.jps.internal.core.datamanager.DataManagerFactoryImpl.getDBDataManager(DataManagerFactoryImpl.java:320)
  at oracle.security.jps.internal.core.datamanager.DataManagerFactoryImpl.getDataManager(DataManagerFactoryImpl.java:161)
  at oracle.security.jps.internal.keystore.rdbms.DbmsKeyStoreManager.getDataManager(DbmsKeyStoreManager.java:73)
  ... 25 more
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

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
References


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