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
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/
******************************
PROBLEM_ID PROBLEM_KEY
-------------------- ------------------------------
1 ORA 600 [kwqmfidliot:ins]
4 ORA 7445 [kghxcu()+398]
3 ORA 7445 [kghxal()+362]
2 ORA 7445 [kwqdlClnupCcoDl()+447]
4 rows fetched
adrci> show incident -p "problem_key='ORA 600 [kwqmfidliot:ins]'"
ADR Home = /d02/oraprod/proddb/diag/
******************************
INCIDENT_ID PROBLEM_KEY
-------------------- ------------------------------
502761 ORA 600 [kwqmfidliot:ins]
502729 ORA 600 [kwqmfidliot:ins]
503393 ORA 600 [kwqmfidliot:ins]
502730 ORA 600 [kwqmfidliot:ins]
502809 ORA 600 [kwqmfidliot:ins]
640260 ORA 600 [kwqmfidliot:ins]
640284 ORA 600 [kwqmfidliot:ins]
640276 ORA 600 [kwqmfidliot:ins]
640268 ORA 600 [kwqmfidliot:ins]
641292 ORA 600 [kwqmfidliot:ins]
697885 ORA 600 [kwqmfidliot:ins]
697941 ORA 600 [kwqmfidliot:ins]
697901 ORA 600 [kwqmfidliot:ins]
697909 ORA 600 [kwqmfidliot:ins]
699037 ORA 600 [kwqmfidliot:ins]
698869 ORA 600 [kwqmfidliot:ins]
16 rows fetched
adrci> ips pack incident 698869 in /tmp
Generated package 1 in file /tmp/ORA600kwq_20100916223616_
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.