THIS DOCUMENT WILL HELP YOU TO Create a package for incident ...
This will help beginners to RAISE ORACLE SR
This will help beginners to RAISE ORACLE SR
[oracle@tnc61 ~]$ . oraenv
ORACLE_SID = [oval007p] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@tnc61 ~]$ adrci
ADRCI: Release 12.1.0.1.0 - Production on Thu Mar 26 21:41:27 2015
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci>
adrci> show homepath
ADR Homes:
diag/clients/user_oracle/host_8426384_80
diag/tnslsnr/tnc61/oval007p
diag/tnslsnr/tnc61/oval009p
diag/rdbms/oval007p/oval007p
diag/rdbms/oval009p/oval009p
adrci> set homepath diag/rdbms/oval007p/oval007p
adrci> show homepath
ADR Homes:
diag/rdbms/oval007p/oval007p
adrci> show alert -term -p "MESSAGE_TEXT like ‘%ORA%’ and ORIGINATING_TIMESTAMP > '2015-03-23 23:11:10.209000 -04:00’”
OR
adrci> show incident -p "problem_key='ORA 4031'"
ADR Home = /u01/app/oracle/diag/rdbms/oval007p/oval007p:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- -----------------------------------------------------------
29217 ORA 4031 2015-03-23 23:11:07.208000 -04:00
29225 ORA 4031 2015-03-23 23:11:10.209000 -04:00
29233 ORA 4031 2015-03-23 23:11:10.524000 -04:00
29169 ORA 4031 2015-03-23 23:11:26.496000 -04:00
29153 ORA 4031 2015-03-23 23:11:26.694000 -04:00
5 rows fetched
WE CAN SEE NUMBER OF INCIDENTS HERE WITH INCIDENT_ID
29217,29225,29233,29169,29153
Package the trace files invoking IPS
adrci> ips pack incident 29217 in /tmp
Generated package 1 in file /tmp/ORA4031_20150326215542_COM_1.zip, mode complete
Upload the ZIP file generated to the Service Request you created on the My Oracle Support website . This file will include all the trace files, instance alert file and other diagnostic information for the critical error. Make sure that the ZIP file is uploaded WITHOUT any post processing (such as TAR).
Oracle in Memory _______
