(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...
点击下载文档
本文2024-09-22 20:22:12发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-113191.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章