Re: How parameter "processes" in initXXXX.ora affect Oracle

"Harry Sheng" <hsheng_at_innovance.com> wrote in news:SYpv7.65076$TW.352343_at_tor-nn1.netcom.ca:

> Hi, group
>
> Could anyone give me some idea on how Oracle instance is affected by
> parameter "processes" in initXXXX.ora?
> I am doing a fresh install of Oracle8.1.7 on Solaris2.7. I consistently
> get an ORA-03113 error. I figured out that
> the parameter "processes" in init.ora causes the problem. The default
> value for "processes" is 50. I have to reduce
> it to 30 to clear the problem.
> My Solaris box is "Enterprise 420r". I believe that I have far more
> than enough resource to support 50 Oracle
> user processes on my box. Here is the exact copy of my "init.ora" file.
>
> ------------------------------------------------------------------------
> ---- --------------------------------------------
> db_name = "imsb"
> instance_name = imsb
> global_names = true
>
> db_domain = innovance.com
> service_names = imsb.innovance.com
>
> control_files = ("/opt/oracle/oradata/imsb/control01.ctl",
> "/opt/oracle/oradata/imsb/control02.ctl",
> "/opt/oracle/oradata/imsb/control03.ctl")
>
> db_block_size = 8192
> db_block_buffers = 100
>
> log_checkpoint_interval = 10000
> log_checkpoint_timeout = 1800
> log_buffer = 32768
>
> processes = 30
>
> max_dump_file_size = 10000
>
> # log_archive_start = true
> # log_archive_dest_1 = "location=/opt/oracle/admin/imsb/arch"
> # log_archive_format = arch_%t_%s.arc
>
> #rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )
>
> # transactions = 40
> # transactions_per_rollback_segment = 10
>
> background_dump_dest = /opt/oracle/admin/imsb/bdump
> core_dump_dest = /opt/oracle/admin/imsb/cdump
> user_dump_dest = /opt/oracle/admin/imsb/udump
>
> compatible = "8.1.0"
> sort_area_size = 65536
> sort_area_retained_size = 65536
>
> # remote_login_passwordfile = none
> ------------------------------------------------------------------------
> ---- -----------------------------------------
>
>
> Harry Sheng
>
>
>
>

You need to RTFM & adjust the Solaris paramters in /etc/system. set semsys:seminfo_semmsl = 2048
* to match number of Oracle processes

Simply put the value of processes inside of initSID.ora can NOT exceed the value of SEMMSL; otherwise Oracle won't start.

HTH & YMMV! Received on Fri Oct 05 2001 - 19:14:31 CDT