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, I'm trying to manage two (2) POP accounts using the Apple e-mail client.  One works the other doesn't.You can have as many accounts as you want, so the problem must lie in your account settings.Read other 2 answers [More]
Hi, Which table show R12 application port number ? Like FND_NODES shows node details. ThanksHi, You can get those details from the following tables: FND_NODES FND_TNS_ALIASES FND_TNS_LISTENERS FND_TNS_ALIAS_SETS FND_TNS_LISTENER_PORTS FND_TNS_ALIAS_D [More]
TCODE F-48. When we are going to pay full payment to party it works fine Problem: When we do partiall payment for example  100 kg material  Price  $100 first time: we purchase 50kg of $50 and create GRN After this when we decide to pay the remaing pa [More]
I decided to edit the photo that was my background image for my desktop home page. Now it doesn't load when I access the site from my mobile or iPad even though it is there and displays fine from my desktop. I have a mobile version of my site with a [More]
There is a issue while copying events in Outlook mapped SharePoint 2010 Calendar. This issue only seems to happen when user copies an event from his Outlook calendar to the SharePoint 2010 calendar.  He is able to create a new event in the SharePoint [More]
Hello, Is it possible for MRP to recommend Purchase Orders to be created per warehouse(based on minimum inventory levels per warehouse). Currently, MRP recommends one Purchase Order with a total of the qty's across all the warehouses. e.g. Warehouse [More]
Hi Expert,      The business wants to deliver all goods existing on a sales order togheter even if we have different good issue dates per schedule lines, probably caused by the fact both sales order lines have different routes. Therefore the material [More]
I'm creating an object movie and I can output it as a Quicktime movie (.mov) of Flash movie (.swf). One plays using Quicktime and the other Flash (I thought). When I try to play the .swf it wants to open up in Photoshop CS ImageReady and tells me Ima [More]
Hello frenz, I followed the config doc C22 Lean Campaign Mgt., but after generating the Survey URL and while Testing it, whenever I click the SAVE push button, I get this error : "The request method ïPOST is not supported by HTTP Provider service.   [More]
I recently tried to initiate a call from atop Angel Fire mountain in Angel Fire, New Mexico.  The Android Nexus could not find service so I selected Settings> More . . .> Wireless & networks> Mobile networks> Data roaming.  To that I recei [More]