From denmark_weatherburne@hotmail.com Mon, 01 Oct 2001 15:00:59 -0700 From: "Denmark Weatherburne" Date: Mon, 01 Oct 2001 15:00:59 -0700 Subject: ORA-12500 Listener error on Win NT Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi DBA's Today, our production users started to get the following error at their Win NT Oracle 8.0.5. client workstations. ORA-12500 TNS Listener failed to start a dedicated server process I was not running Spotlight at the time and I could not connect to the instance using Server Manager. I had to stop the NT services and reboot the NT machine. That apparently resolved the problem. However, I'm concerned becasue this is the first time that I have seen this situation. I searched Metalink for related documents which point to the listener.ora configuration and memory resources, etc. I made no changes to the listener.ora. Perhaps someone may have encountered this error before and been able to isolate the problem. I would appreciate any feedback and advice. I'll paste the listener.ora here for your review: # E:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration File:e:\orant\net80\admin\listener.ora # Generated by Oracle Net8 Assistant PASSWORDS_LISTENER= (oracle) STARTUP_WAIT_TIME_LISTENER=0 LISTENER=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=oracle.world))(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))(ADDRESS=(COMMUNITY=NMP.world)(PROTOCOL=NMP)(SERVER=LAMANAI)(PIPE=ORAPIPE))(ADDRESS=(PROTOCOL=TCP)(Host=lamanai)(Port=1521))(ADDRESS=(PROTOCOL=TCP)(Host=lamanai)(Port=1526))(ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521))(ADDRESS=(PROTOCOL=IPC)(KEY=PROD))(ADDRESS=(PROTOCOL=IPC)(KEY=TEST))) CONNECT_TIMEOUT_LISTENER=10 SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=extproc)(PROGRAM=extproc))(SID_DESC=(SID_NAME=PROD))(SID_DESC=(SID_NAME=TEST))) TRACE_LEVEL_LISTENER=0 This NT server has 784MB RAM. The SGA information is as follows: SVRMGR> connect internal@prod Password: Connected. SVRMGR> show sga Total System Global Area 43773952 bytes Fixed Size 49152 bytes Variable Size 35459072 bytes Database Buffers 8192000 bytes Redo Buffers 73728 bytes SVRMGR> Thanks in advance for your contributions! Regards, Denmark Weatherburne Belize _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denmark Weatherburne INET: denmark_weatherburne@hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).