AnsweredAssumed Answered

Unable to connect to Clarity Oracle DB after implementing encryption on DB

Question asked by wilsonl8 on Aug 6, 2013
Latest reply on Sep 21, 2015 by Marcoaldama
In-flight encryption was recently implemented on our development Clarity DB server. Since this was implemented, we are unable to connect to the database via Clarity. If I log on to the Clarity server, I can connect to the database with SQL*Plus, but not with Clarity. In NSA, I get the following errors:

NSA-0108: This page requires that the database is installed and available. Verify the service is available, the NSA server database properties are correct and the database installation has completed successfully.

NSA-0113: This page requires database connectivity. Verify the service is available and the NSA server database properties are correct.

In the app-niku.log file I see the following errors:

FATAL 2013-08-05 12:40:12,416 [WrapperStartStopAppMain] union.persistence (none:none:none) Failed to initialize Context properties
java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]No more data available to read.

at com.ca.clarity.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.ca.clarity.jdbc.oracle.net8.OracleNet8NSPTDAPacket.sendRequest(Unknown Source)

at com.ca.clarity.jdbc.oracle.OracleImplConnection.connectAndAuthenticate(Unknown Source)

at com.ca.clarity.jdbc.oracle.OracleImplConnection.open(Unknown Source)

at com.ca.clarity.jdbc.base.BaseConnection.connect(Unknown Source)

at com.ca.clarity.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)

at com.ca.clarity.jdbc.base.BaseConnection.open(Unknown Source)

at com.ca.clarity.jdbc.base.BaseDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:582)

at java.sql.DriverManager.getConnection(DriverManager.java:154)

at org.logicalcobwebs.proxool.ProxyFactory.buildProxyConnection(ProxyFactory.java:41)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:150)

at org.logicalcobwebs.proxool.PrototyperController.buildConnection(PrototyperController.java:88)

at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:222)

at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)

at java.sql.DriverManager.getConnection(DriverManager.java:582)

at java.sql.DriverManager.getConnection(DriverManager.java:154)

at com.niku.union.persistence.connection.ProxoolContext.getConnection(ProxoolContext.java:117)

at com.niku.union.persistence.connection.ProxoolContext.getConnection(ProxoolContext.java:92)

at com.niku.union.persistence.connection.ConnectionContext.initializeContextProperties(ConnectionContext.java:446)

at com.niku.union.persistence.connection.ConnectionContext.getContext(ConnectionContext.java:201)

at com.niku.union.config.ConfigurationManager.verifyDatabaseConnect(ConfigurationManager.java:2582)

at com.niku.union.config.ConfigurationManager.initAppServerIntern(ConfigurationManager.java:2112)

at com.niku.union.config.ConfigurationManager.initAppServer(ConfigurationManager.java:2061)

at com.niku.union.web.WebControlServlet.init(WebControlServlet.java:128)

at javax.servlet.GenericServlet.init(GenericServlet.java:212)

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1206)

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4421)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:243)

at java.lang.Thread.run(Thread.java:619)
ERROR 2013-08-05 12:40:12,416 [WrapperStartStopAppMain] niku.union (none:none:none) Clarity 12.1.0.5840 failed to initialize.
com.niku.union.config.ConfigurationException: Failed to verify database

at com.niku.union.config.ConfigurationManager.verifyDatabaseConnect(ConfigurationManager.java:2653)

at com.niku.union.config.ConfigurationManager.initAppServerIntern(ConfigurationManager.java:2112)

at com.niku.union.config.ConfigurationManager.initAppServer(ConfigurationManager.java:2061)

at com.niku.union.web.WebControlServlet.init(WebControlServlet.java:128)

at javax.servlet.GenericServlet.init(GenericServlet.java:212)

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1206)

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4421)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:243)

at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Connection unavailable


Oracle Advanced Security Network Encryption was implemented on the Oracle DB server by making the following changes to the sqlnet.ora file:

SQLNET.CRYPTO_CHECKSUM_SERVER = required
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER= (MD5)
SQLNET.CRYPTO_SEED = '......................'
SQLNET.ENCRYPTION_TYPES_SERVER= (AES256)
SQLNET.ENCRYPTION_SERVER = required

Has anyone tried implementing Oracle Network Encryption that may have run into this problem?

Thanks,
Larry

Outcomes