如何远程连接到Oracle 11g数据库 [英] How to connect to Oracle 11g database remotely

问题描述

我在计算机A上安装了Oracle 11g XE.我可以使用命令connect username/password通过sql命令行进行连接.我还可以将SQL指令发送到Demo数据库:Select * from demo_customers;

数据库正在计算机A的本地主机上运行.

我希望计算机B连接到本地主机上计算机A的数据库.我该怎么办?

解决方案

您将需要在服务器A上运行lsnrctl实用程序以启动侦听器.然后，您将使用以下语法从计算机B连接:

sqlplus username/password@hostA:1521 /XE

如果使用默认值1521，则端口信息是可选的.

此处的监听器配置文档. 此处的远程连接文档.

I have Oracle 11g XE installed on computer A. I can connect through the sql command line using the command connect username/password. I also can send SQL instructions to the Demo database: Select * from demo_customers;

The database is running on localhost of computer A.

I want computer B to connect to computer A's database on localhost. How can I do that?

解决方案

You will need to run the lsnrctl utility on server A to start the listener. You would then connect from computer B using the following syntax:

sqlplus username/password@hostA:1521 /XE

The port information is optional if the default of 1521 is used.

Listener configuration documentation here. Remote connection documentation here.

这篇关于如何远程连接到Oracle 11g数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！