Re: Shared memory error with standard.sql

Have you tuned your kernel parameters according to the recommendations given in the Oracle Installation Guides for your particular O/S?

In article <8h2qve$5p8$1_at_nnrp2.deja.com>,   glennbaron_at_my-deja.com wrote:
> Trying to create a new instance for test
> purposes, I encounter :
>
> ORA-00604: error occurred at recursive SQL level 2
> ORA-04031: unable to allocate 144 bytes of shared
> memory ("select name,col#,segcol#,........
>
> kernel parameters in /stand/system are:
> * Tunable parameters
>
> dbc_max_pct 10
> maxfiles 0X80
> maxswapchunks 1665
> maxuprc 1024
> maxusers 600
> nfile (16*(NPROC+16+MAXUSERS)/06+32+2*
> (NPTY+NSTRPTY))
> npty 200
> nstrpty 100
> num_clients 200
> semmns 1024
> shmmax 0X29999999
>
> shared memory usage is:
>
> m 0 0x2f180002 --rw------- root
> sys root sys 9 1286144 332
> 2351 17:05:09 no-entry 17:05:09
> m 2601 0x411c02f9 --rw-rw-rw- root
> root root root 0 348 930
> 930 20:42:43 20:42:43 20:42:39
> m 2 0x4e0c0002 --rw-rw-rw- root
> root root root 1 31008 930
> 930 20:42:41 20:42:43 20:42:39
> m 3 0x41200a62 --rw-rw-rw- root
> root root root 1 8192 930
> 945 20:42:41 20:42:39 20:42:39
> m 8204 0x0c6629c9 --rw-r----- root
> sys root sys 2 14407248 1988
> 1986 17:02:18 no-entry 17:02:18
> m 1205 0x06347849 --rw-rw-rw- root
> sys root sys 1 77384 1988 1992
> 17:02:20 17:02:18 17:02:18
> m 24606 0x5264bdf4 --rw-r----- oracle
> dba oracle dba 33 269856768 2831
> 22708 11:26:06 11:31:23 17:12:03
> m 8407 0x52673caa --rw-r----- oracle
> dba oracle dba 10 1396736 29936
> 1714 11:14:00 11:14:30 10:54:24
>
> There appears to be ample shared memory available
> and few segments in use.
>
> Help appreciated.
>
> Regards,
>
> Glenn Baron
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed May 31 2000 - 00:00:00 CDT