4 Replies Latest reply on Jan 9, 2006 5:36 AM by 417821

    Internal Error 3113 occured in qmf

    Kstore
      Who Know what kind of error is this?

      The frequency of ccure every day is of two, foor time.

      Thank's !
        • 1. Re: Internal Error 3113 occured in qmf
          439707
          Who Know what kind of error is this?
          oracle version ?
          So version
          platform ?
          The frequency of ccure every day is of two, foor
          time.
          1- what says alert$sid.log in bdump destination ?
          2- show sga

          rago pasquale
          • 2. Re: Internal Error 3113 occured in qmf
            Kstore
            Thank's a lot for collaboration : i send you the log file that i have found.

            What do you Know ???

            ---------------------------- oracle LOG ----------------
            Tue Mar 29 03:01:04 2005
            ORACLE V9.2.0.3.0 - Production vsnsta=0
            vsnsql=12 vsnxtr=3
            Windows 2000 Version 5.0 Service Pack 4, CPU type 586
            Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
            With the Partitioning, OLAP and Oracle Data Mining options
            JServer Release 9.2.0.3.0 - Production
            Windows 2000 Version 5.0 Service Pack 4, CPU type 586
            Instance name: it

            Redo thread mounted by this instance: 1

            Oracle process number: 10

            Windows thread id: 1944, image: ORACLE.EXE


            *** 2005-03-29 03:01:04.000
            *** SESSION ID:(12.3475) 2005-03-29 03:01:04.000
            Internal Error 3113 occured in qmf
            *** 2005-03-29 12:47:22.000
            Internal Error 3113 occured in qmf
            *** 2005-03-29 20:03:06.000
            Internal Error 3113 occured in qmf
            *** 2005-03-29 20:34:53.000
            Internal Error 3113 occured in qmf
            *** 2005-03-29 22:20:43.000
            OPIRIP: Uncaught error 3113. Error stack:
            ORA-03113: end-of-file on communication channel
            ORA-03113: end-of-file on communication channel

            --------------------------------- END ---------------------
            • 3. Re: Internal Error 3113 occured in qmf
              439707
              Thank's a lot for collaboration : i send you the log
              file that i have found.

              What do you Know ???
              EG:
              ORACLE V9.2.0.3.0 -
              Windows 2000 Version 5.0 Service Pack 4,
              1- show sga ?
              2- amount of RAM ?
              3- show parameter ?


              rago pasquale
              • 4. Re: Internal Error 3113 occured in qmf
                417821
                SQL> show sga

                Total System Global Area 823206048 bytes
                Fixed Size 454816 bytes
                Variable Size 192937984 bytes
                Database Buffers 629145600 bytes
                Redo Buffers 667648 bytes
                SQL> show parameter

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                O7_DICTIONARY_ACCESSIBILITY boolean FALSE
                active_instance_count integer
                aq_tm_processes integer 5
                archive_lag_target integer 1800
                audit_sys_operations boolean FALSE
                audit_trail string NONE
                background_core_dump string partial
                background_dump_dest string D:\oracle\admin\tvsnweb\bdump
                backup_tape_io_slaves boolean FALSE
                bitmap_merge_area_size integer 1048576
                blank_trimming boolean FALSE

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                buffer_pool_keep string
                buffer_pool_recycle string
                circuits integer 170
                cluster_database boolean FALSE
                cluster_database_instances integer 1
                cluster_interconnects string
                commit_point_strength integer 1
                compatible string 9.2.0.0.0
                control_file_record_keep_time integer 7
                control_files string D:\oracle\oradata\tvsnweb\CONT
                ROL01.CTL, D:\oracle\oradata\t

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                vsnweb\CONTROL02.CTL, D:\oracl
                e\oradata\tvsnweb\CONTROL03.CT
                L
                core_dump_dest string D:\oracle\admin\tvsnweb\cdump
                cpu_count integer 4
                create_bitmap_area_size integer 8388608
                cursor_sharing string EXACT
                cursor_space_for_time boolean FALSE
                db_16k_cache_size big integer 0
                db_2k_cache_size big integer 0
                db_32k_cache_size big integer 0

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                db_4k_cache_size big integer 0
                db_8k_cache_size big integer 0
                db_block_buffers integer 0
                db_block_checking boolean FALSE
                db_block_checksum boolean TRUE
                db_block_size integer 8192
                db_cache_advice string ON
                db_cache_size big integer 629145600
                db_create_file_dest string
                db_create_online_log_dest_1 string
                db_create_online_log_dest_2 string

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                db_create_online_log_dest_3 string
                db_create_online_log_dest_4 string
                db_create_online_log_dest_5 string
                db_domain string
                db_file_multiblock_read_count integer 16
                db_file_name_convert string
                db_files integer 200
                db_keep_cache_size big integer 0
                db_name string tvsnweb
                db_recycle_cache_size big integer 0
                db_writer_processes integer 1

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                dblink_encrypt_login boolean FALSE
                dbwr_io_slaves integer 0
                dg_broker_config_file1 string %ORACLE_HOME%\DATABASE\DR1%ORA
                CLE_SID%.DAT
                dg_broker_config_file2 string %ORACLE_HOME%\DATABASE\DR2%ORA
                CLE_SID%.DAT
                dg_broker_start boolean FALSE
                disk_asynch_io boolean TRUE
                dispatchers string (PROTOCOL=TCP) (SERVICE=tvsnwe
                bXDB)
                distributed_lock_timeout integer 60

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                dml_locks integer 748
                drs_start boolean FALSE
                enqueue_resources integer 968
                event string 10511 trace name context forev
                er, level 2
                fal_client string
                fal_server string
                fast_start_io_target integer 0
                fast_start_mttr_target integer 300
                fast_start_parallel_rollback string LOW
                file_mapping boolean FALSE

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                filesystemio_options string
                fixed_date string
                gc_files_to_locks string
                global_context_pool_size string
                global_names boolean FALSE
                hash_area_size integer 1048576
                hash_join_enabled boolean TRUE
                hi_shared_memory_address integer 0
                hs_autoregister boolean TRUE
                ifile file
                instance_groups string

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                instance_name string tvsnweb
                instance_number integer 0
                java_max_sessionspace_size integer 0
                java_pool_size big integer 8388608
                java_soft_sessionspace_limit integer 0
                job_queue_processes integer 10
                large_pool_size big integer 8388608
                license_max_sessions integer 0
                license_max_users integer 0
                license_sessions_warning integer 0
                local_listener string

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                lock_name_space string
                lock_sga boolean FALSE
                log_archive_dest string
                log_archive_dest_1 string LOCATION=d:\arch
                log_archive_dest_10 string
                log_archive_dest_2 string Service=Stdbydb
                log_archive_dest_3 string
                log_archive_dest_4 string
                log_archive_dest_5 string
                log_archive_dest_6 string
                log_archive_dest_7 string

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                log_archive_dest_8 string
                log_archive_dest_9 string
                log_archive_dest_state_1 string enable
                log_archive_dest_state_10 string enable
                log_archive_dest_state_2 string ENABLE
                log_archive_dest_state_3 string enable
                log_archive_dest_state_4 string enable
                log_archive_dest_state_5 string enable
                log_archive_dest_state_6 string enable
                log_archive_dest_state_7 string enable
                log_archive_dest_state_8 string enable

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                log_archive_dest_state_9 string enable
                log_archive_duplex_dest string
                log_archive_format string ARC%S_%T.arc
                log_archive_max_processes integer 2
                log_archive_min_succeed_dest integer 1
                log_archive_start boolean TRUE
                log_archive_trace integer 0
                log_buffer integer 524288
                log_checkpoint_interval integer 0
                log_checkpoint_timeout integer 1800
                log_checkpoints_to_alert boolean FALSE

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                log_file_name_convert string
                log_parallelism integer 1
                logmnr_max_persistent_sessions integer 1
                max_commit_propagation_delay integer 700
                max_dispatchers integer 5
                max_dump_file_size string UNLIMITED
                max_enabled_roles integer 30
                max_rollback_segments integer 37
                max_shared_servers integer 20
                mts_circuits integer 170
                mts_dispatchers string (PROTOCOL=TCP) (SERVICE=tvsnwe

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                bXDB)
                mts_listener_address string
                mts_max_dispatchers integer 5
                mts_max_servers integer 20
                mts_multiple_listeners boolean FALSE
                mts_servers integer 5
                mts_service string tvsnweb
                mts_sessions integer 165
                nls_calendar string
                nls_comp string
                nls_currency string

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                nls_date_format string
                nls_date_language string
                nls_dual_currency string
                nls_iso_currency string
                nls_language string AMERICAN
                nls_length_semantics string BYTE
                nls_nchar_conv_excp string FALSE
                nls_numeric_characters string
                nls_sort string
                nls_territory string AMERICA
                nls_time_format string

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                nls_time_tz_format string
                nls_timestamp_format string
                nls_timestamp_tz_format string
                object_cache_max_size_percent integer 10
                object_cache_optimal_size integer 102400
                olap_page_pool_size integer 33554432
                open_cursors integer 300
                open_links integer 4
                open_links_per_instance integer 4
                optimizer_dynamic_sampling integer 1
                optimizer_features_enable string 9.2.0

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                optimizer_index_caching integer 0
                optimizer_index_cost_adj integer 100
                optimizer_max_permutations integer 2000
                optimizer_mode string CHOOSE
                oracle_trace_collection_name string
                oracle_trace_collection_path string %ORACLE_HOME%\OTRACE\ADMIN\CDF
                \
                oracle_trace_collection_size integer 5242880
                oracle_trace_enable boolean FALSE
                oracle_trace_facility_name string oracled
                oracle_trace_facility_path string %ORACLE_HOME%\OTRACE\ADMIN\FDF

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                \
                os_authent_prefix string OPS$
                os_roles boolean FALSE
                parallel_adaptive_multi_user boolean FALSE
                parallel_automatic_tuning boolean FALSE
                parallel_execution_message_size integer 2148
                parallel_instance_group string
                parallel_max_servers integer 5
                parallel_min_percent integer 0
                parallel_min_servers integer 0
                parallel_server boolean FALSE

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                parallel_server_instances integer 1
                parallel_threads_per_cpu integer 2
                partition_view_enabled boolean FALSE
                pga_aggregate_target big integer 335544320
                plsql_compiler_flags string INTERPRETED
                plsql_native_c_compiler string
                plsql_native_library_dir string
                plsql_native_library_subdir_count integer 0
                plsql_native_linker string
                plsql_native_make_file_name string
                plsql_native_make_utility string

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                plsql_v2_compatibility boolean FALSE
                pre_page_sga boolean FALSE
                processes integer 150
                query_rewrite_enabled string FALSE
                query_rewrite_integrity string enforced
                rdbms_server_dn string
                read_only_open_delayed boolean FALSE
                recovery_parallelism integer 0
                remote_archive_enable string true
                remote_dependencies_mode string TIMESTAMP
                remote_listener string

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                remote_login_passwordfile string EXCLUSIVE
                remote_os_authent boolean FALSE
                remote_os_roles boolean FALSE
                replication_dependency_tracking boolean TRUE
                resource_limit boolean FALSE
                resource_manager_plan string
                rollback_segments string
                row_locking string always
                serial_reuse string DISABLE
                serializable boolean FALSE
                service_names string tvsnweb

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                session_cached_cursors integer 0
                session_max_open_files integer 10
                sessions integer 170
                sga_max_size big integer 823206048
                shadow_core_dump string partial
                shared_memory_address integer 0
                shared_pool_reserved_size big integer 7969177
                shared_pool_size big integer 159383552
                shared_server_sessions integer 165
                shared_servers integer 5
                sort_area_retained_size integer 0

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                sort_area_size integer 524288
                spfile string %ORACLE_HOME%\DATABASE\SPFILE%
                ORACLE_SID%.ORA
                sql92_security boolean FALSE
                sql_trace boolean FALSE
                sql_version string NATIVE
                standby_archive_dest string %ORACLE_HOME%\RDBMS
                standby_file_management string AUTO
                star_transformation_enabled string FALSE
                statistics_level string TYPICAL
                tape_asynch_io boolean TRUE

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                thread integer 0
                timed_os_statistics integer 0
                timed_statistics boolean TRUE
                trace_enabled boolean TRUE
                tracefile_identifier string
                transaction_auditing boolean TRUE
                transactions integer 187
                transactions_per_rollback_segment integer 5
                undo_management string AUTO
                undo_retention integer 10800
                undo_suppress_errors boolean FALSE

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------------------------
                undo_tablespace string UNDOTBS1
                use_indirect_data_buffers boolean FALSE
                user_dump_dest string D:\oracle\admin\tvsnweb\udump
                utl_file_dir string
                workarea_size_policy string AUTO
                SQL> spool off