Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 7.3.4 PL/SQL Problems
Hi
I am running solaris 2.5.1 and 7.3.3.4 and just yesterday twice had the database crash with (either Address not mapped or Invalid address alignment) both times when I was re-executing the create or replace script of several pl/sql packages i wrote.
I suspect but have yet to prove that I had 'blown' the SGA (the instance also runs Oracle Applications and a lot of stuff is pinned in memory).
If yours is a similar situation or if you find out a different reason please could you let me know.
Thanks
Mark
dkawahig_at_yahoo.com wrote:
>
> Greetings,
>
> I am currently in the middle of porting a small database from 7.3.3 (running
> on a Solaris 2.5.1 system) to a new computer running Oracle 7.3.4.1 on
> Solaris 2.6. I am having problems in getting any of the PL/SQL programs to
> run consistently. When executing a stored procedure, I usually get a core
> dump (either Address not mapped or Invalid address alignment) or an ORA-600
> error. There is no consistency. I can run the same procedure 3 times and it
> may fail in 2 different ways and then run successfully the third time.
>
> Anybody have any ideas on what I need to check on or change? These
> procedures had no problems in 7.3.3 ...
>
> Thanks
>
> Don Kawahigashi
> Integra Solutions, Inc.
>
> dkawahig_at_islink.com
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri Apr 24 1998 - 23:46:42 CDT