My Oracle Support Banner

Tomcat Is Not Starting After Changing Demantra Schema Password (Doc ID 1354209.1)

Last updated on MAY 08, 2019

Applies to:

Oracle Demantra Demand Management - Version 7.3.1 and later
Information in this document applies to any platform.

Goal



Customer is on 731 Demantra version
Customer mentions that after changing Demantra schema password, the Tomcat errors out upon startup with the following errors:

Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-01017: invalid username/password; logon denied
)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.demantra.applicationServer.connection.JDBCConnection.getConnection(JDBCConnection.java:125)
... 23 more
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Customer had modified the password by way of alter user..command
They then followed Note 1317637.1 and have changed the password in APS_PARAM by using following script:

UPDATE aps_params
SET value_string = encrypt_string('&your new pw')
WHERE pname = 'database.password';

commit;


But the issue persists


Solution

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
Goal
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.