Sběr podkladů pro řešení ticketu s Oracle global supportem

[oracle@dbserver ~]$ . oraenv
ORACLE_SID = [orcl] ? orcl
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@oda1 ~]$ adrci

ADRCI: Release 11.2.0.4.0 - Production on Tue Nov 25 09:31:08 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

ADR base = "/u01/app/oracle"
adrci> set homepath diag/rdbms/orcl/orcl1
adrci> show incident

ADR Home = /u01/app/oracle/diag/rdbms/orcl/orcl1:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
179737 ORA 600 [qcsfbdnp:1] 2014-07-14 12:28:10.289000 +02:00
189156 ORA 25319 2014-11-10 17:23:07.606000 +01:00
192420 ORA 7445 [pfrins()+206] 2014-11-11 08:00:58.266000 +01:00

adrci> ips create package incident 195233
Created package 1 based on incident id 195233, correlation level typical

adrci> ips add incident 195233 package 1
Added incident 195233 to package 1
adrci> ips generate package 1 in /tmp
Generated package 1 in file /tmp/ORA7445pf_20141125094729_COM_1.zip, mode complete

adrci> show incident -mode brief -p "incident_id=195233"

ADR Home = /u01/app/oracle/diag/rdbms/orcl/orcl1:
*************************************************************************

**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
 INCIDENT_ID 195233
 STATUS ready
 CREATE_TIME 2014-11-12 19:02:15.574000 +01:00
 PROBLEM_ID 3
 CLOSE_TIME <NULL>
 FLOOD_CONTROLLED none
 ERROR_FACILITY ORA
 ERROR_NUMBER 7445
 ERROR_ARG1 pfrins()+206
 ERROR_ARG2 SIGSEGV
 ERROR_ARG3 ADDR:0x28
 ERROR_ARG4 PC:0x389F86A
 ERROR_ARG5 Address not mapped to object
 ERROR_ARG6 <NULL>
 ERROR_ARG7 <NULL>
 ERROR_ARG8 <NULL>
 ERROR_ARG9 <NULL>
 ERROR_ARG10 <NULL>
 ERROR_ARG11 <NULL>
 ERROR_ARG12 <NULL>
 SIGNALLING_COMPONENT PLSQL_Code_Execution
 SIGNALLING_SUBCOMPONENT <NULL>
 SUSPECT_COMPONENT <NULL>
 SUSPECT_SUBCOMPONENT <NULL>
 ECID <NULL>
 IMPACTS 0

Komentáře