OraFAQ Forum: RAC & Failsafe » Ora -1461 in RAC

Home » Server Options » RAC & Failsafe » Ora -1461 in RAC (Oracle 10.2.0.4 , Linux AS4, Cluster Ware 2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Ora -1461 in RAC [message #392884]

Thu, 19 March 2009 10:02

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hi All,

We are getting the below error in our OEM

Metric Value=ORA-1461 encountered when generating server alert SMG-3500
Time/Line Number=Thu Mar 19 10:11:21 2009/10998
Timestamp=Mar 19, 2009 10:17:54 AM EST
Severity=Warning
Message=ORA-error stack (1461) logged in /opt/oracle/admin/WVOP/bdump/alert_WVOP3.log.

And this is what the contents in the Alert Log file

Incremental checkpoint up to RBA [0x5eb0.a698b.0], current log tail at RBA [0x5eb0.a7450.0]
Thu Mar 19 10:11:21 2009
ORA-1461 encountered when generating server alert SMG-3500
Thu Mar 19 10:12:42 2009
Incremental checkpoint up to RBA [0x5eb0.aaaed.0], current log tail at RBA [0x5eb0.ab1bb.0]
Thu Mar 19 10:22:44 2009

Not sure what's the porblem and solution for this .

Can anybody help on this.

Regards,
Raj

Report message to a moderator

Re: Ora -1461 in RAC [message #392888 is a reply to message #392884]

Thu, 19 March 2009 10:12

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>ORA-1461 encountered when generating server
That is known issue. Check metalink. There should be many bugs reported.

Report message to a moderator

Re: Ora -1461 in RAC [message #392890 is a reply to message #392884]

Thu, 19 March 2009 10:18

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

rsreddy28,
I lost my count of posts asking you to use CODE tags.
In fact, you forced me to switch to monotype fonts so that I read the message in some cases.
Seems you are not getting what CODE tag means
or
Just ignoring the call.
Use CODE tags when posting code/error messages. There is no point in using BOLD tag.

this is your format with BOLD tags

incremental checkpoint up to RBA [0x5eb0.a698b.0], current log tail at RBA [0x5eb0.a7450.0]
Thu Mar 19 10:11:21 2009
ORA-1461 encountered when generating server alert SMG-3500
Thu Mar 19 10:12:42 2009
Incremental checkpoint up to RBA [0x5eb0.aaaed.0], current log tail at RBA [0x5eb0.ab1bb.0]
Thu Mar 19 10:22:44 2009

and this with CODE tags.

incremental checkpoint up to RBA [0x5eb0.a698b.0], current log tail at RBA [0x5eb0.a7450.0]
Thu Mar 19 10:11:21 2009
ORA-1461 encountered when generating server alert SMG-3500
Thu Mar 19 10:12:42 2009
Incremental checkpoint up to RBA [0x5eb0.aaaed.0], current log tail at RBA [0x5eb0.ab1bb.0]
Thu Mar 19 10:22:44 2009

All you have to do is,
post your code/erros within [ CODE ] and [ /CODE ] without the space around CODE

[Updated on: Thu, 19 March 2009 10:20]

Report message to a moderator

Re: Ora -1461 in RAC [message #392906 is a reply to message #392890]

Thu, 19 March 2009 11:07

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hi Mahesh,

My apologies for the wrong format . I'll ensure that code tags will be used while writing to the forums for better readability.

And about that Ora-1461 , in the Metalink they gave a temporary fix:

1. Flush the shared pool.
2. Change the parameter SESSION_CACHED_CURSORS = 0

Can we do this in the production box . What will be the implications of this if we do .

Regards,
Raj

Report message to a moderator

Re: Ora -1461 in RAC [message #392913 is a reply to message #392906]

Thu, 19 March 2009 11:23

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Can we do this in the production box .

Can you continue without it?

Quote:

What will be the implications of this if we do .

Performances (highly) decrease.

Regards
Michel

[Updated on: Thu, 19 March 2009 11:23]

Report message to a moderator

Re: Ora -1461 in RAC [message #392914 is a reply to message #392906]

Thu, 19 March 2009 11:23

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I donot know which document you check and taking the advice blindly.
The one I checked says it might be bug.
>> What will be the implications of this if we do
Again, do not take this personal.
YOu have to research that. Just look into docs. It is all there.
Nobody can predict what might happen to your database when you do something . The standard behavior is documented.

Report message to a moderator

Re: Ora -1461 in RAC [message #392921 is a reply to message #392914]

Thu, 19 March 2009 11:46

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Actually there is Document in the Metalink : 461911.1 , which says about it:

Apply Patch 6602742 or Also you can work around with this:

Flushing the shared pool can help remove the problem cursor from the shared pool.
-Using SESSION_CACHED_CURSORS = 0 can help in some cases.

Report message to a moderator

Re: Ora -1461 in RAC [message #392923 is a reply to message #392921]

Thu, 19 March 2009 12:01

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Your post says,
>>Oracle 10.2.0.4
And the doc says
>>3-The problem is now solved in the following versions:
>>10.2.0.4

I would open a TAR and get proper help before continuing to do any harm. If you would research, there is a another bug specifically for RAC.
Please apply caution before doing anything.

Report message to a moderator

Re: Ora -1461 in RAC [message #392946 is a reply to message #392923]

Thu, 19 March 2009 14:22

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Thanks Mahesh,

After discussing with our Team , we raised an SR and even they suggested the same and we decided for an RFC and planning to apply the Patch what Oracle has suggested.

And you were suggesting about another bug that is specific to RAC environment about my issue . I did searched a lot but couldn't find it . Can you please help me out in that so that if it's required we can plan even for that .

Regards,
Raj

Report message to a moderator

Re: Ora -1461 in RAC [message #392960 is a reply to message #392946]

Thu, 19 March 2009 16:56

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>bug that is specific to RAC environment
Please ignore it.
The way I understand about this issue is, it does not bring any loss of service or data. May be you can live with it, until the next scheduled downtime.
But I am not the authority on this.
It is upto Oracle support to decree and you to decide.
My point is, just do not anything because it is written somewhere.

Report message to a moderator

Re: Ora -1461 in RAC [message #392963 is a reply to message #392960]

Thu, 19 March 2009 17:28

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Thanks Mahesh for that note.

And thanks for your time on this.

Report message to a moderator

Previous Topic:	Oracle Cluster Registry and Voting Files
Next Topic:	ORA-15106 in ASM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 17 20:29:19 CST 2024