We are getting the following exception when trying to restore projects in our ALM 11 instance.

Messages:
Failed to Restore Project;
Failed to restore project;
Failed to increment sequence of ENABLED_EXTENSIONS_VERSION and reload data;
[Mercury][Oracle JDBC Driver]Object has been closed.;

Stack Trace:
java.sql.SQLException: [Mercury][Oracle JDBC Driver]Object has been closed.
at com.mercury.jdbc.oraclebase.dda4.b(Unknown Source)
at com.mercury.jdbc.oraclebase.dda4.a(Unknown Source)
at com.mercury.jdbc.oraclebase.dda3.b(Unknown Source)
at com.mercury.jdbc.oraclebase.dda3.a(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseConnection.prepareStatement(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseConnection.prepareStatement(Unknown Source)
at com.mercury.optane.core.db.CTdPreparedStatement.createPreparedStatement(CTdPreparedStatement.java:181)
at com.mercury.optane.core.db.CTdPreparedStatement.(CTdPreparedStatement.java:104)
at com.mercury.optane.core.db.CTdPreparedStatement.(CTdPreparedStatement.java:94)
at com.mercury.optane.core.db.CTdPreparedStatement.(CTdPreparedStatement.java
…

Originally we realized that we were unable to perform activities like creating new projects etc. when we started to prepare to upgrade to ALM ver. 12

We mistakenly thought that the issue was that the project/schema user password was incorrect so we followed the procedure outlined in HPE KB article KM00463817.

When we were unable to restore the projects we realized that the actual issue was that our DBA had changed the "system" password in our Oracle instance. We then changed the DB Admin User password, under the DB Servers tab in Site Admin, to the correct password.

After this when we try to restore the project we get the above exception. Can someone please assist me???