ORA-01017错误无法解决

jdbc连接数据库，代码如下
<datasource type="jdbc">
    <jndi name="java:comp/env/call" />
    <jdbc driver="oracle.jdbc.driver.OracleDriver"
           url="jdbc:oracle:thin:@127.0.0.1:1521:orcl"
           user="system" password="manager"/>
  </datasource>
使用sqlplus，plsql都可以使用system/manager登录，但jsp应用页面调用时显示连接数据库错误：ORA-01017: invalid username/password; logon denied (jdbc:oracle:thin:@127.0.0.1:1521:orcl)
eclipse控制台信息：
SEVERE: java.lang.RuntimeException: 连接数据库错误：ORA-01017: invalid username/password; logon denied
(jdbc:oracle:thin:@127.0.0.1:1521:orcl)
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied这是什么原因

解决方案 »

  1.   

    你的版本应该是11G...11G的版本的密码是大小写敏感....这个特性太操蛋了...TOMCAT在登录的时候可能会修改密码的大小写,这个特性也太操蛋了,你明明提交的是system可能到了数据库就变成SYSTEM两个操蛋的事情碰到一起,建议在数据库上使用alter system set sec_case_sensitive_logon=false
      

  2.   


    谢谢楼上，01017更改后好了，不过出现了一个新错误“连接数据库错误：OAUTH 编集失败(jdbc:oracle:thin:@127.0.0.1:1521:orcl”
      

  3.   

    错误信息贴全点、
    jar包有误？
      

  4.   

    是这些
    INFO: Initializing, config='org.apache.struts.taglib.logic.LocalStrings', returnNull=true
    六月 26, 2013 11:06:43 上午 org.apache.struts.util.PropertyMessageResources <init>
    INFO: Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
    六月 26, 2013 11:06:49 上午 hiker.common.exception.AppExceptionHandler execute
    INFO: Exception forward path=/login.jsp
    六月 26, 2013 11:06:49 上午 hiker.common.exception.AppExceptionHandler logExceptionStackTrace
    SEVERE: java.lang.RuntimeException: 连接数据库错误：OAUTH 编集失败(jdbc:oracle:thin:@127.0.0.1:1521:orcl)
    at hiker.common.db.DbUtils.getConnection(DbUtils.java:116)
    at hiker.common.db.DbUtils.getConnection(DbUtils.java:124)
    at hiker.common.db.DbUtils.getConnection(DbUtils.java:171)
    at hiker.common.db.DbUtils.getConnection(DbUtils.java:179)
    at hiker.common.db.Query.getMap(Query.java:504)
    at hiker.common.db.Query.getMap(Query.java:528)
    at hiker.partform.module.UserLogin.login(UserLogin.java:126)
    at hiker.partform.action.LoginAction.execute(LoginAction.java:67)
    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at hiker.common.filter.EncodeFilter.doFilter(EncodeFilter.java:60)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:724)
    Caused by: java.sql.SQLException: OAUTH 编集失败
    at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:663)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:359)
    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 java.sql.DriverManager.getConnection(DriverManager.java:571)
    at java.sql.DriverManager.getConnection(DriverManager.java:187)
    at hiker.common.db.DbUtils.getConnection(DbUtils.java:113)
    ... 32 more
      

  5.   

    是这些
    INFO: Initializing, config='org.apache.struts.taglib.logic.LocalStrings', returnNull=true
    六月 26, 2013 11:06:43 上午 org.apache.struts.util.PropertyMessageResources <init>
    INFO: Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
    六月 26, 2013 11:06:49 上午 hiker.common.exception.AppExceptionHandler execute
    INFO: Exception forward path=/login.jsp
    六月 26, 2013 11:06:49 上午 hiker.common.exception.AppExceptionHandler logExceptionStackTrace
    SEVERE: java.lang.RuntimeException: 连接数据库错误：OAUTH 编集失败(jdbc:oracle:thin:@127.0.0.1:1521:orcl)
    at hiker.common.db.DbUtils.getConnection(DbUtils.java:116)
    at hiker.common.db.DbUtils.getConnection(DbUtils.java:124)
    at hiker.common.db.DbUtils.getConnection(DbUtils.java:171)
    at hiker.common.db.DbUtils.getConnection(DbUtils.java:179)
    at hiker.common.db.Query.getMap(Query.java:504)
    at hiker.common.db.Query.getMap(Query.java:528)
    at hiker.partform.module.UserLogin.login(UserLogin.java:126)
    at hiker.partform.action.LoginAction.execute(LoginAction.java:67)
    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at hiker.common.filter.EncodeFilter.doFilter(EncodeFilter.java:60)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:724)
    Caused by: java.sql.SQLException: OAUTH 编集失败
    at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:663)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:359)
    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 java.sql.DriverManager.getConnection(DriverManager.java:571)
    at java.sql.DriverManager.getConnection(DriverManager.java:187)
    at hiker.common.db.DbUtils.getConnection(DbUtils.java:113)
    ... 32 more没看懂、alert.log最后几行能贴上来看看吗
      

  6.   

    好的，这个是前面的：
    六月 26, 2013 3:32:46 下午 org.apache.catalina.core.AprLifecycleListener init
    INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: D:\Program Files\Java\jdk1.7.0_25\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;E:\Oracle\product\11.2.0\dbhome_1\bin;E:\app\STAR\product\11.2.0\dbhome_1\bin;C:\Program Files (x86)\Common Files\NetSarang;D:\oracle\product\10.2.0\db_2\bin;D:\oracle\product\10.2.0\db_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Common Files\Thunder Network\KanKan\Codecs;D:\Program Files\Java\jdk1.7.0_25\bin;D:\Program Files\Java\jdk1.7.0_25\jre\bin;E:\QtSDK\mingw\bin;D:\Program Files\Java\jdk1.7.0_25\bin;E:\QtSDK\Desktop\Qt\4.7.4\mingw\bin;.
    六月 26, 2013 3:32:46 下午 org.apache.tomcat.util.digester.SetPropertiesRule begin
    WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:Hkpf' did not find a matching property.
    六月 26, 2013 3:32:46 下午 org.apache.coyote.AbstractProtocol init
    INFO: Initializing ProtocolHandler ["http-bio-8000"]
    六月 26, 2013 3:32:46 下午 org.apache.coyote.AbstractProtocol init
    INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
    六月 26, 2013 3:32:46 下午 org.apache.catalina.startup.Catalina load
    INFO: Initialization processed in 1127 ms
    六月 26, 2013 3:32:46 下午 org.apache.catalina.core.StandardService startInternal
    INFO: Starting service Catalina
    六月 26, 2013 3:32:46 下午 org.apache.catalina.core.StandardEngine startInternal
    INFO: Starting Servlet Engine: Apache Tomcat/7.0.41
    六月 26, 2013 3:32:49 下午 org.apache.catalina.startup.TaglibUriRule body
    INFO: TLD skipped. URI: http://jakarta.apache.org/struts/tags-bean is already defined
    六月 26, 2013 3:32:49 下午 org.apache.catalina.startup.TaglibUriRule body
    INFO: TLD skipped. URI: http://jakarta.apache.org/struts/tags-html is already defined
    六月 26, 2013 3:32:49 下午 org.apache.catalina.startup.TaglibUriRule body
    INFO: TLD skipped. URI: http://jakarta.apache.org/struts/tags-logic is already defined
    六月 26, 2013 3:32:49 下午 org.apache.catalina.startup.TaglibUriRule body
    INFO: TLD skipped. URI: http://jakarta.apache.org/struts/tags-nested is already defined
    六月 26, 2013 3:32:49 下午 org.apache.catalina.startup.TaglibUriRule body
    INFO: TLD skipped. URI: http://jakarta.apache.org/struts/tags-template is already defined
    六月 26, 2013 3:32:49 下午 org.apache.catalina.startup.TaglibUriRule body
    INFO: TLD skipped. URI: http://jakarta.apache.org/struts/tags-tiles is already defined
    六月 26, 2013 3:32:50 下午 org.apache.struts.util.PropertyMessageResources <init>
    INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
    六月 26, 2013 3:32:50 下午 org.apache.struts.util.PropertyMessageResources <init>
    INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
    六月 26, 2013 3:32:50 下午 org.apache.struts.util.PropertyMessageResources <init>
    INFO: Initializing, config='ApplicationResources', returnNull=true
    六月 26, 2013 3:32:50 下午 org.apache.coyote.AbstractProtocol start
    INFO: Starting ProtocolHandler ["http-bio-8000"]
    六月 26, 2013 3:32:50 下午 org.apache.coyote.AbstractProtocol start
    INFO: Starting ProtocolHandler ["ajp-bio-8009"]
    六月 26, 2013 3:32:50 下午 org.apache.catalina.startup.Catalina start
    INFO: Server startup in 3496 ms
    六月 26, 2013 3:32:51 下午 org.apache.struts.util.PropertyMessageResources <init>
    INFO: Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
    六月 26, 2013 3:32:51 下午 org.apache.struts.util.PropertyMessageResources <init>
    INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
    六月 26, 2013 3:32:51 下午 org.apache.struts.util.PropertyMessageResources <init>
    INFO: Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
    六月 26, 2013 3:32:51 下午 org.apache.struts.util.PropertyMessageResources <init>
    INFO: Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
    六月 26, 2013 3:32:51 下午 org.apache.struts.util.PropertyMessageResources <init>
    INFO: Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
    六月 26, 2013 3:32:51 下午 org.apache.struts.util.PropertyMessageResources <init>
    INFO: Initializing, config='org.apache.struts.taglib.logic.LocalStrings', returnNull=true
    六月 26, 2013 3:32:51 下午 org.apache.struts.util.PropertyMessageResources <init>
    INFO: Initializing, config='org.apache.struts.taglib.logic.LocalStrings', returnNull=true
    六月 26, 2013 3:32:51 下午 org.apache.struts.util.PropertyMessageResources <init>
    INFO: Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
    六月 26, 2013 3:32:58 下午 hiker.common.exception.AppExceptionHandler execute
    INFO: Exception forward path=/login.jsp
    六月 26, 2013 3:32:58 下午 hiker.common.exception.AppExceptionHandler logExceptionStackTrace
    SEVERE: java.lang.RuntimeException: 连接数据库错误：OAUTH 编集失败(jdbc:oracle:thin:@127.0.0.1:1521:orcl)
    at hiker.common.db.DbUtils.getConnection(DbUtils.java:116)
      

  7.   

    谢谢各位，原因找到了，是resources.xml的问题
      

  8.   

    不过ojdbc包使用不当确实会带来ORA-01017的错误，调试时用过class12.jar和ojdbc6.jar，11g环境下当ojdbc6.jar使用正常时class12.jar就会造成这个错误