Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TNSLSNR crashes on Windows XP
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.
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) )
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = monsterlaptop)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = demo.monsterlaptop) )
Cheers, Frank Received on Wed Feb 05 2003 - 11:04:18 CST