Re: Error Creating Oracle8 DB (SGA memory location) ?

Solution Found - Patch From Oracle for 8.0.5.1

Look like we needed a patch for making an SGA of 1.5 GB on our Alpha......

There is an issue with the 8.0.5.x on Digital Alpha platforms where the beginning address of the Fixed part of your SGA is higher then in previous versions. When trying to start databases up with large SGA’s, the errors regarding ‘internal AIO consistency error’ are produced...

I had to FTP a patch from their site and apply it.

Stan Novinsky wrote:

>
> A previous posting by Michael Horwitz had a similar problem and he
> had to add the following line to the init.ora file:
>
> shared_memory_address = 134209536
>
> He stated that it was a kind of 'global' fix to all such problems on a
> DEC computers but had no
> idea where the figure of 13409536 came from.
>
> Does anyone know where or how the number is derived from ?
>
>
> Anyway,
>
> I am attempting to increase our SGA to 1.5 GB on our Digital UNIX 4.0e
> system
>
> When I issue the initial startup I receive the following:
>
> connect internal
> startup pfile=$D_ORA_DB/pfile/initd_0.ora nomount
>
> Internal AIO consistency error: Cannot initialize aio library.
>
> Error 35: (null)
> Aborting...
>
> This causes a trace file to be printed and a CORE dump to be produced.
>
> The CORE dump does not reveal much. I sent the dump information to
> Oracle support but they did not find anything. Then I sent them the
> information I
> found about the SGA memeory loacation and they hinted that it may be
> the prolem.
>
> The following is our
> configuration:
>
> Our AS 8400 is configured with:
> 5/625 Dual Processor
> Digital UNIX v4.0e
> 3.5 GB of Memory
> (18) 9.1 GB Disks (RAID 7000)
>
Received on Tue Jul 06 1999 - 07:01:07 CDT