Re: error 1067 - listener not started

From: Linas Purinis <l.purinis_at_parex.lt>
Date: Tue, 2 Oct 2001 16:07:30 +0200
Message-ID: <3bb9c9ab@news.takas.lt>

"Andreas Lommel" <anlommel_at_gmx.de> wrote in message news:3bb9c4d5.25704280_at_news.btx.dtag.de...
> I installed oracle on a NT-PC. Whe I try to start the listener I get
> the error 1067. The listener doesn`t start.
> Who can help?

I fount two documents in metalink. One was: "LISTNER.ORA" NEEDS TO BE CONFIGURED WITH CORRECT HOST-NAME. Second:

                  Doc ID:  Note:102668.1
                  Subject:  WINNT: winnt error 1067 - Listener Refuses to
Startup on NT4
                  Type:  PROBLEM
                  Status:  REVIEWED
           Content Type:  TEXT/PLAIN
                  Creation Date:  17-MAR-2000
                  Last Revision Date:  09-APR-2001

Problem Description:

You have just installed the RDBMS server (default installation) on a NT box that is not connected to the network.

When starting the listener you get the following error:

" could not start the TNSlistener80 on \\hostname, Error 1067: The process terminated unexpectedly "

You have done a correct setup of winNT with a network card and TCP/IP using DHCP, but the NT box has not yet been connected to your network. You can ping to 127.0.0.1, but you do not have an IP address assigned to you.
When doing a "ipconfig" in a dos box you see this:

c:>ipconfig

Windows NT IP Configuration

Ethernet adapter CEM561:

        IP Address. . . . . . . . . : 0.0.0.0
        Subnet Mask . . . . . . . . : 0.0.0.0
        Default Gateway . . . . . . :

Solution Description:

One possible way to do this if you want to use DHCP is to put the NT machine on your network and issue "ipconfig /release" in a DOS box.

Even when the machine is now removed from the network, your NT machine still has a valid ip address.

When connecting again to your network later on, the IP address might change, this depends on the lease time of your DHCP server, you can check it with:

C:>ipconfig /all
....
....

        Lease Obtained. . . . . . . : 03 March 2000 11:36:43
        Lease Expires . . . . . . . : 03 March 2000 13:36:43

But this has no implications for the listener if using hostnames in the listener.ora.
Note that the DHCP server can give the same IP address back, so you might not
see the IP address change.

2) Give the NT box a temporary fixed IP address.

Network icon on desktop -> properties -> Protocols tab -> TCP/IP protocol -> properties change the setting from "obtain an ip address..." to "Specify an IP
address" and specify "10.10.10.1 , subnetmask 255.255.255.0 " for example.

Explanation:

The Listener refuses to startup because the PC has not yet been assigned an IP
address.
This has been observed for all RDBMS versions on Windows NT 4.0. This error can't reproduce on Windows2000 because unlike the 0.0.0.0 on NT 4.0,
win2k is assigning a default IP address (169.254.X.X range, subnetmask 255.255.0.0)
if the adaptor can't reach the DHCP server .

Keywords

listener , DHCP , 1067 , NT , OS ERROR

References:

[NOTE:1068227.6] WINDOWS NT SYSTEM ERROR 1067 WHEN STARTING TNS LISTENER .

begin 666 kur_left_bottom.gif

M1TE&.#EA"@`/`+,``/___\S__\S,_YG,S)F9S&:9S ``````````````````
M`````````````````````"P`````"@`/```$'Q#(2:N].->011Y9P5T%_at_14%

0:*&%5['M"Q,C`+.#$$0`.P``
`
end Received on Tue Oct 02 2001 - 09:07:30 CDT