Shared memory probelm with oracle

[Bill Hassell]

You'll have to manually trace the shutdown script to see errors are reported. Use sh -x oracle_shutdown_script to see what is happening. Each process that fails to stop either did not get signaled properly or it is hung-up and probably needs a patch to prevent this problem.

[Eric Antunes]

Hi,

You can see a full list of bugs for 9.2.0.4 at: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=245758.1.

There is bug 2905667 ("Instance terminated by CKPT due to ORA-1110 during shutdown in RAC") at the RAC section that may be your issue (see note http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=2905667.8 for more info...). Can you see, for each instance, in the background_dump_dest (select value from v$parameter where name = 'background_dump_dest') destination if there are any ckpt_*.trc?

Best Regards,

Eric Antunes

[Eric Antunes]

Hi,

You are already at 9.2.0.4 so you don't need to look at the previous link I gave you: look at those:

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=283897.1 for bugs corrected in 9.2.0.6

and

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=263791.1 for bugs corrected in 9.2.0.5

Can you see, for each instance, in the background_dump_dest directory if there are any *.trc with the datetime of the last shutdown?

Best Regards,

Eric Antunes

[Eric Antunes]

Hi,

Do you have 3 RAC nodes? I'm asking this because bug 2495540 (and corresponding patch) is about ORA-600 errors on the 3rd node.

Regards,

Eric

[Eric Antunes]

Hi,

Did you solved your issue?

Best Regards,

Eric Antunes