topic Re: Instance Crashed in Operating System - HP-UX

Instance Crashed

Parthiban Dhananjeyan — Thu, 17 Oct 2002 06:03:39 GMT

Re: Instance Crashed

Bokoko — Thu, 17 Oct 2002 06:11:10 GMT

Dear Parthiban,

The first thing is to check if this instance is still running by running the "ps -edf | grep oradb".

If this instance is still running, first connect to the database and shtudown this instgance with Force option and then startup again. It should be fine. Don't forget to check previously if there is no user managing this instance.

I hope this should help you.

Re: Instance Crashed

Parthiban Dhananjeyan — Thu, 17 Oct 2002 06:37:09 GMT

This instance was not running and further in the trace, the instance number is "0"... Whenever I issue a startup either with nomount or just start specifying the pfile or not, I get this error... Sometimes when I use nomount and then issue the resetlogs I get the other big error...

Parthiban

Re: Instance Crashed

Andreas D. Skjervold — Thu, 17 Oct 2002 07:14:44 GMT

Hi

Seems like the redologs might be the problem.
Do the follwing in svrmgrl:
SVRMGR> connect internal
SVRMGR> startup mount
SVRMGR> recover database until cancel;
SVRMGR> alter database open resetlogs;

Andreas

Re: Instance Crashed

Barbara Spadaro_1 — Fri, 18 Oct 2002 04:39:06 GMT

Hi,

Good point - can you recover at all?
You may like to try Andreas' suggestion from SQL*Plus as I gather you're using 9.2 and svrmgrl has been dropped in 9i.
Are you running in archivelog mode? Do you have a backup you can use and then recover to a point in time just before your crash?
Something like:
RECOVER DATABASE UNTIL TIME 18-OCT-2002:15:32:00

cheers.
Barbara

Re: Instance Crashed

Parthiban Dhananjeyan — Fri, 18 Oct 2002 05:02:54 GMT

The problem is I am not able to start the instance, then how can I recover???? Whenever I issue the startup command either with mount or nomount, specifying or not specifying the parameter file....... Can somebody help??????

Parthiban

Re: Instance Crashed

T G Manikandan — Fri, 18 Oct 2002 05:11:23 GMT

Can you try removing the ipcs entries for Oracle.
If you have two instances on the same machine this could be a problem.

You can reboot the box to clear all the memory used areas of Oracle and try mounting the instance.

Also check the alert log and post the messages when you do a mount or nomount.

Thanks

Re: Instance Crashed

T G Manikandan — Fri, 18 Oct 2002 05:14:43 GMT

What is the value for
LOG_CHECKPOINT_TIMEOUT in your init.ora file of the instance.

Thanks

Re: Instance Crashed

T G Manikandan — Fri, 18 Oct 2002 05:15:04 GMT

alert log also should help you.

I also suspect the values for the kernel parameters.

Thanks

Re: Instance Crashed

Parthiban Dhananjeyan — Fri, 18 Oct 2002 05:19:08 GMT

Re: Instance Crashed

Sandro Schaer_1 — Fri, 18 Oct 2002 05:25:43 GMT

I'm running up to 10 instances on a single machine. No problems.

Removing old semaphores and queues could be a way to solve the problem.

Since an address mapping error occured it could also help to re-link the executables.

Please provide information if you added any patches to your Linux or Oracle which might cause the problem. Also the information of the alert log might give some hints why the instance crashed.

have fun
Sandro

Re: Instance Crashed

Parthiban Dhananjeyan — Fri, 18 Oct 2002 05:29:24 GMT

After the instance crashed we updated the linux kernel from Kernel 2.5.39 to Kernel 2.5.40....... Shud this be a prob????