The Oracle database is accessed via the Service Name in ucsrv.ini under the ODBC section.
The DBA has built out a standby database reachable via the same service name.
When we need to switch to the standby database, the ODBC connection continues to work without modification.
However, as the JDBC connection string uses 'hostname' we have to manually modify this connection string.
The DBA suggested using the LDAP type JDBC string to avoid the manual changes each time, but this does not seem to work.
Release : 12.3
Component : AUTOMATION ENGINE
Oracle Database
The error message in the JWP logs appear as:
U00003545 UCUDB: Opening database ...
U00045025 OSGI ['com.automic.kernel']: '[com.automic.kernel.impl.ServerProcess(31)] The activate method has thrown an exception'
Unhandled Exception in thread main
U00045014 Exception 'java.lang.NoClassDefFoundError: "javax/naming/directory/DirContext"' at 'oracle.net.resolver.AddrResolution.<init>():240'.
U00045015 The previous error was caused by 'java.lang.ClassNotFoundException: "javax.naming.directory.DirContext cannot be found by com.automic.database_1.0.0"' at 'org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal():508'.
Although Oracle supports authentication to the database using an LDAP server, this is not currently supported for use with Automic Automation.