(EAS850版本)客户端登陆报错获取用户信息失败

栏目:eas cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-22浏览:1

(EAS850版本)客户端登陆报错获取用户信息失败

**1.问题描述** 1.1.EAS85版本输入密码后报错获取用户信息失败,如下图所示: ![image.webp](/download/01005811afb4534242f9997a19faba04aea2.webp) 1.2.测试数据库连接是正常的。 ![image.webp](/download/0100655442910595459cbbb2900f55845d05.webp) 1.3.查看日志信息,内容如下: Caused by: javax.resource.ResourceException: javax.resource.ResourceException: java.sql.SQLException: IO Error: Socket read timed out at com.apusic.connector.cxmgr.ConnectionPoolV2NoMatchImpl.findResource(ConnectionPoolV2NoMatchImpl.java:63) at com.apusic.connector.cxmgr.AbstractConnectionPoolImplV2.getConnection(AbstractConnectionPoolImplV2.java:104) at com.apusic.connector.cxmgr.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:90) at com.apusic.jdbc.adapter.JdbcDataSource.getConnection(JdbcDataSource.java:93) ... 15 more Caused by: javax.resource.ResourceException: java.sql.SQLException: IO Error: Socket read timed out at com.apusic.jdbc.adapter.DriverManagedConnectionFactory.createManagedConnection(DriverManagedConnectionFactory.java:79) at com.apusic.connector.cxmgr.ResourceHandler.create(ResourceHandler.java:93) at com.apusic.connector.cxmgr.TxResourceHandler.create(TxResourceHandler.java:50) at com.apusic.connector.cxmgr.ConnectionPoolV2NoMatchImpl.findResource(ConnectionPoolV2NoMatchImpl.java:60) 1.4.查看数据库警告日志,有频繁报错连接关闭的信息: Fatal NI connect error 12537, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for Linux: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production Time: 18-OCT-2021 14:47:41 Tracing not turned on. Tns error struct: ns main err code: 12537 TNS-12537: TNS:connection closed ns secondary err code: 12560 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 opiodr aborting process unknown ospid (13498) as a result of ORA-609 2.**解决方案** 2.1.怀疑是数据库监听的问题,将监听重启后仍然不行。改为静态监听,重启数据库后,仍然报错。 ![image.webp](/download/0100cae98b608944408d9e0f91a27da9e56b.webp) 2.2.查看$ORACLE_HOME/network/admin/tnsname.ora文件,发现实例名与服务名与listener.ora文件中的不一致。Oracle实例名为K3,服务名为k3db; 经过调整监听为k3和k3db,并修改服务名: alter system set services_name='k3db','K3'解决了监听问题,客户端能够正常登陆了。 **3.问题总结** 如果在同一台电脑搭建了两套测试环境,要注意数据库的实例名与服务名要对应进行修改,否则客户端无法连接到对应的数据库。

(EAS850版本)客户端登陆报错获取用户信息失败

**1.问题描述**1.1.EAS85版本输入密码后报错获取用户信息失败,如下图所示:![image.webp](/download/01005811afb4534242f9997a19faba04aea...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息