ORA-12500 Listener error on Win NT

From: Denmark Weatherburne <denmark_weatherburne_at_hotmail.com>
Date: Mon, 01 Oct 2001 15:00:59 -0700
Message-ID: <F001.0039E12C.20011001151019@fatcity.com>

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_at_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_at_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_at_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).

Received on Mon Oct 01 2001 - 17:00:59 CDT