Ora-600 error while using SQL*Loader in Oracle 9i database

Ora-600 error while using SQL*Loader in Oracle 9i database

Post by bobb » Fri, 14 Dec 2001 02:38:19



I am trying to use Sql*loader in direct mode on Oracle 9i database and
I am getting ORA-600 errors. I used the same datafiles and same
control files a month ago and never had this problem. But now I get
this error and the error is not consistent. Some days it happen
consistently and some times it works fine. I tried using conventional
load and most of the times I don't get ORA-600 erros, but sometimes I
do. Once I make few changes by trucating table or by dropping indexes,
it works fine. Any clues on what's going on and what needs to be done.
Any help is gretely appreciated. I ran dbverify and none of the
datafiles are corrupted.
 
 
 

1. ora-600 error in 9i

I downloaded 9i to try it out and i've come up with an ora-600 error.
My previous job had Gold support so reporting problems was easy. This
company does not have a support contract with Oracle and I don't know
how to report this problem. If anyone has any suggestions, please let
me know.

Anyway, here is the problem

I have a simple table
create table address_table (street varchar2(100), zip varchar2(100));

I loaded it with one row
insert into address_table values ('ELM ST', '12345');

I wrote a java class called Address with for methods
Address.addAddress(street, zip)
Address.deleteAddress(street)
Address.updateAddress(street, zip)
String Address.selectAddress(street)

Each of these four methods were originally written to test out java
stored procedures, they work flawlessly inside both Oracle 8.1.7 and
9.0.1

When I put a connect method (thin) and a main, I get the following
error during

   try
    {
        String sql ="SELECT zip FROM Address_table WHERE street = ?";

        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, street);
        System.out.println("got here");
        ResultSet rset = pstmt.executeQuery();
        while (rset.next())
        {
            zipStr = rset.getString(1);
        }
        pstmt.close();

got here
ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [],
[], [], [], []

This is the readable part of the trace file produced....

Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
ORACLE_HOME = /dev_tools/oracle/product/9.0.1
System name:    SunOS
Node name:  XXXXX
Release:    5.7
Version:    Generic_106541-12
Machine:    XXXXX
Instance name: TSTDB
Redo thread mounted by this instance: 1
Oracle process number: 8

*** SESSION ID:(7.457) 2001-06-27 08:23:33.989
*** 2001-06-27 08:23:33.989
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [],
[], [], [
], []
Current SQL statement for this session:
SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER
='NLS_DATE_FORMAT'

Any ideas?

Carl

2. Clustered Index

3. 9i giving ORA 600 error via JDBC

4. Paradox 7.0 on a Network

5. Oracle 9i strange behavior (ORA-600)

6. WANTED ALLIANCE - RDBMS

7. ORA-600, ORA-8177, ORA-6512 Errors via ODBC

8. SQLSvr 7.0 Set up questions

9. ORA-600 error when using OCIAQDeq

10. Error ORA 1578 + ORA 600...

11. ORA-600: internal error code and ORA-8177 Can't Serialize access

12. ora-600 [15212] + ora-7445 + ora-4031

13. URGENT HELP !!! ---- ORA-600 [16224] error