Impossible to start the UVMS after an Oracle database host change

Document ID : KB000086615
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
On the uvserver.log, this kind of message appears after the failed startup:
##############
|ERROR| main | org.hibernate.util.JDBCExceptionReporter | Cannot create PoolableConnectionFactory (ORA-01033: ORACLE initialization or shutdown in progress
##############

Patch level detected:Univiewer Management Server 6.3.01
Product Version: Dollar.Universe 6.3.01

Description :The DB server hosting the UVMS database had an issue and then a failover was performed to the DR server.
After restarting the DR Database, the UVMS could not be started anymore, stating a problem to connect to the database.
Environment:
OS: All
Cause:
Cause type:
Configuration
Root Cause: The Oracle Instance hosting the UVMS database before the failover was in Standby mode, so the UVMS could not establish a connection anymore.
Resolution:
The configuration of the UVMS needs to be changed in case the instance name / hostname hosting the Database is changed.
The following variables should point to the new active database server on the values.xml:

SERVICE_NAME_DR_SERVER
DR_SERVER_HOSTNAME

After setting the correct values, restart the UVMS server again.

Fix Status: Released

Fix Version(s):
Component: Univiewer.Management.Server
Version: Dollar.Universe 6.3.01
Additional Information:
Workaround :
N/A