64位weblogic 32位oracle数据库
我在 64 位 Linux 上安装了 64 位 Weblogic 11g,并尝试通过在 32 位上为 Oracle 10g 创建 JDBC 数据源来连接到数据库。我已将另一个 Weblogic 32 位成功连接到此数据库实例。
但是,对于 64 位 Weblogic,我遇到了异常
Connection test failed.
ORA-01017: invalid username/password; logon denied
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:799)
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:368)
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:2
,我想知道它是否也需要 64 位 Oracle 数据库?我的用户名和密码是正确的。
I have 64 bit Weblogic 11g installed on 64 bit Linux and trying to connect to a DB by creating a JDBC data source for Oracle 10g on 32 bit. I have connected another Weblogic 32 bit successfully to this DB instance.
However, for the 64 bit Weblogic I am getting exception
Connection test failed.
ORA-01017: invalid username/password; logon denied
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:799)
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:368)
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:2
I am wondering does it need 64 bit Oracle database as well? My username and password are correct.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(4)
意识到这是相当旧的,但是请坐...
如果客户端和服务器是不同的版本,它应该没有任何区别。您正在建立连接,否则您会看到比 ORA-01017 更致命的东西。我想知道 JDBC 配置是否是从 32 位 WebLogic 实例复制的,并且您假设因为它在那里工作,所以不需要更改配置。如果是这种情况,则加密后的密码错误;加密密钥与安装相关联,因此您不能只复制文件而不更新它。尝试使用您认为应该使用的值运行
java weblogic.security.Encrypt
,并查看该值是否与配置文件中存储的 3DES 值匹配。Realise this is rather old, but sitll...
It shouldn't make any difference if the client and server are different versions. You are getting a connection, otherwise you'd see something more fatal than an ORA-01017. I'm wondering if the JDBC config was copied from the 32-bit WebLogic instance, and you're assuming that because it works there the config doesn't need to be changed. If that is the case, the encrypted password will be wrong; the encryption key is linked to the installation, so you can't just copy the file without updating it. Try running
java weblogic.security.Encrypt <password>
with the value you think it should be using, and see if that matches the 3DES value stored in the config file.不,数据库不需要是 64 位。正如@Alex 提到的,您正在成功与数据库对话,这只是一个凭证问题。您是否可以尝试更新连接池的用户和密码(特别是如果您将
domain\config\jdbc
下的文件从一个域复制到另一个域)?No, the database doesn't need to be 64 bit. As @Alex mentioned, you are successfully talking to the db, this is just a credentials problem. Can you try to update the user and password of your connection pool (especially if you copied files under
domain\config\jdbc
from one domain to the other)?这是当您尝试访问的用户未在 Oracle 中成功通过身份验证时引发的 Oracle 错误。尝试重置您正在尝试的用户和密码,或者使用连接正常的其他用户并尝试。
This is an Oracle error thrown when the user with which you are trying to access is not getting authenticated successfully in Oracle. Try to reset the user and password which you are trying or use a different user which is connecting fine and try that.
您的 Weblogic 应用程序服务器上是否安装并运行了 64 位版本的 Java 以及 64 位 Oracle 客户端?
Do you have the 64 bit version of Java installed and running on your Weblogic application server as well as the 64 bit Oracle client?