How to connect ORACLE database in LAN PC?

Question

4.00/5 (1 vote)

See more:

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)
    )
  )

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

Thenk's for any Help

Posted 17-Jun-11 2:34am

J.Karthick

Updated 17-Jun-11 2:40am

Tarun.K.S

v2

Add a Solution

Comments

J.Karthick 17-Jun-11 8:36am

I used ORACLE10G...forgot to mention it...

3 solutions

Solution 1

Maybe this will help:

Oracle FAQ[^]

If not, google is your playground.

Posted 17-Jun-11 2:46am

#realJSOP

Solution 3

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

Posted 21-Jun-11 1:07am

J.Karthick

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Srinivas Kumar Pasumarthi · Accepted Answer · 2011-06-17T02:57:00

Solution 2

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

Posted 17-Jun-11 2:57am

Srinivas Kumar Pasumarthi

How to connect ORACLE database in LAN PC?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

How to connect ORACLE database in LAN PC?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us