Re: ora 600 on linux after failed user level import

zhix wrote:

> 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

ORA-00600 is an unhandled error in Oracle's code ... not yours. Open an iTAR at http://metalink.oracle.com

But before you do that the first thing Oracle will ask is why you haven't upgraded to the latest patch set for your version of Oracle. You should be at 8.1.7.4.x. Upgrade first and likely the problem will go away.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)