Path: news.easynews.com!easynews!feed2.onemain.com!feed1.onemain.com!newsfeed.online.be!newsfeed.wirehub.nl!213.218.77.63.MISMATCH!newspeerenv1!213.218.77.62.MISMATCH!newswriterenv1.svr.pol.co.uk!not-for-mail
From: j.w.vandijk@hetnet.nl (Jaap W. van Dijk)
Newsgroups: comp.databases.oracle.server
Subject: Re: How can I troubleshoot without informations ?
Date: Wed, 12 Dec 2001 22:28:19 GMT
Organization: Energis NV's Usenet System
Lines: 68
Message-ID: <3c17d9b7.6406652@news.freeler.nl>
References: <1e8276d6.0112110821.5d46128e@posting.google.com>
NNTP-Posting-Host: 62.21.141.68
X-Trace: newswriterENV1.svr.pol.co.uk 1008195884 2439 62.21.141.68 (12 Dec 2001 22:24:44 GMT)
X-Complaints-To: abuse@energis.com
NNTP-Posting-Date: Wed, 12 Dec 2001 22:24:44 +0000 (UTC)
X-Newsreader: Forte Free Agent 1.21/32.243
Xref: easynews comp.databases.oracle.server:127973
X-Received-Date: Wed, 12 Dec 2001 15:24:46 MST (news.easynews.com)

Dusan,

In this circumstances: don't let it be your responsability (and this
is a serious answer!)

Jaap.

On 11 Dec 2001 08:21:59 -0800, pagesflames@usa.net (Dusan Bolek)
wrote:

>We have problem on one of our servers. Everything is more complicated
>because this server is NT box and I can get in, because of security
>policies.
>So I've tried to do troubleshooting with information from second
>(maybe third) hand. I love this situation.
>Clients have got well-known ORA-12500 error. This Oracle 8.0.5.1.1
>server need to handle 800 concurrent connections in dedicated mode,
>which is something not very good for NT platform. The problem is
>probably in insufficient memory. However, I cannot tell this for sure,
>because some clever head decided to switch off logging of listener
>actions. So there is no listener.log, which is one of my favourite
>Oracle log files. :-(
>Server has 2GB of physical RAM, but it seems that Oracle is using only
>1GB of it. That's strange because there is a lot of free memory
>available. The only way how they can achieve eliminating ORA-12500s is
>decrease of SGA which left more memory available for PGA. However
>performance trade-offs are very serious (nothing suprising).
>My situation is pretty bad, because I can get my hands on that very
>server, I'm not very confident about capabilities of DBA taking care
>about it and I do not know NT environment very well, especially in
>memory allocation limits.
>I know that there should be 2GB limit for user processes in NT, but
>1GB seems for me too low value to has problems.
>If someone can help me, it will be appreciated.
>
>Some interesting parameters from init.ora:
>control_files = (E:\OraCtrl\DB10\ctrl_DB10_01.odf,E:\OraCtrl\DB10\ctrl_DB10_02.odf,E:\OraCtrl\DB10\ctrl_DB10_03.odf)
><- very good idea having
>all control files together. :-(
>db_block_buffers = 60000
>db_block_size = 4096
>db_files = 254
>dml_locks = 500
>log_buffer = 163840
>log_checkpoint_interval = 25000
>open_cursors = 200
>processes = 1600 <- was 2000
>shared_pool_size =  25000000 <- was 30000000 then 15000000
>sort_area_size = 258048
>MTS disabled, all running in dedicated mode
>
>
>
>P.S. In alert log is nothing interesting. However I'm not sure if I
>have the log from that time. :-(
>
>--
>_________________________________________
>
>Dusan Bolek, Ing.
>Oracle team leader
>
>Note: pagesflames@usa.net has been cancelled due to changes (maybe we
>can call it an overture to bankruptcy) on that server. I'm still using
>this email to prevent SPAM. Maybe one day I will change it and have a
>proper mail even for news, but right now I can be reached by this
>email.