是否可以使用 SQL 开发人员连接到 RDS Oracle 数据库实例?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/31064031/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-19 02:55:57  来源:igfitidea点击:

Is possible to connect to RDS Oracle DB instance with SQL developer?

oracleamazon-web-servicessshoracle-sqldeveloperamazon-rds

提问by Carlos Enrique Medina Figueroa

I'm trying to connect into my mac with the endpoint that AWS give me but i can't.

我正在尝试使用 AWS 给我的端点连接到我的 Mac,但我不能。

回答by Damith Ganegoda

Yes, You can.

是的你可以。

These are the AmazonRDS settings.

这些是 AmazonRDS 设置。

AWS RDS settings

AWS RDS 设置

and this is the SQL Developer connection window

这是 SQL Developer 连接窗口

enter image description here

在此处输入图片说明

database host name should be the AWS endpoint & SID should be the AWS DB Name.

数据库主机名应该是 AWS 端点,SID 应该是 AWS 数据库名称。

回答by WisdmLabs

You can connect to database instance in RDS by using the endpoint and the credentials associated with the rds instance

您可以使用端点和与 rds 实例关联的凭据连接到 RDS 中的数据库实例

Refer the below link for guidance:

请参阅以下链接以获取指导:

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_GettingStarted.CreatingConnecting.Oracle.html

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_GettingStarted.CreatingConnecting.Oracle.html

Also ensure that the security group associated with the RDS instance has appropriate port open for oracle connection.

还要确保与 RDS 实例关联的安全组为 oracle 连接打开了适当的端口。