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

Last updated on MAY 08, 2019

Applies to:

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

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