Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-07445: Message 7445 not found; No message file for product=RDBMS, facility=ORA; arguments: [ksmp

user5476854Oct 12 2017 — edited Oct 13 2017

dear :

  my os version is aix 6100-07-00-0000,oracle database version is Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production,my question is :

when i execute SQL>shutdwon immediate ,then

SQL> shutdown immediate

Database closed.

Database dismounted.

ORA-03113: end-of-file on communication channel

then i find the alert log ,the messages is

<msg time='2017-10-13T09:34:22.433+08:00' org_id='oracle' comp_id='rdbms'

msg_id='1882921322' type='INCIDENT_ERROR' group='Access Violation'

level='1' host_id='ibm' host_addr='101.96.129.59'

prob_key='ORA 7445 [ksmpclrpga()+22672]' upstream_comp='' downstream_comp='KSM'

ecid='' errid='33747' detail_path='/u01/app/oracle/diag/rdbms/prod3/prod3/trace/prod3_ora_13893776.trc'>

<txt>Errors in file /u01/app/oracle/diag/rdbms/prod3/prod3/trace/prod3_ora_13893776.trc  (incident=33747):

ORA-07445: Message 7445 not found; No message file for product=RDBMS, facility=ORA; arguments: [ksmpclrpga()+22672] [SIGSEGV] [ADDR:0x109F04] [PC:0x101E9D690] [Invalid permissions for mapped object]

</txt>

</msg>

<msg time='2017-10-13T09:34:22.499+08:00' org_id='oracle' comp_id='rdbms'

msg_id='dbgexProcessError:1205:3370026720' type='TRACE' level='16'

host_id='ibm' host_addr='101.101.10.10'>

<txt>Incident details in: /u01/app/oracle/diag/rdbms/prod3/prod3/incident/incdir_33747/prod3_ora_13893776_i33747.trc

</txt>

</msg>

<msg time='2017-10-13T09:34:22.517+08:00' org_id='oracle' comp_id='rdbms'

type='UNKNOWN' level='16' host_id='ibm'

host_addr='101.101.10.10' pid='13893776'>

<txt>Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

</txt>

</msg>

then i find the  /u01/app/oracle/diag/rdbms/prod3/prod3/trace/prod3_ora_13893776.trc ,

$ cat /u01/app/oracle/diag/rdbms/prod3/prod3/trace/prod3_ora_13893776.trc

Trace file /u01/app/oracle/diag/rdbms/prod3/prod3/trace/prod3_ora_13893776.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1

System name:    AIX

Node name:      ibm

Release:        1

Version:        6

Machine:        0003545DD600

Instance name: prod3

Redo thread mounted by this instance: 1

Oracle process number: 19

Unix process pid: 13893776, image: oracle@ibm (TNS V1-V3)

*** 2017-10-13 22:03:40.261

*** SESSION ID:(96.3) 2017-10-13 22:03:40.261

*** CLIENT ID:() 2017-10-13 22:03:40.261

*** SERVICE NAME:(SYS$USERS) 2017-10-13 22:03:40.261

*** MODULE NAME:(sqlplus@ibm (TNS V1-V3)) 2017-10-13 22:03:40.261

*** ACTION NAME:() 2017-10-13 22:03:40.261

kwqmnich: current time:: 14:  3: 40: 0

kwqmnich: instance no 0 repartition flag 1

kwqmnich: initialized job cache structure

*** 2017-10-13 09:33:49.942

Stopping background process SMCO

*** 2017-10-13 09:33:52.977

Stopping background process QMNC

*** 2017-10-13 09:33:55.978

Stopping background process MMNL

*** 2017-10-13 09:33:58.979

Stopping background process MMON

ksukia: Starting kill, flags = 1

ksukia: killed 0 out of 0 processes.

*** 2017-10-13 09:34:09.071 4329 krsh.c

ARCH: Archival disabled due to shutdown: 1089

*** 2017-10-13 09:34:10.073 4329 krsh.c

ARCH: Archival disabled due to shutdown: 1089

*** 2017-10-13 09:34:22.248

Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x109F04DD0] [PC:0x101E9D690, ksmpclrpga()+22672] [flags: 0x0, count: 1]

DDE: Flood control is not active

Incident 33747 created, dump file: /u01/app/oracle/diag/rdbms/prod3/prod3/incident/incdir_33747/prod3_ora_13893776_i33747.trc

ORA-07445: Message 7445 not found; No message file for product=RDBMS, facility=ORA; arguments: [ksmpclrpga()+22672] [SIGSEGV] [ADDR:0x109F04] [PC:0x101E9D690] [Invalid permissions for mapped object]

ssexhd: crashing the process...

ksdbgcra: writing core file to directory '/u01/app/oracle/product/11.2.0/dbhome_1/dbs'

$

I really can not find out what is the cause of this problem, please help me, very very grateful, thank you!

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 10 2017
Added on Oct 12 2017
6 comments
1,014 views