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

Home -> Community -> Usenet -> c.d.o.server -> Re: TNSLSNR crashes on Windows XP

Re: TNSLSNR crashes on Windows XP

From: Frank <fvanbortel_at_netscape.net>
Date: Wed, 05 Feb 2003 18:04:18 +0100
Message-ID: <3E414412.4060507@netscape.net>


Benjamin Day wrote:

>>>Does anyone have any guesses as to what the underlying problem(s)
>>>could be?
>>
>>Best we have a look at your listener.ora, your sqlnet.ora and your
>>tnsnames.ora. But since your original error indicates a problem in the
>>oranttcp DLL, then it could be a corrupt install, a permissions problem, bad
>>RAM or anything else. Which is why I'd re-install Windows, re-install Oracle
>>and see if the problem is repeatable.

>
>
> Thanks Howard for taking a look and responding to my postings.
>
> Since re-building my laptop is going to be a wicked pain, I think I'd
> like to try to eliminate everything else before I re-install.
>
> I think I've managed to re-define the problem a little. I can start
> the listener through ControlPanel.Services and through LSNRCTL.EXE.
> Through ControlPanel.Services it will start and stay running
> indefinitely but if I try to query it's status through LSNRCTL it
> immediately crashes. If I try to start it through LSNRCTL.EXE it
> reports a successful start and then crashes.
>
> I've managed to get tracing turned on for the listener. I've posted
> the trace file, log file, listener.ora, sqlnet.ora, and tnsnames.ora
> at http://www.benday.com/oracleStuff
>
> I'd really appreciate it if you could take a look.
>
> Thanks,
> -Ben

Afternoon, Ben,

Why call the alias listener_benday1?!? (tnsnames.ora) Why try to connect over 15210 or 40000, while the listener (listener.ora) is configured for port 1521?

Your Listener.ora file should look like: LISTENER =
   (DESCRIPTION_LIST =

     (DESCRIPTION =
       (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC6))
       )
       (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = monsterlaptop)(PORT = 1521))
       )
     )

)

SID_LIST_LISTENER =
   (SID_LIST =

     (SID_DESC =
       (SID_NAME = PLSExtProc)
       (ORACLE_HOME = D:\oracle\817)
       (PROGRAM = extproc)
     )
     (SID_DESC =
       (GLOBAL_DBNAME = demo.monsterlaptop)
       (ORACLE_HOME = D:\oracle\817)
       (SID_NAME = demo)
     )

Your seems to miss the last part - the instance you want to connect to. The tnsnames.ora to go with the above would be: DEMO =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = monsterlaptop)(PORT = 1521))
     )
     (CONNECT_DATA =
       (SERVICE_NAME = demo.monsterlaptop)
     )

   )
Try the above - if it still doesn't work, remove the SQLNET.AUTHENTICATION_SERVICES= (NTS) line from your sqlnet.ora file.

Cheers, Frank Received on Wed Feb 05 2003 - 11:04:18 CST

Original text of this message

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