ORA 7445 ERROR(ORACLE 11G)

[manoj]

Dear Sir

I am using oracle 11G new feature called Automatic diagnostic
repository.After writing adrci
command on the command prompt

C:\>adrci

ADRCI: Release 11.1.0.6.0 - Beta on Fri Oct 24 11:47:57 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ADR base = "c:\ora11g"
adrci> show incident

ADR Home = c:\ora11g\diag\clients\user_sach\host_2044677156_11:
*************************************************************************
0 rows fetched

ADR Home = c:\ora11g\diag\clients\user_system\host_2044677156_11:
*************************************************************************
0 rows fetched

ADR Home = c:\ora11g\diag\clients\user_unknown\host_2044677156_11:
*************************************************************************
0 rows fetched

ADR Home = c:\ora11g\diag\clients\user_unknown\host_411310321_11:
*************************************************************************
0 rows fetched

ADR Home = c:\ora11g\diag\rdbms\orcl\orcl:
*************************************************************************
INCIDENT_ID PROBLEM_KEY
CREATE_TIME
--------------------
-----------------------------------------------------------
----------------------------------------
15721 ORA 7445 [PC:0x7C343300]
2008-09-16 10:22:31.924000 +05:30
1 rows fetched

adrci> exit


In the incident I can find that the prblem key as ORA 7445 WITH
INCIDENT ID AS 15721.

What could be the cause of the below issue?

Regards

[ddf]

One consults the alert log for the database reporting the incident.
Obviously you have yet to access this log, else you'd have discovered
the source of that error.


David Fitzjarrell

[manoj]

Dear Sir

I would also like to request you to please check the incident log file
of 15721


*** 2008-09-16 10:24:56.242
[0004]: log_archive_dest_state_6=enable
[0004]: log_archive_dest_state_7=enable
[0004]: log_archive_dest_state_8=enable
[0004]: log_archive_dest_state_9=enable
[0004]: log_archive_dest_state_10=enable
[0004]: log_archive_max_processes=4
[0004]: log_archive_min_succeed_dest=1
[0004]: standby_archive_dest=%ORACLE_HOME%\RDBMS
[0004]: log_archive_trace=0
[0004]: log_archive_local_first=TRUE
[0004]: log_archive_format=ARC%S_%R.%T
[0004]: log_checkpoint_interval=0
[0004]: log_checkpoint_timeout=1800
[0004]: archive_lag_target=0
[0004]: db_files=200
[0004]: db_file_multiblock_read_count=20
[0004]: read_only_open_delayed=FALSE
[0004]: cluster_database=FALSE
[0004]: parallel_server=FALSE
[0004]: parallel_server_instances=1
[0004]: cluster_database_instances=1
[0004]: standby_file_management=MANUAL
[0004]: thread=0
[0004]: fast_start_io_target=0
[0004]: fast_start_mttr_target=0
[0004]: log_checkpoints_to_alert=FALSE
[0004]: db_lost_write_protect=NONE
[0004]: recovery_parallelism=0
[0004]: db_flashback_retention_target=1440
[0004]: dml_locks=748
[0004]: replication_dependency_tracking=TRUE
[0004]: transactions=187
[0004]: transactions_per_rollback_segment=5
[0004]: undo_management=AUTO
[0004]: undo_retention=900
[0004]: fast_start_parallel_rollback=LOW
[0004]: resumable_timeout=0
[0004]: instance_number=0
[0004]: db_block_checking=FALSE
[0004]: recyclebin=on
[0004]: db_securefile=PERMITTED
[0004]: serial_reuse=disable
[0004]: ldap_directory_access=NONE
[0004]: ldap_directory_sysauth=no
[0004]: os_roles=FALSE
[0004]: max_enabled_roles=150
[0004]: remote_os_authent=FALSE
[0004]: remote_os_roles=FALSE
[0004]: sec_case_sensitive_logon=TRUE
[0004]: O7_DICTIONARY_ACCESSIBILITY=FALSE
[0004]: license_max_users=0
[0004]: audit_sys_operations=FALSE
[0004]: global_names=FALSE
[0004]: distributed_lock_timeout=60
[0004]: commit_point_strength=1
[0004]: global_txn_processes=1
[0004]: instance_name=orcl
[0004]: service_names=orcl.imacs.in
[0004]: shared_servers=1
[0004]: cursor_space_for_time=FALSE
[0004]: session_cached_cursors=50
[0004]: remote_dependencies_mode=TIMESTAMP
[0004]: plsql_v2_compatibility=FALSE
[0004]: plsql_native_library_subdir_count=0
[0004]: plsql_code_type=INTERPRETED
[0004]: plsql_debug=FALSE
[0004]: plsql_optimize_level=2
[0004]: plscope_settings=IDENTIFIERS:NONE
[0004]: java_jit_enabled=TRUE
[0004]: job_queue_processes=1000
[0004]: parallel_min_percent=0
[0004]: create_bitmap_area_size=8388608
[0004]: bitmap_merge_area_size=1048576
[0004]: cursor_sharing=EXACT
[0004]: result_cache_mode=MANUAL
[0004]: parallel_min_servers=0
[0004]: parallel_max_servers=20
[0004]: parallel_execution_message_size=2148
[0004]: hash_area_size=131072
[0004]: result_cache_max_result=5
[0004]: result_cache_remote_expiration=0
[0004]: shadow_core_dump=none
[0004]: background_core_dump=partial
[0004]: object_cache_optimal_size=102400
[0004]: object_cache_max_size_percent=10
[0004]: session_max_open_files=10
[0004]: open_links=4
[0004]: open_links_per_instance=4
[0004]: optimizer_features_enable=11.1.0.6
[0004]: sort_area_size=65536
[0004]: sort_area_retained_size=0
[0004]: db_unique_name=orcl
[0004]: sql_trace=FALSE
[0004]: os_authent_prefix=OPS$
[0004]: sql92_security=FALSE
[0004]: blank_trimming=FALSE
[0004]: star_transformation_enabled=FALSE
[0004]: parallel_adaptive_multi_user=TRUE
[0004]: parallel_threads_per_cpu=2
[0004]: parallel_automatic_tuning=FALSE
[0004]: parallel_io_cap_enabled=FALSE
[0004]: optimizer_index_cost_adj=100
[0004]: optimizer_index_caching=0
[0004]: query_rewrite_integrity=enforced
[0004]: sql_version=NATIVE
[0004]: pga_aggregate_target=0
[0004]: workarea_size_policy=AUTO
[0004]: statistics_level=TYPICAL
[0004]: optimizer_secure_view_merging=TRUE
[0004]: ddl_lock_timeout=0
[0004]: optimizer_use_pending_statistics=FALSE
[0004]: optimizer_capture_sql_plan_baselines=FALSE
[0004]: optimizer_use_sql_plan_baselines=TRUE
[0004]: optimizer_use_invisible_indexes=FALSE
[0004]: sec_protocol_error_trace_action=TRACE
[0004]: sec_protocol_error_further_action=CONTINUE
[0004]: sec_max_failed_login_attempts=10
[0004]: sec_return_server_release_banner=FALSE
[0004]: enable_ddl_logging=FALSE
[0004]: client_result_cache_size=0
[0004]: client_result_cache_lag=3000
[0004]: aq_tm_processes=0
[0004]: hs_autoregister=TRUE
[0004]: xml_db_events=enable
[0004]: dg_broker_start=FALSE
[0004]: drs_start=FALSE
[0004]: dg_broker_config_file1=C:\ORA11G\PRODUCT\11.1.0\DB_1\DATABASE
\DR1ORCL.DAT
[0004]: dg_broker_config_file2=C:\ORA11G\PRODUCT\11.1.0\DB_1\DATABASE
\DR2ORCL.DAT
[0004]: olap_page_pool_size=0
[0004]: asm_power_limit=1
[0004]: control_management_pack_access=DIAGNOSTIC+TUNING
[0004]: sqltune_category=DEFAULT
[0004]: max_dump_file_size=unlimited
[0004]: trace_enabled=TRUE
========= End of General Configuration ========
----- (Action duration in csec: 506) -----
----- DDE Action: 'kdlut_bucketdump_action' (Sync) -----
----- (Action duration in csec: 11) -----
----- DDE Action: 'dumpKernelDiagState' (Sync) -----
------- Kernel Diag Dump -------
dbkcBSExt: 0
Bootstrapping info:
Flags: 0x7
Options: 0x806
Diag Dest: c:\ora11g
DB Unique name: orcl
Instance Name: orcl
dbkedDefDump info:
Internal err count: 0
Error Flags: 0x0
Exception: FALSE
------- END Kernel Diag Dump -------
----- (Action duration in csec: 0) -----
----- DDE Action: 'xdb_dump_buckets' (Sync) -----
----- (Action duration in csec: 0) -----
----- DDE Action: 'kpuActionDefault' (Sync) -----
Begin OCI Current State Dump
End OCI Current State Dump

Begin OCI Call Context Dump
End OCI Call Context Dump


*** 2008-09-16 10:24:57.212
----- (Action duration in csec: 47) -----
----- END DDE Actions Dump -----

*** 2008-09-16 10:24:58.668
End of Incident Dump

> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

[manoj]

Dear Sir

I am sending you the portion of my alert log file

Wed Nov 05 16:42:54 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as C:\ora11G\product
\11.1.0\db_1\RDBMS
Using LOG_ARCHIVE_DEST_10 parameter default value as
USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Wed Nov 05 16:43:09 2008
Starting up ORACLE RDBMS Version: 11.1.0.6.0.
Using parameter settings in server-side spfile C:\ORA11G\PRODUCT
\11.1.0\DB_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
processes = 150
memory_target = 300M
control_files = "C:\ORA11G\ORADATA\ORCL\CONTROL01.CTL"
control_files = "C:\ORA11G\ORADATA\ORCL\CONTROL02.CTL"
control_files = "C:\ORA11G\ORADATA\ORCL\CONTROL03.CTL"
db_block_size = 8192
compatible = "11.1.0.0.0"
db_recovery_file_dest = "C:\ora11G\flash_recovery_area"
db_recovery_file_dest_size= 2G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = "imacs.in"
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
audit_file_dest = "C:\ORA11G\ADMIN\ORCL\ADUMP"
audit_trail = "DB"
db_name = "orcl"
open_cursors = 300
diagnostic_dest = "C:\ORA11G"
Wed Nov 05 16:43:13 2008
PMON started with pid=2, OS id=2188
Wed Nov 05 16:43:13 2008
VKTM started with pid=3, OS id=3092 at elevated priority
Wed Nov 05 16:43:13 2008
MMAN started with pid=9, OS id=604
Wed Nov 05 16:43:15 2008
DBW0 started with pid=10, OS id=3832
Wed Nov 05 16:43:15 2008
LGWR started with pid=11, OS id=3904
Wed Nov 05 16:43:15 2008
CKPT started with pid=12, OS id=2388
Wed Nov 05 16:43:15 2008
SMON started with pid=13, OS id=3608
Wed Nov 05 16:43:15 2008
RECO started with pid=14, OS id=3512
Wed Nov 05 16:43:15 2008
MMON started with pid=15, OS id=2948
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)
(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Nov 05 16:43:13 2008
DIAG started with pid=4, OS id=3572
Wed Nov 05 16:43:13 2008
DIA0 started with pid=8, OS id=4028
Wed Nov 05 16:43:13 2008
DSKM started with pid=7, OS id=996
VKTM running at (20)ms precision
Wed Nov 05 16:43:15 2008
MMNL started with pid=16, OS id=2084
ORACLE_BASE from environment = C:\ora11G
Wed Nov 05 16:43:13 2008
PSP0 started with pid=6, OS id=2112
Wed Nov 05 16:43:13 2008
DBRM started with pid=5, OS id=2500
Wed Nov 05 16:43:24 2008
alter database mount exclusive
Setting recovery target incarnation to 2
Wed Nov 05 16:43:32 2008
Successful mount of redo thread 1, with mount id 1197776044
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Wed Nov 05 16:43:34 2008
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Started redo scan
Completed redo scan
20 redo blocks read, 25 data blocks need recovery
Started redo application at
Thread 1: logseq 39, block 53609
Recovery of Online Redo Log: Thread 1 Group 3 Seq 39 Reading mem 0
Mem# 0: C:\ORA11G\ORADATA\ORCL\REDO03.LOG
Completed redo application
Wed Nov 05 16:43:46 2008
Completed crash recovery at
Thread 1: logseq 39, block 53629, scn 1417356
25 data blocks read, 25 data blocks written, 20 redo blocks read
Wed Nov 05 16:43:57 2008
Thread 1 advanced to log sequence 40
Thread 1 opened at log sequence 40
Current log# 1 seq# 40 mem# 0: C:\ORA11G\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1
Wed Nov 05 16:43:59 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Nov 05 16:43:59 2008
SMON: enabling cache recovery
Wed Nov 05 16:44:32 2008
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption
completed
Wed Nov 05 16:44:35 2008
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
Opening with internal Resource Manager plan
Wed Nov 05 16:44:50 2008
Starting background process FBDA
Wed Nov 05 16:44:51 2008
FBDA started with pid=21, OS id=3732
Starting background process SMCO
Wed Nov 05 16:44:51 2008
SMCO started with pid=22, OS id=1372
replication_dependency_tracking turned off (no async multimaster
replication found)
Wed Nov 05 16:45:08 2008
Starting background process QMNC
Wed Nov 05 16:45:08 2008
QMNC started with pid=24, OS id=4036
Wed Nov 05 16:46:42 2008
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount
of
space available in the underlying filesystem or ASM diskgroup.
Wed Nov 05 16:49:54 2008
Completed: alter database open
Wed Nov 05 16:51:02 2008


***********************************************************************

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
11.1.0.6.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version
11.1.0.6.0 - Production
Time: 05-NOV-2008 16:51:07
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: <unknown>
ORA-609 : opiodr aborting process unknown ospid (2164_2504)
Wed Nov 05 16:53:34 2008
Starting background process CJQ0
Wed Nov 05 16:53:34 2008
CJQ0 started with pid=33, OS id=2988
Wed Nov 05 17:15:17 2008


***********************************************************************

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
11.1.0.6.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version
11.1.0.6.0 - Production
Time: 05-NOV-2008 17:15:28
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.191.172)
(PORT=2544))
WARNING: inbound connection timed out (ORA-3136)
Wed Nov 05 17:28:01 2008
Thread 1 advanced to log sequence 41
Current log# 2 seq# 41 mem# 0: C:\ORA11G\ORADATA\ORCL\REDO02.LOG
Wed Nov 05 17:28:06 2008
Stopping background process SMCO


Please help to resolve the below issue

Regards
Thakur Manoj

On Nov 6, 6:17 pm, ddf <orat...@msn.com> wrote:

[ddf]

> > - Show quoted text -- Hide quoted text -

>
> - Show quoted text -

There is, apparently, nothing to resolve.


David Fitzjarrell

[manoj]

Dear Sir

So I should find that Oracle 11G software is safe?

Regards

[ddf]

> ...
>
> read more »- Hide quoted text -

>
> - Show quoted text -

Presuming it's been correctly installed. According to your posts I
would expect that your installation has not been properly completed.


David Fitzjarrell

[yaw]

Manoj,

You seem like a nice guy. One advice though, try and exhaust all other avenues like google with your questions before you post here.  Otherwise you'd be asking for you.

orainst/root.sh should have your root script.

cheers,
yaw

[ben]

Very funny !

> > > > > adrci> exit- Hide quoted text -
>
> - Show quoted text -...
>
> read more »