麦粉社区
>
帖子详情

8.5升级为9.5版本后,原数据源报错,ORA-01017: invalid usernam...

众测 发表于 2021-3-8 16:01
发表于 2021-3-8 16:01:42
      8.5升级成9.5版本后原来的数据源不能使用,后台报错信息为ORA-01017: invalid username/password; logon denied, 原来的数据库源为oracle12版本,以前在8.5版本没有任何问题,数据库用户名密码也没有更改,输入无误,且在plsql都能正常登陆,我试验了下,修改数据库密码为原来的密码就能连接,请问一下,各位老师,除了修改密码是否还有比的解决方案,谢谢后台日志报错信息如下:
连接池初始化失败:SQL错误:ORA-01017: invalid username/password; logon denied

        at smartbi.freequery.basicdata.MetaDataServiceImpl.testConnection(MetaDataServiceImpl.java:481)
        at ...(...)
        at smartbi.connectionpool.SmartbiPoolableConnection.doGetConnection(SmartbiPoolableConnection.java:44)
Caused by: java.sql.SQLException: SQL错误:ORA-01017: invalid username/password; logon denied

        at smartbi.connectionpool.SmartbiPoolableConnection.doGetConnection(SmartbiPoolableConnection.java:44)
        at smartbi.connectionpool.ConnectionPool.doGetConnection(ConnectionPool.java:455)
        at smartbi.connectionpool.ConnectionPool.driverConnect(ConnectionPool.java:339)
        at smartbi.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:535)
        at smartbi.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:496)
        at smartbi.freequery.basicdata.MetaDataServiceImpl.testConnection(MetaDataServiceImpl.java:435)
        at smartbi.freequery.client.datasource.DataSourceService.testConnectionList(DataSourceService.java:211)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at smartbi.framework.rmi.ClientService.execute(Smartbi:118)
        at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:230)
        at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:168)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:163)
        at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:152)
        at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:70)
        at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:152)
        at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:175)
        at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:64)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:80)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:211)
        at smartbi.freequery.filter.Filter.doFilter(Filter.java:36)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:209)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:61)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at smartbi.framework.RedisSessionFilter.doFilter(Smartbi:125)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:528)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:810)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)


高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

0回帖数 0关注人数 994浏览人数
最后回复于:2021-3-8 16:01
快速回复 返回顶部 返回列表