• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1396
  • Last Modified:

Remote connection over Oracle over wireless adapter?

Hi all,

I'm playing with WAS 7 and clustering and have installed Oracle 11GR2 on my laptop that normally serves as a media PC in my lounge.

Everything is installed and working although I can't seem to connect to Oracle from my other machines. I have disabled all firewalls and still no joy.

I can SQL+ to it locally but when I try and access with SQLDeveloper I get "IO Exception : The network adapter could not establish the connection".

My Oracle PC is connected to the network via its wireless connection and I have updated the listener.ora file to include this line.....

      (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521))

...the change here is localhost for the the IP address of the wireless adapter.

I'm running short of ideas here!


3 Solutions
It sounds like it's still a network issue, because you should either get a TNS no listener error if the listener was down, or a different Oracle-specific error if you are at least able to connect to the listener.

What do you get when you try the following in the command prompt?

telnet 1521
cbeech1980Author Commented:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\CBeech>telnet 1521
Connecting To not open connection to the host, on port 152
1: Connect failed
Really a network issue.  There's something else blocking it.  
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

slightwv (䄆 Netminder) Commented:
On the database server from a command prompt post the results of: lsnrctl status
Most commonly, wireless routers are NAT firewalls, so if you are trying to connect from the non-wifi network, you are likely blocked by the "router". Find out more details on the configuration of your WIFI router.

1) What is the IP address / network number of your non-WIFI PC, is it the same network or different?
2) Try pinging the IP address.
3) Usually WIFI uses dynamic addressing, so if you reboot, your IP address will sometimes change. This doesn't mix with Oracle as a server, you need to assign a static IP address to the laptop.
4) See if there is a "DMZ" option on the router (all Linksys routers have this option). You can set the the DMZ host to point to one specific IP address on the WIFI network, and pass all traffic.
5) If a DMZ option is not available, setup some port forwarding rules. At minimum, port 1521 needs to be mapped from your laptop's IP address to the WIFI router. If your port forwarding is limited, as in low-end routers, then you may not be able to map the dynamic ports that the Oracle listener also wants, so you need to reconfigure the listener.ora with USE_SHARED_SOCKET = true to force all traffic to stay on port 1521.

Another option is to reconfigure your WIFI router as an access point instead. This basically makes it act like an ethernet switch, and disables the NAT firewall functionality.

Turn off the firewall on your computer.
Network issue...Nothing to do with Oracle database.

From client follow this:-
Ping server with IP and name
If success in this step got to next step ELSE correct this with help of network admin
tnsping service_name(Configured in client tnsnames.ora)
if success in this step and still not able to access database then let us know ELSE correct this problem.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now