Re: TNS Listner failed to start process - Help Wanted!

Julz wrote:
>
> I would be greatful if anyone could help with a problem.
>
> Currently running Oracle 8.1.7 on WinNT4.
>
> "Error ORA-12500 TNS Listner failed to start process"
>
> This error appears on the client at times of high usage, and seems to
> happen when there are about 120 users connected.
>
> The server has 4GB of RAM and is dedicated to Oracle.
> (Only 2GB supported by Oracle due to 32bit OS).
>
> Excerpt from init file:
>
> max_enabled_roles = 30
> db_file_multiblock_read_count = 8
> db_block_buffers = 64000
> open_Cursors=2048
> shared_pool_size = 100000000
> large_pool_size = 614400
> log_checkpoint_interval = 10000
> log_checkpoint_timeout = 1800
> processes = 750
> log_buffer = 8388608
> max_dump_file_size = 10240
> global_names = true
> db_block_size = 8192
>
> we are NOT running MTS and it is not an option.
>
> Anyone have any ideas?
>
> TIA
>
> Julian.
>
> jxa_at_gvagrimley.co.uk
> julian_at_adlam.co.uk

how many CPUs in the server?
one solution could be to add more listeners and balance across them. (the key load_balance=yes should be used in the tnsnames.ora files on the clients or middle tier)
You may want to see how long the queue is for listener requests.

You are currently allocating the following for memory:

  8 MB - log buffer
 96 MB - shared pool
500 MB - buffer cache

So even if only 2 GB is available to oracle - you have ~ 1.5 GB available for PGA.
You can make 3 GB or RAM available to Oracle with patches. Check the MS KB for articles on this.

What are the values for the following parameters:

hash_area_size
sort_area_size
sort_area_retained_size

these directly affect the size of the PGA.

can you check what the high_water_mark for user connections was? this is written to the alert log each time at normal or immediate shutdown.

Paul Received on Wed Jul 11 2001 - 19:38:02 CDT