Re: ORa error 03113

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 - 05:15:38 CST