Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-00600: internal error code, arguments: [3708], [910]

ORA-00600: internal error code, arguments: [3708], [910]

From: vale77 <roswell77_at_gmail.com>
Date: 19 Jan 2007 04:15:32 -0800
Message-ID: <1169208932.785147.241290@q2g2000cwa.googlegroups.com>


Hi:
I have troubles to start oracle database instance. Is there any way to solve this ORA-00600 problem? Thanks.

I post the log, please help me,,,,,!!!

Fri Jan 19 12:29:52 2007
Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0

Starting up ORACLE RDBMS Version: 8.1.7.3.0. System parameters with non-default values:
  processes                = 50
  sessions                 = 335
  timed_statistics         = TRUE
  timed_os_statistics      = 0
  resource_limit           = TRUE
  event                    = 16155 trace name context forever, level 1
  shared_pool_size         = 134217728
  shared_pool_reserved_size= 2097152
  large_pool_size          = 0
  java_pool_size           = 1000000
  nls_language             = AMERICAN
  nls_territory            = AMERICA
  nls_date_format          = yyyy-mm-dd
  disk_asynch_io           = TRUE
  dbwr_io_slaves           = 0
  db_file_direct_io_count  = 128
  control_files            =

/dbfiles01/$ORACLE_SID/datafiles/control01.dbf,
/dbfiles01/$ORACLE_SID/datafiles/control02.dbf,
/dbfiles01/$ORACLE_SID/datafiles/control03.dbf
  db_block_buffers         = 10000
  db_block_checksum        = FALSE
  db_block_size            = 16384
  db_block_lru_latches     = 16
  db_writer_processes      = 1
  db_block_max_dirty_target= 10000
  compatible               = 8.1.7
  log_archive_start        = FALSE
  log_archive_dest_state_1 = enable
  log_archive_format       = AEU001.T%t_S%s.ARC
  log_buffer               = 15728640
  log_checkpoint_interval  = 0
  log_checkpoint_timeout   = 0
  db_files                 = 256
  db_file_multiblock_read_count= 32
  parallel_server          = FALSE
  thread                   = 1

  log_checkpoints_to_alert = FALSE
  control_file_record_keep_time= 30
  instance_number          = 1
  transactions             = 369

  transactions_per_rollback_segment= 90
  max_rollback_segments = 40
  rollback_segments = RB01, RB02, RB03, RB04, RB05, RB06, RB07, RB08, RB09, RB10, RB11, RB12, RB13, RB14, RB15, RB16
  db_block_checking        = FALSE
  max_enabled_roles        = 40
  global_names             = FALSE
  _distributed_lock_timeout= 300
  distributed_transactions = 200
  instance_name            = AEU001
  service_names            = AEU001
  open_links               = 40
  optimizer_features_enable= 8.1.7
  audit_trail              = DB
  sort_area_size           = 4194304
  sort_area_retained_size  = 1032192
  sort_multiblock_read_count= 8
  db_name                  = AEU001
  open_cursors             = 250
  ifile                    =

/usw/app/oracle/admin/AEU001/pfile/configAEU001.ora,
/usw/app/oracle/admin/AEU001/pfile/tuningAEU001.ora
  sql_trace                = FALSE
  optimizer_mode           = RULE
  optimizer_max_permutations= 80000
  optimizer_index_cost_adj = 100
  optimizer_index_caching  = 0
  query_rewrite_enabled    = FALSE
  query_rewrite_integrity  = enforced
  cursor_space_for_time    = TRUE
  session_cached_cursors   = 100
  utl_file_dir             = /dbfiles01/AEU001/utlfiledir
  job_queue_processes      = 1
  job_queue_interval       = 240
  create_bitmap_area_size  = 33554432
  bitmap_merge_area_size   = 8387584
  cursor_sharing           = exact
  parallel_min_servers     = 10
  parallel_max_servers     = 150
  hash_join_enabled        = TRUE
  hash_area_size           = 1032192
  hash_multiblock_io_count = 16
  background_dump_dest     = $ORACLE_BASE/admin/$ORACLE_SID/bdump
  user_dump_dest           = $ORACLE_BASE/admin/$ORACLE_SID/udump
  max_dump_file_size       = 50
  core_dump_dest           = $ORACLE_BASE/admin/$ORACLE_SID/cdump
  session_max_open_files = 10
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8

Fri Jan 19 12:29:56 2007
ALTER DATABASE MOUNT
Fri Jan 19 12:30:01 2007
Successful mount of redo thread 1, with mount id 213764233. Fri Jan 19 12:30:01 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Jan 19 12:31:25 2007
alter database open
Fri Jan 19 12:47:01 2007 Received on Fri Jan 19 2007 - 06:15:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US