（本文档仅供参考）
问题
使用部分版本的oracle19c作为知识库部署V95时，使用smartbi.war自带的驱动测试连接失败
解决方案
需要更换驱动jar：本文档仅供参考
问题现象
1、使用部分版本的oracle19c作为知识库部署V95时，使用smartbi.war内置驱动测试连接失败；
2、连接部分版本的oracle19c作为数据连接中的业务库时候，使用smartbi.war内置驱动测试连接失败，或者是在数据库管理中报错。
测试连接常见错误信息如下：
| 代码块 | ||
|---|---|---|
| ||
Caused by: 获取数据库连接失败:ORA-28040: No matching authentication protocol
at smartbi.connectionpool.ConnectionPool$5.createConnectionInner(ConnectionPool.java:1276)
at ...(...)
at smartbi.connectionpool.ConnectionPool$5.createConnectionInner(ConnectionPool.java:1270)
Caused by: java.sql.SQLException: ORA-28040: No matching authentication protocol
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:388)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:381)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:427)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at |
数据库管理常见报错如下：
| 代码块 | ||
|---|---|---|
| ||
exceptionToString(smartbi.framework.rmi.RMIServlet:337) - DataSourceService.getSelectedTables error.
获取表的列表失败
at smartbi.freequery.basicdata.SmartbiORACLEDialect.getTables(SmartbiORACLEDialect.java:193)
at ...(...)
at smartbi.freequery.basicdata.SmartbiORACLEDialect.getConnection(SmartbiORACLEDialect.java:62)
Caused by: java.sql.SQLException: ORA-28040: 没有匹配的验证协议
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:388)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:381)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:427)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:390)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:356)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503) |
解决方案
旧版本jar不匹配新版本的Oracle数据库，需要下载这两个jar：_JDBC_oracle_ojdbc8.jar，用这个驱动替换已经有的驱动_JDBC_oracle_ojdbc5_11g.jar，另外还需要增加一个jar：，orai18n-12.1.0.2.0.jar。
可以先将这两个jar放到动态驱动的自定义路径下，然后在config界面或者数据源配置界面驱动程序存放目录选择自定义，然后选择刚刚存放jar的路径，再勾选Oracle12c测试连接。
如果选择自定义路径测试连接仍然失败，或者业务库测试连接成功但是在数据库管理中报错，则需要删除war中的_JDBC_oracle_ojdbc5_11g.jar，然后将上述两个jar打包进war中重启应用后测试。
如果未添加orai18n-12.1.0.2.0.jar，在部署了jar，升级V95过程中Workflow.ext流程引擎扩展包时，升级V95过程中会报如下错误：ext流程引擎扩展包相关代码会报如下错误：
| 代码块 | ||
|---|---|---|
| ||
流程引擎初始化失败 |
...
smartbilibs.org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception |
...
at smartbilibs.org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.rethrow(CommandInvocationContext.java:153) |
...
at smartbilibs.org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:229) |
...
at smartbilibs.org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119) |
...
at smartbilibs.org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) |
...
at smartbilibs.org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) |
...
at smartbilibs.org.camunda.bpm.engine.impl.ProcessEngineImpl.executeSchemaOperations(ProcessEngineImpl.java:121) |
...
at smartbilibs.org.camunda.bpm.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:93) |
...
at smartbilibs.org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:815) |
...
at smartbi.workflow.util.WorkFlowManager.<init>(WorkFlowManager.java:68) |
...
at smartbi.workflow.util.WorkFlowManager.getInstance(WorkFlowManager.java:47) |
...
at smartbi.workflow.WorkflowModule.activate(WorkflowModule.java:80) |
...
at smartbi.framework.Framework.activate(Smartbi:90) |
...
at smartbi.extension.spring.SmartbiContextLoaderListener.contextInitialized(SmartbiContextLoaderListener.java:154) |
...
at com.ibm.ws.webcontainer.webapp.WebApp.notifyServletContextCreated(WebApp.java:1836) |
...
at com.ibm.ws.webcontainer.webapp.WebAppImpl.initialize(WebAppImpl.java:442) |
...
at com.ibm.ws.webcontainer.webapp.WebGroupImpl.addWebApplication(WebGroupImpl.java:88) |
...
at com.ibm.ws.webcontainer.VirtualHostImpl.addWebApplication(VirtualHostImpl.java:171) |
...
at com.ibm.ws.webcontainer.WSWebContainer.addWebApp(WSWebContainer.java:904) |
...
at com.ibm.ws.webcontainer.WSWebContainer.addWebApplication(WSWebContainer.java:789) |
...
at com.ibm.ws.webcontainer.component.WebContainerImpl.install(WebContainerImpl.java:427) |
...
at com.ibm.ws.webcontainer.component.WebContainerImpl.start(WebContainerImpl.java:719) |
...
at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:1248) |
...
at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:1578) |
...
at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:704) |
...
at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:1153) |
...
at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:800) |
...
at com.ibm.ws.runtime.component.ApplicationMgrImpl$5.run(ApplicationMgrImpl.java:2317) |
...
at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:5574) |
...
at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:5700) |
...
at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255) |
...
at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:2322) |
...
at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:436) |
...
at com.ibm.ws.runtime.component.CompositionUnitImpl.start(CompositionUnitImpl.java:123) |
...
at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:379) |
...
at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.access$500(CompositionUnitMgrImpl.java:127) |
...
at com.ibm.ws.runtime.component.CompositionUnitMgrImpl$CUInitializer.run(CompositionUnitMgrImpl.java:985) |
...
at com.ibm.wsspi.runtime.component.WsComponentImpl$_AsynchInitializer.run(WsComponentImpl.java:524) |
...
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909) |
...
Caused by: |
...
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK |
...
at oracle.sql.CharacterSetUnknown.failCharsetUnknown(CharacterSetFactoryThin.java:233) |
...
at oracle.sql.CharacterSetUnknown.convert(CharacterSetFactoryThin.java:194) |
...
at oracle.jdbc.driver.PhysicalConnection.throughDbCharset(PhysicalConnection.java:10365) |
...
at oracle.jdbc.driver.PhysicalConnection.enquoteIdentifier(PhysicalConnection.java:10442) |
...
at oracle.jdbc.driver.OracleStatement.enquoteIdentifier(OracleStatement.java:6452) |
...
at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3853) |
...
at oracle.jdbc.driver.InsensitiveScrollableResultSet.findColumn(InsensitiveScrollableResultSet.java:270) |
...
at oracle.jdbc.driver.GeneratedResultSet.getString(GeneratedResultSet.java:596) |
...
at smartbilibs.org.apache.ibatis.type.StringTypeHandler.getNullableResult(StringTypeHandler.java:37) |
...
at smartbilibs.org.apache.ibatis.type.StringTypeHandler.getNullableResult(StringTypeHandler.java:26) |
...
at smartbilibs.org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:66) |
...
... 60 more |
以及：以及：
| 代码块 | ||
|---|---|---|
| ||
ERROR doUpgrade(smartbi.catalogtree.upgrade.UpgradeTask_0_0_4:186) - 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK |
...
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK |
...
at oracle.sql.CharacterSetUnknown.failCharsetUnknown(CharacterSetFactoryThin.java:233) |
...
at oracle.sql.CharacterSetUnknown.convert(CharacterSetFactoryThin.java:194) |
...
at oracle.jdbc.driver.PhysicalConnection.throughDbCharset(PhysicalConnection.java:10365) |
...
at oracle.jdbc.driver.PhysicalConnection.enquoteIdentifier(PhysicalConnection.java:10442) |
...
at oracle.jdbc.driver.OracleStatement.enquoteIdentifier(OracleStatement.java:6452) |
...
at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3853) |
...
at oracle.jdbc.driver.InsensitiveScrollableResultSet.findColumn(InsensitiveScrollableResultSet.java:270) |
...
at oracle.jdbc.driver.GeneratedResultSet.getCharacterStream(GeneratedResultSet.java:720) |
...
