Re: Oracle 7.3.4 NT4: OraTNSListener won't start.

There are multiple reasons to do this:
- Usually you want to be sure the server is available by means of DNS instead of hardcoded IP. I'm specifically referring to a WAN, with multiple databases, with bad communication between administrators, and a good chance just 'someone' moved the server to a different system. DNS precludes the use of DHCP.
- Depending on DHCP configuration, the leased IP will be returned to the DHCP server when not used for some time. Usually there is not much server-initiated communication from the server to the clients. Imagine the IP expires outside office hours.
Or, the server needs to be rebooted (with NT that can happen quite easily). Do I have any guarantee the system will end-up with the same IP? OK, I can reserve IP addresses, but then I would just better give it a fixed IP. You'll end-up with mismatches between listener.ora, tnsnames.ora and the system. The listener probably doesn't start. Of course,
If you don't use TCP/IP for Oracle connections, it is a different story. The only other option you have is named pipes, and I read a web page on the Oracle support site once (don't remember the URL), that Oracle tests have shown named pipes is slower than TCP/IP.

Hth,

--
Sybrand Bakker, Oracle DBA

Austin Durbin <adurbin_at_nshome.com> wrote in message news:ytoz3.18323$Rn.10964_at_news.rdc2.occa.home.com...
> I can't disagree with your comment re needing a fixed IP since all of my
> servers have a fixed IP number assigned. However, could you perhaps
explain
> why this would be needed. I frankly don't see how Oracle would even know
> how the server obtained it's IP number and am curious.
>
>
> Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in message
> news:936174638.15836.0.pluto.d4ee154e_at_news.demon.nl...
> > Hmmm... Overlooked that, sorry
> > Indeed any Oracle Server when using the TCP/IP protocol, needs a fixed
IP.
> >
> > Best regards,
> >
> >
> > --
> > Sybrand Bakker, Oracle DBA
> >
> >
> > Thomas Noone <cash_at_cash-gmbh.de> wrote in message
> > news:37ccd8e5_at_news.zeitung-online.net...
> > > Thank you.
> > >
> > > The info was in the subject line.
> > >
> > > But I found the problem! The TCP/IP address was generated via dhcp,
> which
> > > doesn't seem to work.
> > >
> > > Thomas
> > >
> > > Sybrand Bakker schrieb in Nachricht
> > > <936123665.20639.0.pluto.d4ee154e_at_news.demon.nl>...
> > > >It would have helped if you would have specified Oracle version and
> > > platform
> > > >You should look in the listener.log file in
> > > >%ORACLE_HOME%|$ORACLE_HOME\[network|net80]\log
> > > >and the trace file in the trace directory. One of these should hold
the
> > > >exact error.
> > > >If that doesn't work change trace_level_listener to 16 in
listener.ora
> > and
> > > >retry the operation.
> > > >
> > > >Hth,
> > > >
> > > >
> > > >
> > > >--
> > > >Sybrand Bakker, Oracle DBA
> > > >
> > > >Thomas Noone <cash_at_cash-gmbh.de> wrote in message
> > > >news:37cbcb44_at_news.zeitung-online.net...
> > > >> After installation, the TNSListener service refuses to start by
> itself.
> > > >> Starting it manually, I receive the error message "2140: Internal
> > Windows
> > > >NT
> > > >> error".
> > > >>
> > > >> Can anybody help?
> > > >>
> > > >> Thomas
> > > >>
> > > >>
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Thu Sep 02 1999 - 01:42:21 CDT