Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: help anyone?

Re: help anyone?

From: <js>
Date: Mon, 15 Jan 2001 22:46:35 -0800
Message-ID: <t67rk9lsl5ge6e@corp.supernews.com>

change this
> set shmsys:shminfo_shmmax = 429496729

 to
> set shmsys:shminfo_shmmax = 1024000000

Oracle must fit the entiry SGA into one memory segment. you SGA is 660839952 but kernel will only allow 429496729.

make the change to /etc/system and reboot make sure the changes take effect and try starting the db. (use sysdef to view memory settings)

Andrew Lenz

"Arun Tagarsi" <atagarsi_at_cgg.com> wrote in message news:93kokf$aem87$1_at_ID-33853.news.dfncis.de...
> Hi all,
> I am new to Oracle admin and wondered if anyone can tell me in
> layman's terms what this messages means , and how to go about fixing it.
>
> Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
> PL/SQL Release 8.0.5.2.0 - Production
> ORACLE_HOME = /softs/app/oracle/product/8.0.5
> System name: SunOS
> Node name: dbs
> Release: 5.6
> Version: Generic_105181-16
> Machine: sun4u
> Instance name: PVUSER
> Redo thread mounted by this instance: 0 <none>
> Oracle process number: 0
> Unix process pid: 11967, image: oraclePVUSER
>
> skgm warning: EINVAL creating segment of size 000000002764e000
> fix shm parameters in /etc/system or equivalent
> skgm warning: EINVAL creating segment of size 000000002764c000
> fix shm parameters in /etc/system or equivalent
> skgm warning: EINVAL creating segment of size 0000000027648000
> fix shm parameters in /etc/system or equivalent
> skgm warning: EINVAL creating segment of size 00000000275a4000
> fix shm parameters in /etc/system or equivalent
> skgm warning: EINVAL creating segment of size 00000000199a4000
> fix shm parameters in /etc/system or equivalent
> skgm warning: EINVAL creating segment of size 0000000027642000
> fix shm parameters in /etc/system or equivalent
> skgm warning: EINVAL creating segment of size 0000000027640000
> fix shm parameters in /etc/system or equivalent
> skgm warning: EINVAL creating segment of size 000000002763c000
> fix shm parameters in /etc/system or equivalent
> skgm warning: EINVAL creating segment of size 0000000027598000
> fix shm parameters in /etc/system or equivalent
> The oracle 8.0.5 on Enterprise 4500 Solaris 2.6 was installed with this
>
> Oracle SGA parametrs :
>
> Total system Global area: 660839952 Bytes
> Fixed Size : 48656 bytes
> variable size: 230629376 byts
> Database buffers: 429490176
> Redo buffers : 671744
> db_block_size =8192
> db_block_buffers =52428 #20% of 2048 MB
> shared_pool_size =214745088 #10% of 2048 MB
>
>
> in the file /etc/system the oracle shared memory parametres are set to :
>
> set semsys:seminfo_semvmx = 32767
>
> set shmsys:shminfo_shmmax = 429496729
> set shmsys:shminfo_shmmin = 1
> set shmsys:shminfo_shmmni = 200
> set shmsys:shminfo_shmseg = 1000
> set semsys:seminfo_semmns = 1000
> set semsys:seminfo_semmni = 200
> set semsys:seminfo_semmsl = 400
>
>
> Thanks for any advise given.
>
> Arun
>
>
>
>
Received on Tue Jan 16 2001 - 00:46:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US