Remote connection over Oracle over wireless adapter?

Posted on 2011-04-26
Last Modified: 2013-11-11
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!


Question by:cbeech1980
    LVL 24

    Accepted Solution

    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

    Author Comment

    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
    LVL 24

    Expert Comment

    Really a network issue.  There's something else blocking it.  
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    On the database server from a command prompt post the results of: lsnrctl status
    LVL 40

    Assisted Solution

    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.

    LVL 47

    Expert Comment

    Turn off the firewall on your computer.
    LVL 8

    Assisted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now