jump to navigation

DIA-49431: No such incident – Oracle ADRCI – DIA-48447 October 15, 2012

Posted by sendtoshailesh in Uncategorized.
Tags:
trackback

in one of database there was no proper configuration set as per standard of oracle installations and I need to generate the incident for metalink.
As a regular DBA i login to ADCRI prompt and tried it but no success !!

# adrci

ADRCI: Release 11.2.0.3.0 – Production on Mon Oct 15 15:41:06 2012

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

ADR base = “/oracle/product/11.2”
adrci> ips pack incident 412978 in /tmp/dmtds01
DIA-49431: No such incident [412978]

I tried to check if ADR home is set to multiple but that is also was not the case.

adrci> show homes
ADR Homes:
diag/rdbms/dwheu/dwheu
adrci> exit

This proves ADRCI base is not set correctly. now how to know and set it.
Login to DB as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 15 16:33:14 2012

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

Enter user-name: / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter diag

NAME
————————————
TYPE                                         VALUE
——————————————– ——————————
diagnostic_dest
string                                       /oracle/admin/DMTDS01/udump

Then login to ADRCI and create the package

 

ADRCI: Release 11.2.0.3.0 – Production on Mon Oct 15 16:34:16 2012

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

ADR base = “/oracle/product/11.2”
adrci> set base /oracle/admin/DMTDS01/udump
adrci> show base
ADR base is “/oracle/admin/DMTDS01/udump”
adrci> show incident

ADR Home = /oracle/admin/DMTDS01/udump/diag/rdbms/dmtds01/DMTDS01:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME
——————– ———————————————————– —————————————-
167042               ORA 600 [ORA-00600: internal error code, arguments: [qerrmO 2012-02-15 15:12:18.618000 +00:00
167043               ORA 600 [ORA-00600: internal error code, arguments: [ORA-00 2012-02-15 15:12:25.203000 +00:00
167018               ORA 600 [ORA-00600: internal error code, arguments: [qerrmO 2012-02-16 15:12:18.112000 +00:00
167019               ORA 600 [ORA-00600: internal error code, arguments: [ORA-00 2012-02-16 15:12:26.454000 +00:00
166986               ORA 600 [ORA-00600: internal error code, arguments: [qerrmO 2012-02-17 15:12:17.757000 +00:00
166987               ORA 600 [ORA-00600: internal error code, arguments: [ORA-00 2012-02-17 15:12:25.478000 +00:00
173456               ORA 600 [ORA-00600: internal error code, arguments: [qerrmO 2012-02-21 19:08:49.181000 +00:00
173472               ORA 600 [ORA-00600: internal error code, arguments: [qerrmO 2012-02-21 19:09:33.725000 +00:00
173473               ORA 600 [ORA-00600: internal error code, arguments: [qerrmO 2012-02-21 19:10:26.972000 +00:00
173336               ORA 600 [ORA-00600: internal error code, arguments: [qerrmO 2012-02-23 14:06:57.089000 +00:00
173337               ORA 600 [ORA-00600: internal error code, arguments: [qerrmO 2012-02-23 14:12:51.682000 +00:00
173338               ORA 600 [ORA-00600: internal error code, arguments: [qerrmO 2012-02-23 14:29:46.518000 +00:00
230766               ORA 4031                                                    2012-04-11 13:35:18.972000 +00:00
230862               ORA 4031                                                    2012-04-11 13:40:47.155000 +00:00
230870               ORA 4031                                                    2012-04-11 13:54:08.453000 +00:00
230822               ORA 4031                                                    2012-04-11 14:01:26.819000 +00:00
412978               ORA 4031                                                    2012-10-13 20:05:21.940000 +00:00
412979               ORA 4031                                                    2012-10-13 20:05:25.133000 +00:00
412980               ORA 4031                                                    2012-10-13 20:05:27.666000 +00:00
412981               ORA 4031                                                    2012-10-13 20:05:30.074000 +00:00
412982               ORA 4031                                                    2012-10-13 20:05:32.502000 +00:00
419466               ORA 4031                                                    2012-10-13 20:37:44.478000 +00:00
429035               ORA 4031                                                    2012-10-13 20:57:56.448000 +00:00
23 rows fetched

adrci> show homes
ADR Homes:
diag/rdbms/dmtds01/DMTDS01
adrci> show home
ADR Homes:
diag/rdbms/dmtds01/DMTDS01
adrci> ips pack incident 412978 in /tmp/dmtds01
Generated package 1 in file /tmp/dmtds01/ORA4031_20121015163637_COM_1.zip, mode complete

 

 

Advertisements

Comments»

1. sreeni - September 21, 2015

Thank You so much friend


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: