- 最后登录
- 2017-8-28
- 在线时间
- 5 小时
- 威望
- 0
- 金钱
- 42
- 注册时间
- 2017-7-17
- 阅读权限
- 10
- 帖子
- 13
- 精华
- 0
- 积分
- 0
- UID
- 2510
|
1#
发表于 2017-8-28 11:19:40
|
查看: 9160 |
回复: 1
数据库迁移前没有问题。迁移前版本为ORACLE 12.1。
数据库从oracle 12.1迁移到12.2之后,就出问题了。
应用服务器tomcat 7 出现如下报错信息:
WARN [C3P0PooledConnectionPoolManager[identityToken->z8kflt9q9wxdmy19phde9|74a05624]-HelperThread-#0] com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$WarnLogger.log(211) | Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@46d43ad1 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
WARN [localhost-startStop-1] org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(204) | HHH000342: Could not obtain connection to query metadata : Connections could not be acquired from the underlying database!
INFO [localhost-startStop-1] org.hibernate.dialect.Dialect.<init>(145) | HHH000400: Using dialect: org.hibernate.dialect.OracleDialect
WARN [localhost-startStop-1] org.hibernate.dialect.Oracle9Dialect.<init>(69) | HHH000063: The Oracle9Dialect dialect has been deprecated; use either Oracle9iDialect or Oracle10gDialect instead
WARN [C3P0PooledConnectionPoolManager[identityToken->z8kflt9q9wxdmy19phde9|74a05624]-HelperThread-#1] com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$WarnLogger.log(214) | com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@21dd2126 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
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 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)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1127)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1114)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1855)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
自己修改过sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
修改sqlnet.ora之后报错信息变成:java.sql.SQLException: ORA-01017: invalid username/password; logon denied
确认过该连接用户名和密码都能够连接,用sqlplus测试的。
请教一下如何诊断?
|
|