Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-12151 TNS:Received bad packet type from network layer
All,
One of our customers is getting the following error
java.sql.SQLException: Io exception: Bad packet type from a Java 1.1.8 client connected to Oracle 8.0.5.1 database on SuSE 7.2. Server has 512M memory.
The error is consistantly occuring for a specific query where a table with about 100,000 rows is queried on it's primary key.
Does anyone have any ideas?
(v$paramater contents included for anyone who is interested)
Thanks,
Pascal
NAME VALUE ---------------------------------------------------------------------- spin_count 1 processes 100 sessions 115 timed_statistics FALSE timed_os_statistics 0 resource_limit FALSE license_max_sessions 0 license_sessions_warning 0 lm_procs 127 lm_ress 6000 lm_locks 12000 ogms_home parallel_transaction_resource_timeout 300 cpu_count 1
instance_groups
event
shared_pool_size 3500000 shared_pool_reserved_size 175000 shared_pool_reserved_min_alloc 5K large_pool_size 0 large_pool_min_alloc 16K pre_page_sga FALSE shared_memory_address 0 hi_shared_memory_address 0 use_indirect_data_buffers FALSE use_ism TRUE lock_sga FALSE lock_sga_areas 0
instance_nodeset
lock_name_space
enqueue_resources 265
nls_language
AMERICAN
nls_territory AMERICA
nls_sort
nls_date_language
nls_date_format nls_currency nls_numeric_characters
nls_iso_currency
nls_calendar
disk_asynch_io TRUE tape_asynch_io TRUE dbwr_io_slaves 0 lgwr_io_slaves 0 arch_io_slaves 0 backup_disk_io_slaves 0 backup_tape_io_slaves FALSE db_file_direct_io_count 64
control_files
/ora00/oradata/
RSM/control01.ctl, /ora00/oradata/RSM/control02.ctl, /ora00/orada
db_file_name_convert
log_file_name_convert
db_block_buffers 200
buffer_pool_keep
buffer_pool_recycle
db_block_checksum FALSE db_block_size 2048 db_block_checkpoint_batch 8 db_block_lru_statistics FALSE db_block_lru_extended_statistics 0 db_writer_processes 1 db_block_lru_latches 1
db_block_max_dirty_target
4294967294
max_commit_propagation_delay 90000 compatible 8.0.0 compatible_no_recovery 0.0.0 log_archive_start FALSE log_archive_buffers 4 log_archive_buffer_size 127
log_archive_dest
?/dbs/arch
log_archive_duplex_dest
log_archive_min_succeed_dest 1
log_archive_format
%t_%s.dbf
log_buffer 8192 log_checkpoint_interval 10000 log_checkpoint_timeout 0 log_block_checksum FALSE log_small_entry_max_size 80 log_simultaneous_copies 0 db_files 80 db_file_simultaneous_writes 4 db_file_multiblock_read_count 8 log_files 255 read_only_open_delayed FALSE parallel_server FALSE gc_lck_procs 1 gc_latches 2 gc_releasable_locks 0
gc_rollback_locks
gc_files_to_locks
gc_defer_time 10 thread 0 freeze_DB_for_fast_instance_recovery FALSE log_checkpoints_to_alert FALSE recovery_parallelism 0 control_file_record_keep_time 7 temporary_table_locks 115 dml_locks 100 row_locking always serializable FALSE replication_dependency_tracking TRUE delayed_logging_block_cleanouts TRUE instance_number 0 max_rollback_segments 30 transactions 126 transactions_per_rollback_segment 11 rollback_segments r01,r02, r03,
cleanup_rollback_entries 20 transaction_auditing TRUE discrete_transactions_enabled FALSE sequence_cache_entries 10 sequence_cache_hash_buckets 10 row_cache_cursors 10 os_roles FALSE max_enabled_roles 20 remote_os_authent FALSE remote_os_roles FALSE O7_DICTIONARY_ACCESSIBILITY TRUE remote_login_passwordfile NONE dblink_encrypt_login FALSE license_max_users 0 db_domain WORLD global_names TRUE distributed_lock_timeout 60 distributed_transactions 31 max_transaction_branches 8 distributed_recovery_connection_hold_time 200 commit_point_strength 1 mts_service RSM
mts_rate_log_size
mts_rate_scale mts_dispatchers mts_servers 0 mts_max_servers 20 mts_max_dispatchers 5
local_listener
mts_listener_address
mts_multiple_listeners FALSE open_links 4 open_links_per_instance 4 close_cached_open_cursors FALSE optimizer_features_enable 8.0.0 fixed_date audit_trail NONE sort_area_size 65536 sort_area_retained_size 0 sort_direct_writes AUTO sort_write_buffers 2 sort_write_buffer_size 32768 sort_spacemap_size 512 sort_read_fac 5 db_name RSM open_cursors 50
ifile
/opt/oracle/adm
in/RSM/pfile/configRSM.ora
sql_trace FALSE os_authent_prefix ops$ optimizer_mode CHOOSE sql92_security FALSE blank_trimming FALSE
always_anti_join
NESTED_LOOPS
partition_view_enabled FALSE b_tree_bitmap_plans FALSE star_transformation_enabled FALSE complex_view_merging FALSE push_join_predicate FALSE fast_full_scan_enabled FALSE parallel_broadcast_enabled FALSE parallel_adaptive_multi_user FALSE
always_semi_join
standard
optimizer_max_permutations 80000 optimizer_index_cost_adj 100 optimizer_index_caching 0 serial_reuse DISABLE cursor_space_for_time FALSE session_cached_cursors 0 text_enable FALSE
remote_dependencies_mode
TIMESTAMP
utl_file_dir
plsql_v2_compatibility FALSE job_queue_processes 0 job_queue_interval 60 job_queue_keep_connections FALSE snapshot_refresh_processes 0 snapshot_refresh_interval 60 snapshot_refresh_keep_connections FALSE optimizer_percent_parallel 0 optimizer_search_limit 5 parallel_min_percent 0 parallel_default_max_instances 0 cache_size_threshold 20 create_bitmap_area_size 8388608 bitmap_merge_area_size 1048576 parallel_min_servers 0 parallel_max_servers 5 parallel_server_idle_time 5 allow_partial_sn_results FALSE
parallel_instance_group
ops_admin_group
parallel_execution_message_size 2148 parallel_min_message_pool 48330 hash_join_enabled TRUE hash_area_size 0 hash_multiblock_io_count 1 shadow_core_dump full background_core_dump full
background_dump_dest
?/rdbms/log
user_dump_dest
?/rdbms/log
max_dump_file_size 10240 core_dump_dest ?/dbs
audit_file_dest
?/rdbms/audit
reduce_alarm FALSE oracle_trace_enable FALSE
oracle_trace_facility_path
?/otrace/admin/
fdf
oracle_trace_collection_path
?/otrace/admin/
cdf
oracle_trace_facility_name oracled
oracle_trace_collection_name
oracle_trace_collection_size 5242880 object_cache_optimal_size 102400 object_cache_max_size_percent 10 session_max_open_files 0 aq_tm_processes 0Received on Wed Jul 17 2002 - 11:36:47 CDT