ora 600 on linux after failed user level import

From: zhix <zmilos_at_sympatico.ca>
Date: 21 Jul 2003 13:20:44 -0700
Message-ID: <c59f4459.0307211220.601e9131@posting.google.com>

Environment:

Oracle8i Enterprise Edition Release 8.1.7.0.1 Red Hat Linux release 7.2
Kernel 2.4.7-10 on an i686

.bash_profile has:

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib source /usr/i386-glibc21-linux/bin/i386-glibc21-linux-env.sh

Problem:

Import (with 8.1.7 imp) to Linux server was attempted several times for user_01 - exp was done on 815 windows server with 8.1.5 exp.

(Imp works fine with same .dmp file when done on 815 windows.)

For couple of large tables, imp was failing with:

IMP-00008: unrecognized statement in the export file

I have tried different buffer sizes because I have seen it as answer/solution to similar things on Metalink, but it did
not work for these tables (~ 1 million records).

Other, "smaller", user-level 815 to 817 imports worked ok since the install, (november 2002).

So I had run "kill -9" couple of times
for the failing imp process.

Now I get ora-0600 for lookups
from "user_tables", (only user_01),
"dba_tables", (all users even system) etc.:

select count(*) from dba_indexes;

                     *

ERROR at line 1:
ORA-00600: internal error code, arguments: [12700], [2], [4202706], [18], [], [], [], []

select count(*) from dba_tables;

ERROR at line 1:
ORA-00600: internal error code, arguments: [25012], [0], [15], [], [], [], [], []

Trace file:

• Call Stack Trace ----------

calling		call		entry		arg. values in hex
location	type		point		(? means dubious v.)
--------------------------------------------------------------------
Cannot seek to string table section header in /lib/libm.so.6.
Cannot seek to string table section header in /lib/libm.so.6.
Cannot seek to string table section header in /lib/libm.so.6.

Cannot seek to string table section header in /lib/libm.so.6. Cannot seek to string table section header in /lib/libm.so.6.
...
...

For:

sql>drop user user_01 cascade all;

ORA-00600: internal.................

sql>drop user user_02 cascade all;

works ok.

user_01 sql> drop table...

for some table works, for some - ora 0600.

Any similar experiance??

rgds to all,
zhix Received on Mon Jul 21 2003 - 15:20:44 CDT