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, I started an iMovie project on my MBP but want to finish it on my more powerful iMac. I copied the project file from my MBP to my iMac, but when I start iMove, the project does not appear in my project pane. Any idea what's wrong here?Hello P-Pod [More]
Hi! i'm doing a project using jsp is there any way to create a simple discussion board like the one here? can anyone who knows pls forward some links that teaches me how to do it step by step. Thanks for your help and have a nice day :)From the UK! - [More]
In my new iPad2 I have no problem with my incoming mail because Ipad2 can read Windows attachements like "word or excell" . The problem I confront is if I want to send a message with an attachement from itunes apps like "pages or numbers&qu [More]
Hi colleagues, I need to download some PDF files from a folder in AL11. But when I try to enter the source file path in transaction CG3Y, in the first field "Source file on application server" I cannot enter the full path of the file. Apparently [More]
why is it that im still getting high latency with just me on the internet not downloading and just playing a game, there are only 30 people in the cabinet out of 100 and ive just noticed the latency has only gotten really high since its gotten windy, [More]
My wife tried to open Safari on her Macbook Air and got audio message on a Safari mini-window saying her network has been hacked and that she needs help from http://www.fixpc99.com and wants her to call a helpline at (647) 360-4442. Never saw and aud [More]
HI, no matter what configurations I do the static listener shows no services. Can you help me? Here is my listener.ora: SID_LIST_LISTENER =         (SID_LIST =                 (SID_DESC =                         (GLOBAL_DBNAME=ELLISON9)               [More]
I have a DataGrid that gets its data from an HttpService. If the first row of the data from the http request has a null value for a given field, I get the "Cannot determine comparator for Sortfield" error. I think the simplest workaround would b [More]
Hi there, I would like to check out the new BPM Feature within the NetWeaver    CE, but I'm a little confused about all the different versions available. There is a CE 7.1 Trial SP 3, CE 7.1 Trial SP 5 and a CE 7.1 Trial EHP 1... Whats the current Ve [More]
Hi, I have a requirement, Learner can see the Course type but can't book(needs to restrict). Only Training Admin need to book that course. How to do . Please help. Regards, SushmaHi, Please help. Regards, SushmaRead other 3 answers [More]