Unable to connect remotely - Oracle 10g Express

Hello all,

I have recently installed Oracle 10g Express edition on my home network. While I am able to access it locally, using Oracle SQL Developer, I am unable to access the database from another machine on the network. I get the following error in SQL Developer:

Status:Failure -lo exception: the Network Adapter could not establish the connection

I "think" I have installed the required software on the remote machine but no luck. I have installed instantclient, Oracle SQL Developer and the .net developer tools. I am a complete rookie in database setup and administration...especially with Oracle so any help would be appreciated.

Thanks in advance

Check if you can ping and tnsping the target machine (the one which hosts the database server).

Thanks for replying pabloj.

When I ping the machine by name it does see it. It has been suggested to me for another issue I was having that my network may need to be set up with a domain...which it is not at this time. I have it set up as a basic home network with the router acting as the controler...could this be an issue?

Ok, check ping by name and ip, then do the same with tnsping

The tnsping timeout.

It said that it used the sqlnet.ora file.

Also it said it used the HOSTNAME adapter to resolve the alias.

thanks for the quick reply

Do you have a tnsnames.ora with the correct entries?
Also post the full tnsping output.

Hmmm...I do not have a tnsnames.ora file. I will have to figure out how to set that up.

Here is the ping and tnsping output:


Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Sabre>ping vaio

Pinging vaio [192.168.0.2] with 32 bytes of data:

Reply from 192.168.0.2: bytes=32 time<1ms TTL=128
Reply from 192.168.0.2: bytes=32 time<1ms TTL=128
Reply from 192.168.0.2: bytes=32 time<1ms TTL=128
Reply from 192.168.0.2: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.0.2:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Documents and Settings\Sabre>tnsping vaio

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 07-MAY-2
006 11:11:39

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=vaio))(ADDRESS=(P
ROTOCOL=TCP)(HOST=192.168.0.2)(PORT=1521)))
TNS-12535: TNSperation timed out


[

C:\Documents and Settings\Sabre>tnsping 192.168.0.2

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 07-MAY-2
006 11:15:38

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=192.168.0.2))(ADD
RESS=(PROTOCOL=TCP)(HOST=192.168.0.2)(PORT=1521)))
TNS-12535: TNSperation timed out

Are you shure that the remote database is up, running and configured to accept connections at 192.168.0.2 port 1521 (no firewall ...)?
Under which name did you place the database?
More on Oracle listener.ora and tnsnames.ora configuration here
More on ping and tnsping here

Sucess...sort of..

By disabling the firewall on the DB machine I was able to connect to oracle over my network using Oracle SQL Developer but I am still having problems with connecting in VS and cant see oracle in the server explorer. I will research more of the documentation to be sure I am even going about setting up the connection correctly. One thing of note...I dont see the Oracle privder in the list when I am trying to setup a connection...just the MS OLE DB provider.

The machine name is vaio and the Oracle service is XE I believe.

I really appreciate the help you are giving me.

Download and install Oracle OLEDB provider.
Read through the links I provided, you'll find what the service name is.

Also, after the tnsping thing, next step is to connect with sqlplus, then any graphical tool will do.

Thanks pabloj...I will let you know how it goes.