如何使用sqlplus或sql开发人员云连接连接到Azure Oracle 12c数据库 [英] How to connect to Azure Oracle 12c Database using sqlplus or sql developer cloud connection

问题描述

我有2个虚拟机，其中一个是DB服务器，另一个是Web服务器.

I have 2 VM in azure one is a DB server and the other is a web server.

我可以同时获得这些服务器的远程桌面连接，并且Web服务器可以连接到数据库wih

I can get remote desktop connection for both these servers and web server can connect to Database wih

sqlplus user/password@internal_network_ip:port/sid

但是，我无法从本地系统连接到Cloud DB. 我尝试过

But however I cannot connect to Cloud DB from my local system. I tried

sqlplus user/password@internal_ip:8552/sid
ORA-12170: TNS:Connect timeout occurred
sqlplus user/[e-mail]:8552/sid  -- oracle port
ORA-12170: TNS:Connect timeout occurred
sqlplus user/[e-mail]:54955/sid -- port for cloud system used when taking remote desktop connection
ORA-12547: TNS:lost contact
sqlplus user/password@server_hostname:8552/sid
ORA-12154: TNS:could not resolve the connect identifier specified

但是我无法连接到数据库

However I cannot connect to the Database

我要去哪里错了?

推荐答案

您很可能需要在已将Oracle DB部署到的云服务上打开一个端点.我建议您将公用端口设置为默认Oracle端口以外的其他端口.

You most likely need to open an endpoint on the cloud service into which your Oracle DB has been deployed. I would recommend you make the public port something other than the default Oracle port.

请参见 Azure文档站点获取有关如何创建端点的说明.

See the Azure documentation site for instructions on how to create endpoint.

这篇关于如何使用sqlplus或sql开发人员云连接连接到Azure Oracle 12c数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！