日期:2014-05-18  浏览次数:20990 次

ORA-01017: invalid username/password; logon denied
tomcat在启动的最后就会报这个错误,搞了半天解决不了,用户名和密码都是对的
求大神指点
我的项目数据库原来是oracle10g的,导出方案后现在又导入到oracle11g,用户也是新建的,并赋予connect和resource权限,是权限的问题嘛

java.sql.SQLException: ORA-01017: invalid username/password; logon denied

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:277)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:790)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:361)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:438)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
DEBUG 2012-09-29 11:58:21,101 com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask: An exception occurred while acquiring a poolable resource. Will retry.

上面是完整的错误信息
我的用户名和密码是对的

#**********db set***************#
driverClassName=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@localhost:1521:myora
username=kael
password=kael
minPoolSize=5
maxPoolSize=50
maxIdleTime=1800
acquireIncrement=3
maxStatements=1000
initialPoolSize=5
idleConnectionTestPeriod=60
acquireRetryAttempts=30
testConnectionOnCheckout=false
breakAfterAcquireFailure=false
acquireRetryDelay=100



<context:property-placeholder location="classpath:db.properties,classpath:constant.properties" ignore-unresolvable="true"/>

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<property name="driverClass">
<value>${driverClassName}</value>
</property>
<property name="jdbcUrl">
<value>${url}</value>
</property>
<property name="user">
<value>${username}</value>
</property>
<property name="password">
<value>${password}</value>
</property>
<!--连接池中保留的最小连接数。 -->
<property name="minPoolSize">