Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

5

主题
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测试的。

请教一下如何诊断?



2#
发表于 2017-8-28 13:05:33
更换tomcat 7的jdbc驱动后恢复。
之前jdbc驱动是oracle-jdbc6.jar
更换成oracle-jdbc7.jar

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 01:53 , Processed in 0.047969 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569