TNSLSNR.EXE Application Error
95607Apr 30 2003 — edited Oct 17 2005I keep getting an error that I can't figure out how to resolve. The problem is that TNSLSNR keeps blowing up with an application error. Anything I try to do that attempts to connect to my database causes the following application error:
TNSLSNR.exe Application Error
The instruction at "0x61915732" referenced memory at "0x00000578". The memory could not be "read"
and the listener service terminates. I have to stop the database service and restart it otherwise additional restarts of the listener cause the database to go crazy.
I have Oracle 9i on my Dell Latitude C840 running Windows XP Pro. I could have sworn this was working before, but now I'm not sure. I recently installed the latest Oracle JDeveloper to tinker with and I also recently went through and "trimmed" down my system by disabling all unnecessary services.
For troubleshooting, I have tried to manually start the listener and got the following:
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
System parameter file is c:\oracle\ora92\network\admin\listener.ora
Log messages written to c:\oracle\ora92\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
tion
Start Date 30-APR-2003 20:08:14
Uptime 0 days 0 hr. 0 min. 7 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File c:\oracle\ora92\network\admin\listener.ora
Listener Log File c:\oracle\ora92\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "BIBLES.world" has 1 instance(s).
Instance "BIBLES", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
This works fine, then when I try to do a TNSPING, I get the application error. I also get the error when I try to connect using AllAround Automations PL/SQL Developer 5.1 and also when I try to connect using SQLPLUS.
I have captured a trace file but I don't speak TRC. Can anyone offer any help or suggestions or tips or anything?