Io 异常:Oracle 云中的 Oracle 错误 ORA-12650 [英] Io exception: Oracle Error ORA-12650 in Oracle Cloud

问题描述

我一直在为我的 DB 机器(Oracle 11g)使用 Oracle 云 PAAS linux 服务器，并拥有 linux 应用程序服务器，我可以在其中运行我所有的 Java 应用程序.

I have been using Oracle cloud PAAS linux server for my DB machine (Oracle 11g) and having linux application server where i can run all my Java applications.

假设我有可以连接云数据库机器的基于 spring 的 Web 应用程序.我曾尝试访问 Toad 中的模式 for oracle，它按预期工作，但是当我尝试访问数据库以从应用程序检索数据时，它给出以下错误.

Assume i have spring based web application which can connect cloud DB machine. I have tried to access the schema in Toad for oracle, it is working as expected but when i try to hit the DB for retrieving the data from application it gives below error.

java.sql.SQLException: Io exception: Oracle Error ORA-12650
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:154)
    at GetConnection.main(GetConnection.java:35)

我还尝试将服务访问从 SID 扩展到 DB 机器中的服务名称.仍然给出同样的错误.相同的代码在我们设置的另一台云机器上运行良好.但是这台云机是oracle团队做的，大部分都是默认的.

I have also tried to extend the service access from SID to service name in DB machine. Still give same error. Same code works fine in another cloud machine, which was set by us. But this cloud machine was done by oracle team and most of the things are by default.

请分享您解决此问题的建议.

Please share your suggestion to fix this issue.

推荐答案

这个问题是因为 Oracle DB 机器加密 ENCRYPTION_SERVER 设置.据我所知，这是默认设置并将其设置为启用，当我们将其设置为 disabled 或注释该行时，应用程序将按预期工作.下面是文件名供参考，

This issue is because of Oracle DB machine encryption ENCRYPTION_SERVER settings. As i understood which is default and set it to enabled, when we set it to disabled or comment the line then application will work as expected. Below is the file name for reference,

Filename : sqlnet.ora (We have to disable ENCRYPTION_SERVER settings)
File Location : ../oracle/product/11.2.0/dbhome_1/network/admin 

希望这对某人有所帮助.

Hope this helps some one.!

这篇关于Io 异常:Oracle 云中的 Oracle 错误 ORA-12650的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！