SQL*Loader error 605

From: Mike S. <mis1965_at_yahoo.com>
Date: Sun, 10 Oct 1999 05:01:08 GMT
Message-ID: <38001a78.24562225_at_news.metro.net>



I'm trying to load a flat text file with about 30,000 records into Oracle 8 Personal Edition database. SQL*Loader hangs each time after displaying

    Commit point reached - logical record count 2112

If I press Ctrl-C, it displays

    SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued.

Pressing Ctrl-Break terminates it.

ORCLALRT.LOG contains the following lines:

  Current log# 2 seq# 262 mem# 0: C:\ORAWIN95\DATABASE\LOG1ORCL.ORA Thread 1 cannot allocate new log, sequence 263 Checkpoint not complete

Any ideas?

For what it's worth, this is the entire contents of ORCLALRT.LOG from the start of the latest run of SQLLDR80:

Sat Oct 09 21:52:52 1999
ORACLE V8.0.4.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows 95 V4.0, OS V192.0, CPU type 586 Starting up ORACLE RDBMS Version: 8.0.4.0.0. System parameters with non-default values:

  processes                = 50

  shared_pool_size         = 3500000

  disk_asynch_io           = FALSE

  control_files            = C:\orawin95\DATABASE\ctl1orcl.ora

  db_block_buffers         = 200

  db_block_size            = 2048

  log_buffer               = 8192

  log_checkpoint_interval = 10000

  db_files                 = 1024

  db_file_multiblock_read_count= 8

  sequence_cache_entries = 10

  sequence_cache_hash_buckets= 10

  remote_login_passwordfile= SHARED

  global_names = TRUE

  db_name                  = oracle

  job_queue_processes      = 2

  parallel_max_servers     = 5

  background_dump_dest     = %RDBMS80%\trace

  user_dump_dest           = %RDBMS80%\trace

  max_dump_file_size       = 10240

Sat Oct 09 21:52:53 1999

PMON started with pid=2
Sat Oct 09 21:52:53 1999

DBW0 started with pid=3
Sat Oct 09 21:52:53 1999

LGWR started with pid=4
Sat Oct 09 21:52:53 1999

CKPT started with pid=5
Sat Oct 09 21:52:53 1999

Sat Oct 09 21:52:53 1999

RECO started with pid=7
SMON started with pid=6
Sat Oct 09 21:52:53 1999

SNP0 started with pid=8
Sat Oct 09 21:52:54 1999

SNP1 started with pid=9
Sat Oct 09 21:52:55 1999
ALTER DATABASE MOUNT EXCLUSIVE
Sat Oct 09 21:52:55 1999
Successful mount of redo thread 1.
Sat Oct 09 21:52:55 1999
Completed: ALTER DATABASE MOUNT EXCLUSIVE Sat Oct 09 21:52:55 1999
alter database open
Sat Oct 09 21:52:56 1999
Thread 1 opened at log sequence 261
  Current log# 1 seq# 261 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA Successful open of redo thread 1.
Sat Oct 09 21:52:56 1999
SMON: enabling cache recovery
SMON: enabling tx recovery
Sat Oct 09 21:53:01 1999
Completed: alter database open
Sat Oct 09 21:53:05 1999
Thread 1 advanced to log sequence 262
  Current log# 2 seq# 262 mem# 0: C:\ORAWIN95\DATABASE\LOG1ORCL.ORA Thread 1 cannot allocate new log, sequence 263 Checkpoint not complete
  Current log# 2 seq# 262 mem# 0: C:\ORAWIN95\DATABASE\LOG1ORCL.ORA Thread 1 advanced to log sequence 263
  Current log# 1 seq# 263 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA Thread 1 advanced to log sequence 264
  Current log# 2 seq# 264 mem# 0: C:\ORAWIN95\DATABASE\LOG1ORCL.ORA Thread 1 advanced to log sequence 265
  Current log# 1 seq# 265 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA Thread 1 cannot allocate new log, sequence 266 Checkpoint not complete
  Current log# 1 seq# 265 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA Thread 1 advanced to log sequence 266
  Current log# 2 seq# 266 mem# 0: C:\ORAWIN95\DATABASE\LOG1ORCL.ORA Thread 1 advanced to log sequence 267
  Current log# 1 seq# 267 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA Thread 1 cannot allocate new log, sequence 268 Checkpoint not complete
  Current log# 1 seq# 267 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA Thread 1 advanced to log sequence 268
  Current log# 2 seq# 268 mem# 0: C:\ORAWIN95\DATABASE\LOG1ORCL.ORA Thread 1 advanced to log sequence 269
  Current log# 1 seq# 269 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA Thread 1 cannot allocate new log, sequence 270 Checkpoint not complete
  Current log# 1 seq# 269 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA Thread 1 advanced to log sequence 270
  Current log# 2 seq# 270 mem# 0: C:\ORAWIN95\DATABASE\LOG1ORCL.ORA Thread 1 advanced to log sequence 271
  Current log# 1 seq# 271 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA Received on Sun Oct 10 1999 - 07:01:08 CEST

Original text of this message