Re: Oracle via Internet

On Sat, 20 Aug 2005 16:56:45 +0200, "Nicolas Bronke" <N.Bronke_at_web.de> wrote:

>>> For testing, we want to open one of our Oracle 9i database to the
>>> internet. Therefore we opened the port 1521 and forwarded the port to
>>> our local pc. Now we can do a tnsping from outside, but we cannot
>>> connect to this database. The Error 12541 : TNS Kein Listener is
>>> coming. But the Listener is running (we tested it in the local
>>> network). We looked at the router firewall, but we could not find the
>>> problem. Does someone has an idea?
>>>
>>
>> Port 1521 is only the starting/listening port.
>> After the handoff off is made between the client & the DB;
>> they agree upon a different "high" port to continue talking to each other.
>
>I checked the firewall log and it shows me, that it ītakes everytime another
>port. Does exist a way to tell oracle to use a fixed one?
>
>Regards
>Nicolas
>

Yes, of course, and the three methods to resolve this problem have been posted by me *numerous* times, so I'm not going to repeat them here.
Hint: You'll need to use Connection Manager.

--
Sybrand Bakker, Senior Oracle DBA