Re: TNSLSNR crashes on Windows XP

I managed to achieve a limited amount of success by doing the following

• go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
• Add new string value USE_SHARED_SOCKET = TRUE

Now I can connect without TNSLSNR.EXE crashing. I can still crash it by doing a TNSPING.

Any ideas?

Thanks,
-Ben

Frank <fvanbortel_at_netscape.net> wrote in message news:<3E414412.4060507_at_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 Mon Feb 24 2003 - 21:00:07 CST