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

"Julz" <jxa_at_adlam.co.uk> wrote in message news:fb947ed2.0107110132.44f443fa_at_posting.google.com...
> 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

Looking at the excerpt your application and database has some very serious problems. Open_cursors is a per process limit, so when 120 users are connected you have memory allocated for 120*2048 cursors (open_cursors are not allocated dynamically)
Also a shared pool of 100M is just way too high. If you state you can't change anything and can't switch to MTS, given the fact your current setup shows symptoms of other *serious* problems in other areas, I am afraid not much can be done to address your problem, other than to advise you to hire a consultant
(Jonathan maybe?)

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Wed Jul 11 2001 - 12:09:55 CDT