Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNSLSNR.EXE Application Error

95607Apr 30 2003 — edited Oct 17 2005
I 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 14 2005
Added on Apr 30 2003
4 comments
1,812 views