Tomcat Is Not Starting After Changing Demantra Schema Password

(Doc ID 1354209.1)

Last updated on APRIL 04, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.1 and later
Information in this document applies to any platform.
***Checked for relevance on 08-Apr-2013***

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms