Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Setting up the Oracle Listener

Re: Setting up the Oracle Listener

From: <fitzjarrell_at_cox.net>
Date: Thu, 16 Aug 2007 10:55:20 -0700
Message-ID: <1187286920.201109.189860@57g2000hsv.googlegroups.com>


On Aug 16, 12:30 pm, dj Mucky <rune.smedst..._at_gmail.com> wrote:
> Hi
>
> I am trying to set up Oracle 10i on mye desktop computer running
> Windows XP. Everything works flawlessly on this computer as far as I
> can tell. I can use SQL*Plus and webbased configuration to connect to
> the database e.t.c. But I also want to use my laptop running Windows
> Vista with SQLDeveloper to run /create queries and PL/SQL-blocks.
>
> The problem is that I can not connect to the database from other
> computers than localhost (desktop). Even connecting tohttp://desktop:1158/em/
> will result in a failure.
>
> Is there any settings inside Oracle to change in order to make this
> work? I have peeked and poked around the database but so far my search
> has resulted in '0 rows found'.

This is all part of the LISTENER configuration, and since you're only listening on your loopback address (localhost, 127.0.0.1) you can't field requests from other computers. You need to be listening on an address which is not a circular reference to the database server, meaning an address the 'outside' world can possibly 'see'. I expect you are probably using a dynamic IP address; you'll need a static one to allow the listener to work for networked requests.

All of this information has been posted here,in comp.databases.oracle.server, at tahiti.oracle.com and likely in any number of Oracle-related blogs available on the internet. You can start here:

http://www.google.com/search?hl=en&q=listener+configuration http://download.oracle.com/docs/cd/B19306_01/server.102/b14196/network001.htm#sthref177

David Fitzjarrell Received on Thu Aug 16 2007 - 12:55:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US