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

问题描述

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

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应用程序，可以连接云DB机器.我试图在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扩展到数据库机中的服务名称.还是给同样的错误.在我们设置的另一台云计算机上，相同的代码可以正常工作.但是这台云机器是由甲骨文团队完成的，默认情况下，大多数事情都是

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 

希望这对您有所帮助.

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