This discussion is archived
1 2 3 4 Previous Next 52 Replies Latest reply: Feb 2, 2012 10:27 AM by 898236 Go to original post RSS
  • 30. Re: how to remotely access to oracle database XE ?
    orafad Oracle ACE
    Currently Being Moderated
    lolveley wrote:
    [olivier@new-host-3 ~]$ netstat -nap | grep 1521
    (Tous les processus ne peuvent être identifiés, les infos sur les processus
    non possédés ne seront pas affichées, vous devez être root pour les voir toutes.)
    tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN -
    Ok, so this looks better.

    To try to follow the changes made, currently what are contents of /etc/hosts and output from lsnrctl stat?

    Edited by: orafad on Feb 1, 2012 10:38 PM
  • 31. Re: how to remotely access to oracle database XE ?
    898236 Newbie
    Currently Being Moderated
    how con you explain :

    1/ this :
    [olivier@new-host-3 ~]$ netstat -nap | grep 1521
    (Tous les processus ne peuvent être identifiés, les infos sur les processus
    non possédés ne seront pas affichées, vous devez être root pour les voir toutes.)
    tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN -
    2/ and this :
    [olivier@new-host-3 bin]$ ./tnsping lolveley.<a site at dyndns>.org

    TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 01-FEB-2012 19:20:52

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

    Used parameter files:

    Used HOSTNAME adapter to resolve the alias
    Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=90.26.xxx.xxx)(PORT=1521)))
    TNS-12541: TNS:no listener
    there is or there is not a listener, that's the question

    Edited by: lolveley on 1 févr. 2012 13:42
  • 32. Re: how to remotely access to oracle database XE ?
    898236 Newbie
    Currently Being Moderated
    ok.
    (thank you for the interest and time you have for my issue)

    *1/* /etc/hosts:
    127.0.0.1 new-host-3.home new-host-3 localhost.localdomain localhost
    ::1          localhost6.localdomain6 localhost6
    sorry I did not made the changes to hosts.
    I will do it after this post.

    *2/* lsnrctl stat :
    [olivier@new-host-3 bin]$ ./lsnrctl stat

    LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 01-FEB-2012 22:40:22

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

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER

    Alias LISTENER
    Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
    Start Date 01-FEB-2012 18:18:13
    Uptime 0 days 4 hr. 22 min. 9 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=new-host-3.home)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=new-host-3.home)(PORT=1234))(Presentation=HTTP)(Session=RAW))
    Services Summary...
    Service "XE" has 1 instance(s).
    Instance "XE", status READY, has 1 handler(s) for this service...
    Service "XEXDB" has 1 instance(s).
    Instance "XE", status READY, has 1 handler(s) for this service...
    Service "XE_XPT" has 1 instance(s).
    Instance "XE", status READY, has 1 handler(s) for this service...
    The command completed successfully
  • 33. Re: how to remotely access to oracle database XE ?
    898236 Newbie
    Currently Being Moderated
    well, I'm not sure about how to fill /etc/hosts.

    I fear putting 192.168.1.13 as this address may change at the reboot of the box.

    I did nothing for the moment.

    Edited by: lolveley on 1 févr. 2012 13:53
  • 34. Re: how to remotely access to oracle database XE ?
    orafad Oracle ACE
    Currently Being Moderated
    >
    [olivier@new-host-3 bin]$ ./tnsping lolveley. a site of dyndns . org
    What happens if you tnsping new-host-3/xe?

    Is the outside IP correct? (90.26.a.b) I.e. does it match what returned from http://checkip.dyndns.com/

    Did you set up a mapping from outside IP (port) to inside IP (192.168.x.y) and is the latter IP still assigned to the correct host? (the one with a listener, new-host-3)

    TNS-12541: TNS:no listener
    so the issue may come from the listener and not from tnsnames.ora, right?
    Tnsnames config or underlying networking issue. A listener does not respond with "no listener".
    If incorrect IP was used, you could get "no listener", because the contacted host does not run a listener (at least not on given port).
  • 35. Re: how to remotely access to oracle database XE ?
    orafad Oracle ACE
    Currently Being Moderated
    lolveley wrote:
    well, I'm not sure about how to fill /etc/hosts.

    I fear putting 192.168.1.13 as this address may change at the reboot of the box.
    Correct. (If you wanted to, you should first reserve a DHCP assigned IP to the machine/arp address.)

    As long as listener binds to "any interface" 0.0.0.0 (and not 127.0.0.x) which I believe should be the case when you see a host name in status output endpoints, I guess remote connections would be possible. (Barring any other netowrking issues, etc.)
  • 36. Re: how to remotely access to oracle database XE ?
    898236 Newbie
    Currently Being Moderated
    1/
    [olivier@new-host-3 bin]$ ./tnsping new-host-3/xe

    TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 01-FEB-2012 23:02:31

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

    Used parameter files:

    Used HOSTNAME adapter to resolve the alias
    Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=xe))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
    OK (0 msec)
    2/ IP correct (verified with the administration page of my box

    maybe the problem comes from the box.
    I understood your explanation about the listener.
  • 37. Re: how to remotely access to oracle database XE ?
    898236 Newbie
    Currently Being Moderated
    have a look at this : here .

    it's in french but you can see the port is open.
  • 38. Re: how to remotely access to oracle database XE ?
    898236 Newbie
    Currently Being Moderated
    look at this :
    [olivier@new-host-3 bin]$ ./tnsping lolveley.<site at dyndns>.org/xe

    TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 01-FEB-2012 23:33:57

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

    Used parameter files:

    Used HOSTNAME adapter to resolve the alias
    Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=xe))(ADDRESS=(PROTOCOL=TCP)(HOST=90.26.xxx.xxx)(PORT=1521)))
    TNS-12541: TNS:no listener
    maybe the computer does not know what to do with this SID?
    Where is it configured?tnsnames.ora?
  • 39. Re: how to remotely access to oracle database XE ?
    orafad Oracle ACE
    Currently Being Moderated
    Ok, so livebox is your router and modem.

    What does livebox know "equipment" new-host-3 as?

    Is port 1521 open in both router's firewall and host's firewall?
  • 40. Re: how to remotely access to oracle database XE ?
    orafad Oracle ACE
    Currently Being Moderated
    lolveley wrote:
    [olivier@new-host-3 bin]$ ./tnsping lolveley.<site at dyndns>.org/xe
    Used HOSTNAME adapter to resolve the alias
    maybe the computer does not know what to do with this SID?
    Service_name (or SID) does actually not matter to tnsping, it just tries to contact the IP and port for a listener.
    Where is it configured?tnsnames.ora?
    Tnsnames does not come into play here. It uses the hostname naming method (picked up from sqlnet.ora configuration).

    Could you have someone on the outside confirm connectivity, and try tnsping? I'm not so sure that, trying to reach from a inside client via dyndns to outside IP and back inside again, would work as expected.
  • 41. Re: how to remotely access to oracle database XE ?
    898236 Newbie
    Currently Being Moderated
    me, yes and yes! :

    ifconfig => I'm 192.168.1.13 and new-host-3 for the router is 192.168.1.13

    in my router, I've got 2 things:
    -the NAT rules, which I show you above in my picture
    - the firewall, with this text inside the administration page :
    Moyen
    Le pare-feu filtre toutes les connexions entrantes. Le trafic sortant est autorisé à l'exception des services Netbios. Il est recommandé d'utiliser ce mode.
    in english : the firewall filters all the incoming connections(...)
    but I think the NAT rules are more important than this.

    and finally the host have a desactivated firewall...

    what an awful situation!
  • 42. Re: how to remotely access to oracle database XE ?
    898236 Newbie
    Currently Being Moderated
    ok I will do this as soon as possible.

    maybe tomorrow(it's wednesday, 0h30 ) for me.

    thanks again!
    I will tell you the result of the command
  • 43. Re: how to remotely access to oracle database XE ?
    orafad Oracle ACE
    Currently Being Moderated
    >
    in english : the firewall filters all the incoming connections(...)
    but I think the NAT rules are more important than this.
    If you set up NAT the filter rule should be configured accordingly, but you never know...

    Also, do you know if your ISP filters ports?

    what an awful situation!
    No, you just need to be patient :)


    Does ip resolved from lolveley.<site at dyndns>.org match what you see at http://checkip.dyndns.com/ ?

    Edited by: orafad on Feb 2, 2012 12:39 AM
  • 44. Re: how to remotely access to oracle database XE ?
    orafad Oracle ACE
    Currently Being Moderated
    Then we have the same time. I.e. bedtime (long ago).

    A quick check. Do you have another machine on 192.168.1.x that you could tnsping 192.168.1.13 from? Or, if tnsping is not available, telnet 192.168.1.13 1521.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points