Re: Problem creating a new database instance in Digital Unix

Michael:

Sounds to me like a shared memory issue, too. Use sysconfig and sysconfigtab to adjust the shared memory values on your system. A reboot is required, I believe.

I am running 7.2.3 instances on DEC Unix (excuse me, Compaq Tru64Unix) 4.0d Patch Level III. Please email if I can be of further assistance.

mbm

On Mon, 21 Jun 1999 13:34:38 -0400, Kenneth C Stahl <kstahl_at_lucent.com> wrote:

>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 - 14:31:13 CDT