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

Home -> Community -> Usenet -> c.d.o.server -> Re: unable to attach sga

Re: unable to attach sga

From: <decompton_at_worldnet.att.net>
Date: Wed, 21 Jul 1999 16:07:03 GMT
Message-ID: <7n4r6s$6l$1@nnrp1.deja.com>


Greetings,

In addition to the ORACLE issue mentioned earlier, keep in mind that the SGA space roughly = shared_pool + db_block_buffers * db_block_size + log_buffer. All of these added together must be able to fit into shared memory.

thanks,

dave

In article <7n1ndq$pdo$1_at_nnrp1.deja.com>,   rpereira_at_my-deja.com wrote:
> Hi gurus,
>
> I'm trying to configure the parameter shared_pool = 200000000,
> the shell parameter shmmax is 587202560.
> The environment is SunOS 5.6 with oracle 7.3.2.2.0 and I receive the
> following message:
>
> ORA-07307: sms1sg: shmat error, unable to attach sga.
> SVR4 Error: 22: Invalid argument
>
> What should I do ?
> Is there any problem between the SunOS and the release of Oracle ?
>
> Your feedback are very important and much appreciated.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 21 1999 - 11:07:03 CDT

Original text of this message

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