RE: ORA-12500 Listener error on Win NT

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Mon, 01 Oct 2001 15:29:45 -0700
Message-ID: <F001.0039E1CE.20011001153019@fatcity.com>

Hi Denmark,

Unfortunately no answers just a few more questions.

What is the listener logfile - any error messages? Also, are there any messages in the alert log or user dump directory?

Regards,
Bruce Reardon

-----Original Message-----
Sent: Tuesday, 2 October 2001 9:10

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=(P ROTOCOL=IPC)(KEY=EXTPROC0))(ADDRESS=(COMMUNITY=NMP.world)(PROTOCOL=NMP)(SERV ER=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))(S ID_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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

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:29:45 CDT