tag:blogger.com,1999:blog-31216575.post8416284796590990405..comments2024-01-27T07:32:53.464+01:00Comments on On The Peoplesoft Road: DEMO HRMS 9.0 : ORA-00600Nicolas Gasparottohttp://www.blogger.com/profile/06634519580752248909noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-31216575.post-70099223736029819752012-02-09T08:08:52.636+01:002012-02-09T08:08:52.636+01:00Thanks, this solved the problem faced my company&#...Thanks, this solved the problem faced my company's client.<br /><br />Kelvin (Peoplesoft Consultant - Malaysia)MiNhttps://www.blogger.com/profile/13844852403312947253noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-56286576195453665122011-07-13T23:27:08.112+02:002011-07-13T23:27:08.112+02:00Excellent post!!Excellent post!!Deveshhttps://www.blogger.com/profile/14189724905083143689noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-4679729454310947082009-03-23T20:53:00.000+01:002009-03-23T20:53:00.000+01:00THANKS A LOT, FOR YOU EXPLANATION..WE HAVE SET ON ...THANKS A LOT, FOR YOU EXPLANATION..<BR/>WE HAVE SET ON "TRUE" THE VALUE'S PARAMETER.NOW, WE WILL PROCEED WHIT THE TESTS CASES. I HOPE DON'T FIND ANY ORA600'S ERROR....<BR/>I'LL LET YOU ABOUT THE RESULTS....<BR/>THANKS AGAIN...<BR/><BR/><BR/>NICOLASUnknownhttps://www.blogger.com/profile/03632174943939299805noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-25827584751138396142009-03-23T16:46:00.000+01:002009-03-23T16:46:00.000+01:00If you are on 10.2.0.4 and experiencing same issue...If you are on 10.2.0.4 and experiencing same issue as the post describe, then you should :<BR/>1. change the parameter "_IGNORE_DESC_IN_INDEX" to true (no bounce is required), alter system with scope=both should do the trick<BR/>2. rebuild the index through Application Designer<BR/>Oracle will ignore the DESC order by himslef because the parameter value is TRUE. Everything is explained in the steps described in the post, at least I hope it is clear.<BR/>My previous comment was in case of you are upgrading your db to 11g.Nicolas Gasparottohttps://www.blogger.com/profile/06634519580752248909noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-4093175861744117112009-03-23T16:39:00.000+01:002009-03-23T16:39:00.000+01:00I HAVE A QUESTION ABOUT YOUR LAST COMMENTS, WE KEE...I HAVE A QUESTION ABOUT YOUR LAST COMMENTS, WE KEEPING IN MIND THAT THE ORACLE RELEASE IS 10.2.0.4. YOU TELL ME, IF I'M RIGHT ABOUT IT.... FIRST, I SHOULD TO SET THE PARAMETER ON "TRUE" AND RESTART THE DATABASE. THEN, I SHOULD TO VERIFY IF THE "ORA600 ERROR" HAS GONE....<BR/>ONLY, IF WE GET THE SAME BEHAVIOR (ORA 600 ERROR) THEN WE TOO SHOULD TO REBUILD ALL INDEXES WITHOUT CLAUSE "desc".<BR/>OTHERWISE, IF THE ERROR HAS GONE, WE DON'T NEED TO DO ANYTHING...<BR/>I'M APOLOGY BY MY POOR AND BASIC ENGLISH....<BR/>I'M HOPE THAT YOU UNDERSTAND ME.<BR/>REGARDS.<BR/><BR/><BR/>NICOLAS NANOUnknownhttps://www.blogger.com/profile/03632174943939299805noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-70816338031521391942009-03-23T16:18:00.000+01:002009-03-23T16:18:00.000+01:00Of course, after removing the parameter from spfil...Of course, after removing the parameter from spfile and bouncing the db (I mean your 11g database), you'll need to rebuild the index as well from AppDesigner to be again DESC ordered.Nicolas Gasparottohttps://www.blogger.com/profile/06634519580752248909noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-82978944051837947742009-03-23T16:11:00.000+01:002009-03-23T16:11:00.000+01:00I recently upgraded my databases of my labs to Ora...I recently upgraded my databases of my labs to Oracle 11.1.0.7, then removed this parameter from spfile (alter system reset "_IGNORE_DESC_IN_INDEX" scope=spfile sid='*') and bounce my db. Finally, the ORA-600 is gone, this case is not reproductible on 11.1.0.7 with standard parameter value.Nicolas Gasparottohttps://www.blogger.com/profile/06634519580752248909noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-44490186270148070652009-03-23T16:04:00.000+01:002009-03-23T16:04:00.000+01:00EXCELENT YOUR POST, WE HAVE SAME SYMPTOMS OVER PEO...EXCELENT YOUR POST, WE HAVE SAME SYMPTOMS OVER PEOPLE SOFT APPLICATION. I'M FROM ARGENTINA, I'M DBA ORACLE AND I TURN ON TRUE THE HIDDEN PARAMETER. WE HAVE RELEASE 10.2.0.4 ON AIX 5.3 SYSTEM, 64BITS. PLEASE LET US TO KNOW IF REALLY IT FIXED ON 11g.<BR/>BEST REGARDS.<BR/><BR/><BR/>NICOLAS(DBA ORACLE - ARGENTINA)Unknownhttps://www.blogger.com/profile/03632174943939299805noreply@blogger.com