oracle.net.ns.NetException: Unexpected packet。

这是什么错误,程序连接另一个oracle,运行正常,换了一个oracle就报错了。

2021-03-02 15:33:36,482 [471304833@qtp-897422675-2] ERROR 500.jsp                                

 -PreparedStatementCallback; SQL [select u.uuid u.account,u.deptId,u.authName,u.passwd,u.authother2,u.authother1,u.birthday,u.phone,u.authother0,u.isValid,u.sso,u.caImage,u.deptCodeTree,u.usertype userType,u.deptCode,u.deptId,d.authName deptName,(SELECT count(1) FROM AUTH_USERDEPT WHERE USERID=u.uuid) scope  from AUTH_MODEL_USER u left join AUTH_MODEL_DEPT d on u.deptCode=d.AUTHOTHER0 where upper(u.account)=?]; IO 错误: Unexpected packet; nested exception is java.sql.SQLException: IO 错误: Unexpected packet
org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select u.uuid id,u.account,u.deptId,u.authName,u.passwd,u.authother2,u.authother1,u.birthday,u.phone,u.authother0,u.isValid,u.sso,u.caImage,u.deptCodeTree,u.usertype userType,u.deptCode,u.deptId,d.authName deptName,(SELECT count(1) FROM AUTH_USERDEPT WHERE USERID=u.uuid) scope  from AUTH_MODEL_USER u left join AUTH_MODEL_DEPT d on u.deptCode=d.AUTHOTHER0 where upper(u.account)=?]; IO 错误: Unexpected packet; nested exception is java.sql.SQLException: IO 错误: Unexpected packet
    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)
    at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:733)
    at com.vingsoft.jsec.cac.service.security.JsecServiceDBImpl.getUserByLoginName(JsecServiceDBImpl.java:64)
    at com.vingsoft.jsec.cac.service.security.UserDetailsServiceImpl.loadUserByUsername(UserDetailsServiceImpl.java:50)
    at com.vingsoft.jsec.cac.service.security.UserDetailsServiceImpl$$FastClassByCGLIB$$9eef634e.invoke(<generated>)
    at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
    at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
    at com.vingsoft.jsec.cac.service.security.UserDetailsServiceImpl$$EnhancerByCGLIB$$5ad597e8.loadUserByUsername(<generated>)
    at org.springframework.security.core.userdetails.UserDetailsByNameServiceWrapper.loadUserDetails(UserDetailsByNameServiceWrapper.java:53)
    at org.springframework.security.cas.authentication.CasAuthenticationProvider.loadUserByAssertion(CasAuthenticationProvider.java:149)
    at org.springframework.security.cas.authentication.CasAuthenticationProvider.authenticateNow(CasAuthenticationProvider.java:132)
    at org.springframework.security.cas.authentication.CasAuthenticationProvider.authenticate(CasAuthenticationProvider.java:117)
    at org.springframework.security.authentication.ProviderManager.doAuthentication(ProviderManager.java:130)
    at org.springframework.security.authentication.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:48)
    at org.springframework.security.cas.web.CasAuthenticationFilter.attemptAuthentication(CasAuthenticationFilter.java:104)
    at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
    at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:110)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
    at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
    at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
    at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
    at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:399)
    at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
    at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
    at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
    at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
    at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
    at org.mortbay.jetty.Server.handle(Server.java:326)
    at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
    at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928)
    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
    at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
    at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
    at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
    at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: java.sql.SQLException: IO 错误: Unexpected packet
    at oracle.jdbc.driver.T4CConnection.getChars(T4CConnection.java:3009)
    at oracle.sql.CLOB.getChars(CLOB.java:402)
    at oracle.sql.CLOB.getSubString(CLOB.java:274)
    at oracle.jdbc.driver.T4CClobAccessor.getString(T4CClobAccessor.java:476)
    at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1118)
    at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:174)
    at org.springframework.jdbc.support.JdbcUtils.getResultSetValue(JdbcUtils.java:142)
    at org.springframework.jdbc.core.BeanPropertyRowMapper.getColumnValue(BeanPropertyRowMapper.java:308)
    at org.springframework.jdbc.core.BeanPropertyRowMapper.mapRow(BeanPropertyRowMapper.java:246)
    at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92)
    at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:1)
    at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
    ... 53 more
Caused by: oracle.net.ns.NetException: Unexpected packet
    at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:252)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
    at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:103)
    at oracle.jdbc.driver.T4CMAREngine.getNBytes(T4CMAREngine.java:1551)
    at oracle.jdbc.driver.T4C8TTILobd.unmarshalLobData(T4C8TTILobd.java:450)
    at oracle.jdbc.driver.T4C8TTILob.readLOBD(T4C8TTILob.java:767)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:349)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    at oracle.jdbc.driver.T4C8TTIClob.read(T4C8TTIClob.java:240)
    at oracle.jdbc.driver.T4CConnection.getChars(T4CConnection.java:2996)

这个错误是一个网络通信异常。可能是因为 Oracle 数据库出现了某些问题,比如网络不稳定、数据库繁忙等。建议通过检查数据库的错误日志和网络连接状况,以确定具体原因。另外,建议检查程序的代码是否存在错误,例如连接字符串等是否正确。如果需要进一步分析问题,请提供更详细的日志信息和代码。