如何在LAN PC中连接ORACLE数据库? [英] How to connect ORACLE database in LAN PC?

问题描述

我有计算机A，IP = 10.20.30.40(用于存储Oracle数据库)

我有计算机B，IP = 10.20.30.44(与我要连接的这台计算机)

我已经使用了连接字符串
数据源= LOCALHOST，用户= SYSTEM，密码= xxxxx

它在计算机A中可以正常工作.即使我也可以将其连接为
数据源= 10.20.30.40，用户= SYSTEM，密码= xxxxx


如何从计算机B连接到计算机A?


电脑B应该有什么要求?
或
我需要更改tnsnames.ora?
我的tnsnames.ora包含类似..
的信息

Hi,

I have Computer A , IP = 10.20.30.40 (that store the Oracle Database)

I have Computer B , IP = 10.20.30.44 (with this computer i want to connect)

i have used connection string
Data Source = LOCALHOST , User = SYSTEM , Password = xxxxx

its works fine in Computer A. Even i can connect it as
Data Source = 10.20.30.40 , User = SYSTEM , Password = xxxxx


How I can Connect from Computer B - to - Computer A ?


What are the requirements for Computer B Should have??
or
i need to Change tnsnames.ora ??
my tnsnames.ora contains info like..

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = TOPAZ)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

在这里我需要进行更改吗?
我是oracle的新手，请帮帮我...

Thenk for all Help

Here where could i need to make changes??
I''m newer to oracle Please help me out...

Thenk''s for any Help

推荐答案

也许这会有所帮助:

Oracle常见问题解答 [ ^ ]

如果不是，则google是您的游乐场.

Maybe this will help:

Oracle FAQ[^]

If not, google is your playground.

u只能在lan中只能连接到该数据库的任何系统中指定目标oracle数据库服务器名称

使用oracleclient类与oracle db进行交互

u can just specify the destination oracle db server name in any system which r in lan can connect to that db only

use oracleclient class to interact with oracle db

感谢您的支持人员.
现在我很清楚tnsnames.ora

我的错误是

XE =
(说明=
(地址=(协议= TCP)(主机= TOPAZ)(端口= 1521))
(CONNECT_DATA =
(服务器=专用)
(SERVICE_NAME = XE)
)
)


在XE数据源中，我需要提供当前的IP并将其配置为
XE =
(说明=
(地址=(协议= TCP)(主机= 198.233.6.7)(端口= 1521))
(CONNECT_DATA =
(服务器=专用)
(SERVICE_NAME = XE)
)
)

如果要检查数据库是否已连接，
在cmdprompt
c:/> tnsping XE
它应该回复
OK< ;;>
那就表示您的连接正常...

编码愉快...

干杯.，
Karthick

Thanks for your support guys..

Now i''m clear with tnsnames.ora

my mistake is

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TOPAZ)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)


In XE datasource i need to give my current IP and configure it as
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 198.233.6.7)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

If you want to check whether your Database is connected,
in cmdprompt
c:/>tnsping XE
it should reply
OK<;>
Then it means your connection is works fine...

Happy coding...

Cheers.,
Karthick

这篇关于如何在LAN PC中连接ORACLE数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！