Sitemap

Amicuk Programming Answers

ORA-600 with index corruption - Any Bug ?

-0001-11-30   Views:0

Advertisement

Hi All, We have Oracle Database 10.2.0.1 on Linux Fedora Core 6 AL32UTF8 Characterset and NLS_LENGTH_SEMANTICS = CHAR For past couple of days, we are experiencing a strange problem of corruption. The indexes of many tables have been corrupted. Deleti

Hi All,
We have Oracle Database 10.2.0.1 on Linux Fedora Core 6
AL32UTF8 Characterset and NLS_LENGTH_SEMANTICS = CHAR
For past couple of days, we are experiencing a strange problem of corruption. The indexes of many tables have been corrupted. Deleting or Updating the table rows throws the dreaded ORA-600 error. We tried to trace the error with stack trace in the tool on metalink, but in vain.
We seek help to find out why the indexes are getting corrupted very often. Is there any parameter which is misbehaving or Is it the CHAR semantics playing the game?
Any help pls ?
Thanks a lot :)

The replay answer
Advertisement
ORA-00600 is not the kind of error to be solved in a forum. If you have access to metalink and you have already performed a search with the ora600 search tool. Then raise a Service Request in metalink.
On the other hand, I see you are at the first release of 10gR2 without patchset applied. I suggest you to consider applying the latest patchset and CPU available for your platform, just to avoid hitting a known bug. Most probably this will be the initial Oracle Support recommendation.
~ Madrid
http://hrivera99.blogspot.com/

Go to See the other 2 answers

ORA-600 with index corruption - Any Bug ?

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, We have Oracle Database 10.2.0.1 on Linux Fedora Core 6 AL32UTF8 Characterset and NLS_LENGTH_SEMANTICS = CHAR For past couple of days, we are experiencing a strange problem of corruption. The indexes of many tables have been corrupted. Deleti[More]

ORA-600 starting MRP on Physical Standby

Category:DefaultRelease time:-0001-11-30Views:130

Hello everybody My enviroment: Primary Site: SLES 10 SP2, Oracle 11gR1 U7 Standby Site:SLES 10 SP2, Oracle 11gR1 U7 I have a big problem starting MRP on my physical standby. After I restored standby database from a Level 0 Backup, I start MRP (SQL>re[More]

OAF Update of Custom Table causing ORA-600 with database block corruption?

Category:DefaultRelease time:2015-10-11Views:130

Using OA Framework 12.1.3, running under EBusiness Suite 12.1.3 Created Custom Web page operating against Custom Tables ISSUE On about 2% of new records, when OAF is UPDATING a record in a certain table, it  is failing with java.sql.SQLException: ORA[More]

ORA-600 in standby alert log

Category:DefaultRelease time:2015-10-11Views:130

We have recently migrated our database from Solaris to Linux (RHEL5) and since this migration we are seeing weird errors related to archive log shipping to the remote standby site and a corresponding ORA-600 in the standby site. What's interesting is[More]

Ora-600[15201] on SELECT using IN operator

Category:DefaultRelease time:-0001-11-30Views:130

This error keeps coming up when doing a SELECT * from myview WHERE column IN (value1, value2...value n...); The error only comes up everytime I use the IN operator or the = with OR operator. I can do a select where column = value1 but as soon as I us[More]

OBJ$ index corrupted

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have 9.2.0.8 DB enviroment and I retrieved ORA-600 [12700] error. I followed metalink note 155933.1 to resolve this error but there is a problem. I found that the index corrupted is I_OBJ2, an OBJ$'s index. On these kind of index I can't perfor[More]

Problem with generating xml and nested cursor (ora-600)

Category:DefaultRelease time:2015-10-11Views:130

I have a problem with generating xml (with dbms_xmlquery or xmlgen) and nested cursors. When I execute the following command, I get a ORA-600 error: select dbms_xmlquery.getxml('select mst_id , mst_source , cursor(select per.* , cursor(select ftm_fdf[More]

Ora 600 error  Arguments [25012] [11]

Category:DefaultRelease time:2015-10-11Views:130

hi, i've an ORA-00600: error Arguments [25012], [2], [11], [], [], [], [], [] by DELETE FROM table WHERE filed = :b1 ther are only 8 file in database. (not 11) Can anybody help, or give me an information about Bug number: 742709 OS NT 4 / SP6 ORACLE[More]

Oracle DR Setup Problems / ORA - 600 /

Category:DefaultRelease time:2015-10-11Views:130

Dear All, Recently we have implemented DR(Disaster Recovery setup Using Oracle data guard in 10g, GUI configurations ) in our Production server. The DR setups are based on the Maximum performance with Realtime apply mode. The configuration went fine[More]

Ora 600 and ora 7445 error in oracle 10g r2

Category:DefaultRelease time:2015-10-11Views:130

hi all, we are using Oracle 10g r2. os is windows 2003 server, ram is 4 gb. front end is java . we got a below mentioned errors. i got the RA-00600: internal error code, arguments: [qerghFetch:inc], [], [], [], [], [], [], [], and ORA-07445: exceptio[More]

ORA-600 during Apply of patch 3.1.2.00.02

Category:DefaultRelease time:-0001-11-30Views:130

I receice during installation of ApEx patch 3.1.2.00.02 following errors in the apxpatch.log ERROR at line 1: ORA-00600: internal error code, arguments: [kokegPinLob1], [], [], [], [], [], ORA-06512: at line 548 ERROR at line 1: ORA-00600: internal e[More]

Hot
Hello, Play counts are very important to me for a few reasons, but today I listed to the same song at least 4 times today at work and when I synched my iPod with iTunes the song said "Last played - 7/5/07" when clearly that isn't the case. I do [More]
I've posted this to the SCCM 2012 forum and only received one response so far that states that this is a known issue that has been discussed before and isn't easy to fix;  I was not given any actual solution either.  Since this involves SSRS I though [More]
What is Request for Routing used for in SAP? How do you use this transaction?Hi John, Welcome to the forum. Your service provider (i.e. whoever you pay your line rental to) can move the master socket within your house but won't be able to move the ca [More]
Hi I have little experience developing multi-app systems. In this specific case, I have a table that has a FK for a table in another app. My first question is: if I export the referencing app, and import it in another repository that hasn't the refer [More]
Hi everyone! Instead of Japanese Characters, a series of question marks[?] were displayed on my Oracle Developer. I had setup up the NLS_LANG of the ORACLE and ORACLE1 in ORACLE_HOMES in registry to JAPANESE_JAPAN.JA16SJIS but it still display questi [More]
Do I have to register Lightroom separate from Photoshop CC to have it included in monthly  (9.99) fee. I previously purchased Lightroom 5I think the complimentary LR5 with [email protected]$10/month is a new, distinct license for LR5 so you now have [More]
I recently purchased a MacBook Pro running Snow Leopard.  I installed Creative Suite 4 Design Standard.  Ilustrator and InDesign run well, but Photoshop will not launch.  Do I need to uninstall the entire suite and reinstall it again, or can I just r [More]
I save a lot of files to "save for web". After saving PS asks if I want to save changes to the original file. I never want to save the changes to the original. Since the default is to change the file I am afraid I will accidentally OK the change [More]
Whenever I swipe with 4 fingers on my mac, firefox goes forward or back depending on the direction. I want it to stop doing this. How do I make it so?You can also try to set the related <b>browser.gesture</b> prefs to an empty string value on [More]
now i can't seem to get past he confirmation of my e-mail. nothing on the page to confirm my e-mail appears to click to advance on....what is up?If this app was bought by your sister with her Apple ID, only her ID can update the app.Read other 2 answ [More]