Monday, August 26, 2013

ADRCI

ADRCI: Release 11.2.0.1.0 - Production on Thu Sep 16 22:57:31 2012

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

ADR base = "/d02/prod/proddb"
adrci> show home 
ADR Homes:
diag/tnslsnr/servername/prod
diag/tnslsnr/servername/prod
diag/rdbms/prod/PROD
adrci> set home diag/rdbms/prod/PROD
adrci> show homepath
ADR Homes:
diag/rdbms/prod/PROD
adrci> set homepath diag/rdbms/prod/PROD

adrci> show problem

ADR Home = /d02/oraprod/spmproddb/diag/
rdbms/prod/PROD:
*************************************************************************
PROBLEM_ID           PROBLEM_KEY                                                 LAST_INCIDENT        LASTINC_TIME                            
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
1                    ORA 600 [kwqmfidliot:ins]                                   700840               2012-09-15 14:14:54.011000 -07:00      
4                    ORA 7445 [kghxcu()+398]                                     678474               2012-09-14 19:31:00.822000 -07:00      
3                    ORA 7445 [kghxal()+362]                                     680282               2012-09-14 19:30:58.879000 -07:00      
2                    ORA 7445 [kwqdlClnupCcoDl()+447]                            681698               2012-09-14 16:56:24.112000 -07:00      
4 rows fetched

adrci> show incident -p "problem_key='ORA 600 [kwqmfidliot:ins]'"

ADR Home = /d02/oraprod/proddb/diag/rdbms/prod/PROD:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME                             
-------------------- ----------------------------------------------------------- ----------------------------------------
502761               ORA 600 [kwqmfidliot:ins]                                   2012-08-10 14:32:15.326000 -07:00      
502729               ORA 600 [kwqmfidliot:ins]                                   2012-08-10 14:33:16.391000 -07:00      
503393               ORA 600 [kwqmfidliot:ins]                                   2012-08-10 14:34:11.457000 -07:00      
502730               ORA 600 [kwqmfidliot:ins]                                   2012-08-10 14:35:11.396000 -07:00      
502809               ORA 600 [kwqmfidliot:ins]                                   2012-08-10 14:36:01.333000 -07:00      
640260               ORA 600 [kwqmfidliot:ins]                                   2012-09-09 15:27:18.007000 -07:00      
640284               ORA 600 [kwqmfidliot:ins]                                   2012-09-09 15:27:56.891000 -07:00      
640276               ORA 600 [kwqmfidliot:ins]                                   2012-09-09 15:28:56.929000 -07:00      
640268               ORA 600 [kwqmfidliot:ins]                                   2012-09-09 15:29:46.975000 -07:00      
641292               ORA 600 [kwqmfidliot:ins]                                   2012-09-09 15:30:42.033000 -07:00      
697885               ORA 600 [kwqmfidliot:ins]                                   2012-09-14 21:00:24.339000 -07:00      
697941               ORA 600 [kwqmfidliot:ins]                                   2012-09-14 22:41:41.969000 -07:00      
697901               ORA 600 [kwqmfidliot:ins]                                   2012-09-14 22:42:29.971000 -07:00      
697909               ORA 600 [kwqmfidliot:ins]                                   2012-09-14 22:43:25.024000 -07:00      
699037               ORA 600 [kwqmfidliot:ins]                                   2012-09-14 22:44:00.575000 -07:00      
698869               ORA 600 [kwqmfidliot:ins]                                   2012-09-14 22:46:35.410000 -07:00      
16 rows fetched


adrci> ips pack incident 698869 in /tmp
Generated package 1 in file /tmp/ORA600kwq_20100916223616_COM_1.zip, mode complete
adrci> exit
cd /tmp
using filezilla get back to windows system
then upload to meatalink

No comments:

Post a Comment

Thank for showing interest in giving comments/feedback/suggestions

Note: Only a member of this blog may post a comment.