6 Replies Latest reply on Feb 6, 2007 8:15 PM by 530897

Ora-08102 - error help me out

444974 Feb 6, 2007 6:03 PM

dear all,

Im getting ora-8102 error
"ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 49, file 47, block 25578 (2)" while im creating index on newly created table . I found the suggestion doc from metalink for the same. but it didn't work. because the obj#49 is the index (I_CON2) which related to table CON$. so im not able to rebuild the index as suggested in metalink.

Im getting the same erorr for all schema even creating new table with constraints.

Thanks
mohan

1. Re: Ora-08102 - error help me out

Kamal Kishore Feb 6, 2007 6:22 PM (in response to 444974)

Have you contacted Oracle Support on this?

ORA-08102 index key not found, obj# string, dba string (string)

Cause: This is an internal error; possible inconsistency in index.

Action: Send trace file to Oracle Support Services, along with information on reproducing the error.
Like Show 0 Likes(0)

Actions

2. Re: Ora-08102 - error help me out

Eduardo Legatti Feb 6, 2007 7:09 PM (in response to 444974)

Hi,

>>so im not able to rebuild the index as suggested in metalink.
Why not ? Did you try and received an error ?

SYS@ORACLE10> select owner,index_name,table_name,status from dba_indexes where index_name='I_CON2';



OWNER      INDEX_NAME       TABLE_NAME         STATUS

---------- ---------------- ------------------ ----------

SYS        I_CON2           CON$               VALID

Cheers

3. Re: Ora-08102 - error help me out

Kamal Kishore Feb 6, 2007 7:26 PM (in response to Eduardo Legatti)

Why not ?

Just a guess, since there is no error message from OP, Probably because:

SQL> alter index I_CON2 rebuild ;

alter index I_CON2 rebuild

*

ERROR at line 1:

ORA-00701: object necessary for warmstarting database cannot be altered





SQL> disc

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.7.0 - Production

SQL>

4. Re: Ora-08102 - error help me out

Eduardo Legatti Feb 6, 2007 7:33 PM (in response to Kamal Kishore)

Hi,

>>Just a guess
Well, me too because the action was suggested in metalink as OP said.

Cheers
Like Show 0 Likes(0)

Actions
5. Re: Ora-08102 - error help me out

444974 Feb 6, 2007 8:04 PM (in response to Eduardo Legatti)

yes im getting the same result while executing your query
Like Show 0 Likes(0)

Actions
6. Re: Ora-08102 - error help me out

530897 Feb 6, 2007 8:15 PM (in response to 444974)

If you can reproduce the error and have found no notes on Metalink that either match your problem or do not resolve the problem, you should consider creating an SR with Oracle Support to help you find a resolution.
Like Show 0 Likes(0)

Actions

Go to original post