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
Hi Friends, The process chain that I scheduled is getting failed at the Infopackage loading stage. On checking the diplay message, I found the following log: Cannot stage requested data for datasource Error in source system I activated the datasource [More]
I have a PC with Windows 7 x64. I have Elements 13. I installed a plug-in (Topaz) which appeared under the Filter Menu. Then I tried to install my new Canon Printer software plug-in which put it under FILE > AUTOMATION TOOLS. However, when I tried to [More]
Hello i have a problem in a SapScript footer. In SPRO -> Financial Accounting (New) -> Financial Account Basic Settings (New) -> Global Parameters for Company Code -> ENTER GLOBAL PARAMETERS. I have the company 0300 that as various phone numbe [More]
I've noticed a problem with time zones in the latest version of the PlayBook OS. When you set the time zone to Saskatchewan it will display the correct time on the Date and Time page but the time that shows up in the status bar is one hour later. Any [More]
Hi Guys, I just want to know when you install Apex in a PDB does the CDB and PDB have to have the same port number in order to access the Apex Admin page. I have the following set up: PDB1   Port - 5502   (With successful Apex install) CDB     Port - [More]
How do you remove duplicate images from your all images file on your mac desktop?Don't under any circumstances. All images is not a file. It's not a place. It's a list. Specifically, it's the result of an instruction: List all the images on my machin [More]
Recently got two new iPhones for my teenagers.  Now I want to set up Family Share.  I've looked at the instructions for how to do this repeatedly - am directed to go to iCloud settings and set this up there.  However, there is nothing that links to F [More]
Hi, Business object 'catalog product' use component GS_CM We want to hide buttons: Attachment and URL We need to use only button Advanced. How I can customize it? Denis.Dear Denis, Enhance Component GS_CM and view DocList. Redefine method IF_BSP_WD_T [More]
hi i recently bought an airport express unit for the purposes of extending the range of my existing broadband signal in my house. There is poor reception in the downstairs area. The broadband connection is located upstairs and is a Netopia 3347WG box [More]
I'm developing a chat server and I am handling it with threads. I developed a executable class to handle all and I'm putting all the users in two Hashtables. There are two kinds of users. I need to know how many users do you gurus believe it can supp [More]