vale77 wrote:
> 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
- When do you see the ORA-600 - at start up, after sessions connect,
some other time? Is there more information in a trace file?
- Why do you have "event = 16155 trace name context forever, level 1"
- log_buffer = 15728640 - a 15MB log buffer on Oracle 8i?
- processes = 50, sessions = 335 - processes and sessions should be
close to the same number.
- parallel_server = FALSE, parallel_min_servers = 10,
parallel_max_servers = 150 - Is there something wrong here?
Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.
Received on Fri Jan 19 2007 - 06:34:16 CST
