Re: ORa error 03113

Hello Sybrand,

Thx, for the reply, I see I must get some things straightend out.Here are some more details.

you're right about the hardware, the test server has only 1GB of memory while the production server has 1,5GB of memory. The test server has only one NIC while the production has two. It isn't a problem for the listener, I think, cause that one binds to localhost, and the handlers work alright. Further more the second NIC isn't used by the clients to connect to... Or do I make a erronous thought? Does it help to reduce settings like shared pool size to get rid of the problem or will I only make it worse if I do that? The real question is: Is it worth it to make the effort? Or must I "just" add more memonry and a NIC to resolv the problem?

Monday, I will go back to work, and try to get the extra hardware.

Grtz,

Kasper

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:0drj8uo3et113entm45i0hajd1o9vllpl0_at_4ax.com...
> On Sat, 9 Mar 2002 10:57:33 +0100, "Kasper van Beem" <kbeem_at_xs4all.nl>
> wrote:
>
> >Hello,
> >
> >I have a question about Oracle server 8.1.7 running on AIX 4.3.
> >I've got to RS6000 machines one is the production server the other is a
test
> >server. In case of an emergency i want to be able to use the test server
as
> >the production server.
> >When i restore the production server on the test server, i am able to
mount
> >the databases, but when i try to open them i get the ora 03113 error.
> >Can anyone enlight me with this problem?
> >
> >thx,
> >Kasper
> >
> >
> >
>
> The problem here is there can be numerous causes for 3113's.
> Two causes come to mind in your case
> - there is insufficient memory to create the SGA (this would typically
> be reported in the alert log)
> - there are insufficient semaphores available
>
> I would first try to make sure startup nomount is working, this starts
> the background processes, the errors described above already show up
> during the nomount phase.
>
> Other than that Metalink has a separate note on how to isolate 3113
> search for ora-3113 startup
>
> Evidently if your test server doesn't have the same hardware specs as
> the production server you are likely to run into problems.
>
> Hth
>
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sat Mar 09 2002 - 08:01:09 CST