Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

ora-600 [17182]. Any idea?

Posted on 2001-07-17
13
Medium Priority
?
1,328 Views
Last Modified: 2011-09-20
Dear experts,

during: analyze table tablename validate structure cascade

I get ora-600 [17182] [  ]  [   ], in my trace files.

In addition during dbverf80 I get a page failing, in a block# and file# which corresponds to that table.

I have NT and Oracle 8.0.5.2.6  Is this an Oracle bug?

The problem is that when I try to create a new table from the table previously mentioned, without the data residing in the block I get from dbverf80, the resulting rows are equal to the rows of the previous table, meaning I get all the data.
Afterwards I build the index and I get the same ora-600 error.

Any help would be very much appreciated.

J.K

 
0
Comment
Question by:i020242
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
  • 2
  • +2
13 Comments
 
LVL 4

Expert Comment

by:fva
ID: 6292795
AFAIS on Metalink, this error is a memory-related error (heap corruption) and is only the "root" of other problems. I also saw there are lots of "sequels" and lots of possible causes and I think you should try to work directly with Oracle people on that.

F.
0
 
LVL 1

Author Comment

by:i020242
ID: 6293186
Hi,

does this metalink suggests that an upgrade to 8.0.6.* would solve the problem?

Can you tell me what maybe going wrong?

Thanks
J.K
0
 
LVL 4

Expert Comment

by:fva
ID: 6293263
The problem seems to appear in more than one version. Actually there was no info about your particular case.
Also, the problem seems more general. It's a sign of corruption of some "magic" value in the header of a block in the memory heap. In some cases it seems that data remains OK, others have complained about data problems, too. In the global picture, you should try to work directly with Oracle to sort it out (if you have purchased the appropriate support together with your DB) or to upgrade and hope for the better.

I'm afraid that's all I can say. Maybe you'll get better advice from someone else that had experienced directly this problem. Keep therefore this Q open for a while.

F.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 1

Expert Comment

by:alx512
ID: 6293528
We took this problem too.
It appear then index has a small selectivity.
This is internal error in Oracle.
You must recreate index with better selectivity.
As a last resort you can add a primary key into index.
0
 
LVL 1

Author Comment

by:i020242
ID: 6293749
Hi,

can you be more detailed please? Give me an example. I tend to believe that this is an internal error, but what has the selectivity of an index to do with ora-600 from analyze command?

Please provide me with an example.

Cheers,
J.K
0
 
LVL 1

Expert Comment

by:alx512
ID: 6294013
Execute this statement:

select value from sys.v_$parameter
where name = 'optimizer_features_enable'

if result is 8.0.5 then disable this line in init.ora
and restart the instance. The problem must disappear.
0
 
LVL 1

Author Comment

by:i020242
ID: 6297225
Hi,

I do not have this parameter in my init.ora file, so Oracle uses the default value which is 8.0.0.

Any further help?

J.K
0
 
LVL 1

Expert Comment

by:alx512
ID: 6297291
No other ideas, sorry.
Can you show your table and index definition?
0
 
LVL 1

Author Comment

by:i020242
ID: 6297363
Hi,
here are the scripts:

_________________________________________________________
CREATE        TABLE "SAPR3"."ACCTCR"
                    ("MANDT" VARCHAR2(3) DEFAULT '000'  NOT NULL,"AWTYP" VARCHAR2(5) DEFAULT ' '  NOT NULL,"AWREF" VARCHAR2(10) DEFAULT ' '  NOT NULL,"AWORG" VARCHAR2(10) DEFAULT ' '  NOT NULL,"POSNR" VARCHAR2(10) DEFAULT '0000000000'  NOT NULL,
                    "CURTP" VARCHAR2(2) DEFAULT ' '  NOT NULL,"WAERS" VARCHAR2(5) DEFAULT ' '  NOT NULL,"WRBTR" NUMBER(13,2) DEFAULT 0  NOT NULL,"KURSF" NUMBER(9,5) DEFAULT 0  NOT NULL)
                    TABLESPACE  "PSAPBTABD"
                    PCTFREE  10  PCTUSED   40  INITRANS     1  MAXTRANS   255
                    STORAGE (INITIAL   10256K  NEXT    10240K  PCTINCREASE  0
                    /* USED SPACE   10256K */  MINEXTENTS   1  MAXEXTENTS 300);


EXIT;
___________________________________________________________
CREATE UNIQUE INDEX "SAPR3"."ACCTCR____0"
                 ON "SAPR3"."ACCTCR"("MANDT","AWTYP","AWREF","AWORG","POSNR","CURTP","WAERS")
                    TABLESPACE  "PSAPBTABI"
                    PCTFREE  10                INITRANS     2  MAXTRANS   255
                    STORAGE (INITIAL    5136K  NEXT     2560K  PCTINCREASE  0
                    /* USED SPACE    5136K */  MINEXTENTS   1  MAXEXTENTS 300);

EXIT;


___________________________________________________________
ALTER         TABLE "SAPR3"."ACCTCR"
                ADD (CONSTRAINT "ACCTCR____0"
                     PRIMARY KEY ("MANDT","AWTYP","AWREF","AWORG","POSNR","CURTP","WAERS")
                     USING INDEX TABLESPACE "PSAPBTABI"
                                 PCTFREE 10 INITRANS 2 MAXTRANS 255
                                 STORAGE (INITIAL 16K NEXT 2560K
                                          MINEXTENTS 1 MAXEXTENTS 300
                                          PCTINCREASE 0) );

EXIT;

___________________________________________________________

Please advice.

J.K




0
 
LVL 1

Expert Comment

by:Moondancer
ID: 7034598
Please update and finalize this old, open question.  Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,
Moondancer - EE Moderator

P.S.  Please click your Member Profile, expand View Question History to navigate and update all your open and locked questions.
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7053196
Lacking timely response from i020242 or contributing experts, but seeing that there is some useful info here, I recommend:

    Refund points and save as a 0-pt PAQ.

DanRollins -- EE database cleanup volunteer
0
 
LVL 1

Accepted Solution

by:
Moondancer earned 0 total points
ID: 7054320
Thanks, Dan.
I finalized this today and will monitor it in the event an adjustment is needed.
100 points refunded, PAQd to close.
Moondancer - EE Moderator
0
 
LVL 1

Expert Comment

by:alx512
ID: 7055519
Why you create a unique index and primary key on same columns? Primary key genarates index automaticaly. Oracle does not permit you to create indexes on same columns. But in this case you disturb the oracle permissions.
Drop the index and then analyze the table.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question