Re: Problem creating a new database instance in Digital Unix

Is the amount of shared memory adequate? I don't know how this is done with DEC Unix, but on Unixware it is the SHMMAX parameter in /etc/conf/cf.d/stune. If it isn't big enough you won't be able to grab enough memory for the SGA.

Ken

michael horwitz wrote:

> Hi all,
>
> I would very much appreciate any help I could get in creating a new database
> instance for Oracle 7.2.3 on a Dec/Alpha.
>
> I have put all the required init.ora files in the Oracle home and when I try
> and startup the new database with the nomount option I immediately get the
> following error:
>
> ORA - 07307: sms1sg: shmat error, unable to attach sga
> DEC OSF/1 (AXP) Error: 22: Invalid Argument
> Additional Information: 1
>
> The help offered with oerr is somewhat cryptic and simply suggests that one
> checks the starting address returned for the sga (I don't see it in the
> message above).
>
> If i greatly reduce all the parameters related to the sga in the control
> files then I can create the database without problem. However, I have tried
> creating a copy of a database from a machine with half the physical memory
> of the current machine, and it also fails!
>
> Anyone else come accross this problem? Any ideas on how to work around it?
> All help will be much appreciated!
>
> Thanks
>
> Michael Horwitz
Received on Mon Jun 21 1999 - 12:34:38 CDT