Home » Server Options » RAC & Failsafe » Restarting Instance (Oracle RAC 10g , Linux)
Restarting Instance [message #350926] Sat, 27 September 2008 12:57 Go to next message
mrvafaei
Messages: 27
Registered: September 2008
Junior Member

Hi ,
I have problem with Restarting The Instance's on my RAC system ,
I have set the Restart_Attempt to 20 , but want to know why the crs restarting instance every day .
here is my crs_stat -t -v resault :

Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....b1.inst application 2/20 0/0 ONLINE ONLINE db1
ora....b2.inst application 1/20 0/0 ONLINE ONLINE db2
ora.ctmsdb.db application 0/1 0/1 ONLINE ONLINE db1



and here is log of CRSD.log file :

2008-09-25 03:01:38.894: [ CRSAPP][1566763328]0CheckResource error for ora.ctmsdb.ctmsdb1.inst error code = 139
2008-09-25 03:01:38.898: [ CRSRES][1566763328]0In stateChanged, ora.ctmsdb.ctmsdb1.inst target is ONLINE
2008-09-25 03:01:38.898: [ CRSRES][1566763328]0ora.ctmsdb.ctmsdb1.inst on db1 went OFFLINE unexpectedly
2008-09-25 03:01:38.899: [ CRSRES][1566763328]0StopResource: setting CLI values
2008-09-25 03:01:38.910: [ CRSRES][1566763328]0Attempting to stop `ora.ctmsdb.ctmsdb1.inst` on member `db1`
2008-09-25 03:01:46.894: [ CRSRES][1566763328]0Stop of `ora.ctmsdb.ctmsdb1.inst` on member `db1` succeeded.
2008-09-25 03:01:46.895: [ CRSRES][1566763328]0ora.ctmsdb.ctmsdb1.inst RESTART_COUNT=0 RESTART_ATTEMPTS=20

could you please give Advice ?

Thanks ,
Reza .
Re: Restarting Instance [message #350928 is a reply to message #350926] Sat, 27 September 2008 13:17 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What version of 10g (indicate 4 digits) ?
Re: Restarting Instance [message #350932 is a reply to message #350928] Sat, 27 September 2008 15:10 Go to previous messageGo to next message
mrvafaei
Messages: 27
Registered: September 2008
Junior Member

Hi ,

I Use Oracle 10g 10.2.0.1.0 , with Oracle Red Hat Enterprise Linux 5 .

Thanks ,
Reza .
Re: Restarting Instance [message #350933 is a reply to message #350932] Sat, 27 September 2008 15:17 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
There is a Bug 4556989 that seems to be similar to your problem. It is fixed in 10.2.0.2 and a patch is available for your version.
Re: Restarting Instance [message #350934 is a reply to message #350933] Sat, 27 September 2008 15:22 Go to previous messageGo to next message
mrvafaei
Messages: 27
Registered: September 2008
Junior Member

Can you give me some more detail please .
Re: Restarting Instance [message #350936 is a reply to message #350934] Sat, 27 September 2008 16:29 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check out Metalink Note: 342928.1.
Re: Restarting Instance [message #350971 is a reply to message #350936] Sun, 28 September 2008 07:56 Go to previous messageGo to next message
mrvafaei
Messages: 27
Registered: September 2008
Junior Member

I download oracle Patch 10.2.0.3 and 10.2.0.4 ,
which release you suggest to upgrade ?
Re: Restarting Instance [message #350976 is a reply to message #350971] Sun, 28 September 2008 08:43 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I would suggest 10.2.0.4.

Please report back if this resolves your problem.

[Updated on: Sun, 28 September 2008 08:44]

Report message to a moderator

Re: Restarting Instance [message #351141 is a reply to message #350976] Mon, 29 September 2008 08:42 Go to previous messageGo to next message
mrvafaei
Messages: 27
Registered: September 2008
Junior Member

Hi ,

I didn't upgrade my database yet ,
what's your idea about following log is it some errors:

2008-09-29 16:55:48.480: [ OCRSRV][1231087936]th_select_handler: Failed to retrieve procctx from ht. constr = [-1275049456] retval lht [-27] Signal CV.
2008-09-29 16:56:38.682: [ OCRSRV][1231087936]th_select_handler: Failed to retrieve procctx from ht. constr = [-1274991248] retval lht [-27] Signal CV.
2008-09-29 16:57:48.836: [ OCRSRV][1231087936]th_select_handler: Failed to retrieve procctx from ht. constr = [-1275049456] retval lht [-27] Signal CV.
2008-09-29 16:59:49.193: [ OCRSRV][1231087936]th_select_handler: Failed to retrieve procctx from ht. constr = [-1275049456] retval lht [-27] Signal CV.
2008-09-29 17:01:49.587: [ OCRSRV][1231087936]th_select_handler: Failed to retrieve procctx from ht. constr = [-1275049456] retval lht [-27] Signal CV.
2008-09-29 17:02:40.515: [ OCRSRV][1231087936]th_select_handler: Failed to retrieve procctx from ht. constr = [-1274991248] retval lht [-27] Signal CV.
2008-09-29 17:02:40.615: [ OCRSRV][1231087936]th_select_handler: Failed to retrieve procctx from ht. constr = [-1274980928] retval lht [-27] Signal CV.
2008-09-29 17:11:51.309: [ OCRSRV][1231087936]th_select_handler: Failed to retrieve procctx from ht. constr = [-1274991280] retval lht [-27] Signal CV.
2008-09-29 17:12:40.885: [ OCRSRV][1231087936]th_select_handler: Failed to retrieve procctx from ht. constr = [-1274991280] retval lht [-27] Signal CV.
2008-09-29 17:12:40.974: [ OCRSRV][1231087936]th_select_handler: Failed to retrieve procctx from ht. constr = [-1275006992] retval lht [-27] Signal CV.
------------------

do you think with upgrading to 10.2.0.4 this problem also will be fix .

thanks .
Re: Restarting Instance [message #351154 is a reply to message #351141] Mon, 29 September 2008 09:29 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
That is a debug message that can be turned off with:

crsctl debug log crs OCRSRV:0 


and then restarting crs.
Re: Restarting Instance [message #351172 is a reply to message #351154] Mon, 29 September 2008 11:32 Go to previous messageGo to next message
mrvafaei
Messages: 27
Registered: September 2008
Junior Member

Dose it mean we will not have any log for CRS or if we will have log for some errors ?
what's levels type for crs log ?
Re: Restarting Instance [message #351178 is a reply to message #351172] Mon, 29 September 2008 12:03 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
No, it doesn't mean you won't have any log. You can turn it back on if ever needed. Again, this is a benign message and can be simply ignored too.

Referring to the documentation will help with additional questions (Dynamic Debugging).
Re: Restarting Instance [message #351192 is a reply to message #351178] Mon, 29 September 2008 14:29 Go to previous messageGo to next message
mrvafaei
Messages: 27
Registered: September 2008
Junior Member

I have another problem wit mounting OCFS partition ,
at first I mount OCFS in fstab file (Automatically) and i had a problem with this , when one of nodes starting up anothere nodes was restarting and finally i removed ocfs mounting from fstab file and mount ocfs on 2 nodes manually using following command :

mount -t ocfs2 -o datavolume,nointr /dev/sda1 /u02/ocfs2

but , now if some times the os shutdown , i need to mount ocfs partion manually again ,
do you have any idea about this problem with automatic ocfs mounting ?
Re: Restarting Instance [message #355772 is a reply to message #350976] Mon, 27 October 2008 08:40 Go to previous messageGo to next message
mrvafaei
Messages: 27
Registered: September 2008
Junior Member

I Have Upgraded oracle software to 10.2.0.4 and now my RAC is completetly Stable and all problem has fixed .
Thanks alot for you advice .
Re: Restarting Instance [message #355793 is a reply to message #355772] Mon, 27 October 2008 09:56 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Thanks for replying back. This may help others in the future.
Previous Topic: JDBC thin client connection to RAC
Next Topic: Oracle cluster crashing, why?
Goto Forum:
  


Current Time: Mon Mar 18 21:23:57 CDT 2024