ORA-4031 is a shared pool fragmentation problem. Is the SHARED_POOL_SIZE
parameter set to the same value on the two databases?
--
HTH. Additions and corrections welcome.
Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
Now got a life back again that the book is released!
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
"Nigel Fowler" <legin1969_at_yahoo.com> wrote in message
news:c8138231.0108211135.35116907_at_posting.google.com...
> Hi,
>
> I've recently configured hotstandby. When I try to archive
> the logs, I get the following error messages:
>
> (From primary site alert log)
> ARC0: Error 4031 attaching RFS server to standby instance at host
'STDBY1.WORLD'
> ARC0: Error 4031 creating archivelog file 'STDBY1.WORLD'
>
> (from v$archive_dest)
> ORA-04031: unable to allocate bytes of shared memory ("","","","")
>
> I've checked everything I can and read every metalink article about
> hot standby - no luck. Any ideas?
>
> thanks,
> Nigel
Received on Tue Aug 21 2001 - 18:24:38 CDT
