在 Oracle SQL Developer Tool 中创建 localhost 连接

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/22036904/
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:15:28  来源:igfitidea点击:

create localhost connection in Oracle SQL Developer Tool

sqloracle

提问by user3331920

I want to create localhost connection in Oracle SQL Developer tool my credentials are

我想在 Oracle SQL Developer 工具中创建 localhost 连接,我的凭据是

username : SYSTEM
password : SYSTEM
Hostname :localhost or 127.0.0.1
port     : 1521
sid      : xe

When i connect i gives error The Network Adapter could not establish connection

当我连接时出现错误网络适配器无法建立连接

回答by Nagaraj S

The Network Adapter could not establish connection is caused because:

网络适​​配器无法建立连接的原因是:

  1. The database host name or port number is wrong.
  2. The listener process (service) is not running. You can re-start it with the "lsnrctl start" command or on Windows by starting the listener service.
  1. 数据库主机名或端口号错误。
  2. 侦听器进程(服务)未运行。您可以使用“lsnrctl start”命令或在 Windows 上通过启动侦听器服务来重新启动它。

回答by Amarnath Balasubramanian

you have either the wrong SQL Developer URL or you have a basic SQL*Net connectivity issue! This error is most likely caused by one of these factors:

您要么使用了错误的 SQL Developer URL,要么遇到了基本的 SQL*Net 连接问题!此错误很可能是由以下因素之一引起的:

  • You are using the wrong URL

  • The wrong port number or IP address (or DNS host name) was used

  • The listener is not configured properly

  • The listener process (service) is not running. You can re-start it with the "lsnrctl start" command or on Windows by starting the listener service.

  • 您使用了错误的网址

  • 使用了错误的端口号或 IP 地址(或 DNS 主机名)

  • 监听器配置不正确

  • 侦听器进程(服务)未运行。您可以使用“lsnrctl start”命令或在 Windows 上通过启动侦听器服务来重新启动它。

For a step by step checklist, see the notes on troubleshooting an Oracle connection problem.

有关分步检查清单,请参阅有关对 Oracle 连接问题进行故障排除的说明。