如何通过网络访问Oracle数据库? [英] How to access Oracle database over network?

问题描述

我正在尝试通过网络访问我的Oracle数据库.我有很多Google，并且找到了很多解决方案，但是这些解决方案对我不起作用.

I am trying to accessing my Oracle database over Network. I have Google a lot and found many solutions, but those doesn't work for me.

问题是，我想通过本地网络将Oracle数据库从一台计算机访问到另一台计算机.

The problem is that, I want to access my Oracle Database from One Computer to another Computer over my Local Network.

我所做的是......

What I did is....

1. 我找到了使用
修改 listener.ora 文件的解决方案

1. I found a Solution to modify listener.ora file with

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbp.devProject.com)(PORT=1521)))

当我修改此文件并尝试运行和访问数据库时，将不会发生任何事情，并且会引发错误，您指定的端口号已被另一个侦听器使用，因此我更改了端口号，但我无法访问数据库. 2.我已经在Oracle工具 Net Manager 的帮助下配置了一个新的侦听器，该工具为我创建了一个侦听器，但是它无法通过网络访问数据库.

When I modify this file and tried to run and access the Database nothing will happens, and it throws an Error, the port number you have specified is used by another listener, so i have changed port Number but I am not able to access Database. 2. I have configure a new listener with the help of oracle's tool Net Manager, which made a Listener for me, but it does not make accessible database over Network.

这里有一些必要的结果.

Here Some required results.

1. lsnrctl状态:使用监听器名称LISTENER的监听器已经启动.
2. 连接字符串:jdbc:oracle:thin:@ dbp.devProject.com:4541:myDB
3. 数据库版本:

1. lsnrctl status : Listener using listener name LISTENER has already been started.
2. Connection String : jdbc:oracle:thin:@dbp.devProject.com:4541:myDB
3. Database Version :

1. Oracle数据库11g企业版11.2.0.1.0版-64位生产
2. PL/SQL版本11.2.0.1.0-生产
3. CORE 11.2.0.1.0生产
4. 用于64位Windows的TNS:版本11.2.0.1.0-正式版
5. NLSRTL版本11.2.0.1.0-生产

1. Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
2. PL/SQL Release 11.2.0.1.0 - Production
3. CORE 11.2.0.1.0 Production
4. TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
5. NLSRTL Version 11.2.0.1.0 - Production

状态向我显示了这一点.

status shows me this.

连接到(DESCRIPTION =(地址=(PROTOCOL = IPC)(KEY = EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

聆听者的状态

Alias:聆听者

版本:64位Windows的TNSLSNR:版本11.2.0.1.0-生产

Version : TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production

开始日期:2015年5月14日11:58:05

Start Date : 14-MAY-2015 11:58:05

正常运行时间:0天2小时. 29分钟50秒

Uptime : 0 days 2 hr. 29 min. 50 sec

跟踪级别:关闭

安全性:ON:本地操作系统身份验证

Security : ON: Local OS Authentication

SNMP:关闭

侦听器参数文件:product \ 11.2.0 \ dbhome_1 \ network \ admin \ listener.ora

Listener Parameter File : product\11.2.0\dbhome_1\network\admin\listener.ora

侦听器日志文件:\ listener \ alert \ log.xml

Listener Log File : \listener\alert\log.xml

监听端点摘要...

1. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
2. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

请有人帮帮我. 感谢您的帮助.

Someone please Help me. Thanks for your Help..

推荐答案

在为数据库创建远程访问时遇到此类错误时，请执行以下操作.

Whenever you are sufering with this kind of errors while creating remote access for you database, do following things before.

1. 使用Oracle的 Net Manager 工具创建侦听器或手动创建它.
2. 生成监听器后，检出"listener.ora" [位于:ORACLE_INSTALLED_DIR \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN] 文件，供您输入. (是否有您之前创建的用于侦听器的任何条目.如果找到条目，然后执行下一步，否则从FIRST步骤开始.)
3. 如果找到了用于侦听器的条目，请打开命令提示符并触发命令lsnrctl status.这将为您提供所有当前正在运行的侦听器列表，找出您之前创建的侦听器列表.
4. 为监听器检出Host Name和Port Number.
5. 根据您在lsnrctl status
中找到的详细信息生成连接字符串
6. 连接数据库，您可以从网络中的任何位置访问数据库.

1. Create a Listener using Net Manager tool of Oracle or create it Manually.
2. After generating Listener, check out "listener.ora" [Located : ORACLE_INSTALLED_DIR\product\11.2.0\dbhome_1\NETWORK\ADMIN] file, for your entry. (is there any Entry for the Listener which you have created just before. If you found your Entry than and than do next steps otherwise do it from FIRST step.)
3. If you found the Entry for your Listener, Open Command Prompt and fire command lsnrctl status. This will give you all currently running Listeners List, find out the one which you created just before.
4. Check out the Host Name and Port Number for your Listener.
5. Generate the Connection String as per the details you found in lsnrctl status
6. Connect with Database, and You can access the Database from anywhere in your Network.

享受事物，一些挑战需要努力，一旦跌倒，它将永远无法解决.

Enjoy the Things, Some challenges needs Afforts, Once you fall back from it, it will be never solved.

我真的很感谢那些回答并评论了这个问题的家伙，所有这些材料使我的挑战变得容易.

I am really thankful to those all Guys who answered and Commented to this Question, this all Material made my Challenge easy..

谢谢@ Alex，@ Lalit，@ TenG和@ S.Krishna 非常感谢你们.

Thank You @Alex, @ Lalit, @TenG and @S.Krishna Thank You so Much Guys.

这篇关于如何通过网络访问Oracle数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！