Home » Server Options » RAC & Failsafe » Ora -1461 in RAC (Oracle 10.2.0.4 , Linux AS4, Cluster Ware 2)
Ora -1461 in RAC [message #392884] Thu, 19 March 2009 10:02 Go to next message
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
Re: Ora -1461 in RAC [message #392888 is a reply to message #392884] Thu, 19 March 2009 10:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Ora -1461 in RAC [message #392890 is a reply to message #392884] Thu, 19 March 2009 10:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous messageGo to next message
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
Re: Ora -1461 in RAC [message #392913 is a reply to message #392906] Thu, 19 March 2009 11:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.

Re: Ora -1461 in RAC [message #392921 is a reply to message #392914] Thu, 19 March 2009 11:46 Go to previous messageGo to next message
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.
Re: Ora -1461 in RAC [message #392923 is a reply to message #392921] Thu, 19 March 2009 12:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Ora -1461 in RAC [message #392946 is a reply to message #392923] Thu, 19 March 2009 14:22 Go to previous messageGo to next message
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
Re: Ora -1461 in RAC [message #392960 is a reply to message #392946] Thu, 19 March 2009 16:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.

Re: Ora -1461 in RAC [message #392963 is a reply to message #392960] Thu, 19 March 2009 17:28 Go to previous message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Thanks Mahesh for that note.

And thanks for your time on this.
Previous Topic: Oracle Cluster Registry and Voting Files
Next Topic: ORA-15106 in ASM
Goto Forum:
  


Current Time: Wed Dec 07 14:40:48 CST 2016

Total time taken to generate the page: 0.12430 seconds