Re: How can I troubleshoot without informations ?

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_at_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_at_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.
Received on Wed Dec 12 2001 - 16:28:19 CST