오라클 SR 처리를 위해
아래와 같은 정보를 수집하면 편하다...
ulimit -a : 메모리 정보
uname -a : OS 정보
adrci : 문제가 발생한 내역 압축하기 (ips 명령 사용)
opatch : 현재 패치 내역 조회하기
testdb01:/oracle_test] ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 2000000
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) 4194303
testdb01:/oracle_test] uname -a
HP-UX testdb01 B.11.23 U ia64 1770507378 unlimited-user license
testdb01:/tmp] adrci
ADRCI: Release 11.1.0.7.0 - Production on Sat Jan 13 09:25:50 2018
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ADR base = "/oralog_test/dblog"
adrci> show problem
ADR Home = /oralog_test/dblog/diag/rdbms/testdb/testdb1:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
14 ORA 600 [kjuscv] 1630464 2018-01-12 22:36:29.336735 +09:00
13 ORA 600 [kjucvl:!busy] 1630463 2018-01-12 22:36:25.059486 +09:00
14 rows fetched
adrci> show incident
ADR Home = /oralog_test/dblog/diag/rdbms/testdb/testdb1:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
1630464 ORA 600 [kjuscv] 2018-01-12 22:36:29.336735 +09:00
1630463 ORA 600 [kjucvl:!busy] 2018-01-12 22:36:25.059486 +09:00
50 rows fetched
adrci> ips pack problem 13 in /tmp
Generated package 9 in file /tmp/ORA600kju_20180113092623_COM_1.zip, mode complete
adrci> ips pack problem 14 in /tmp
Generated package 10 in file /tmp/ORA600kju_20180113092815_COM_1.zip, mode complete
adrci> ips pack incident 1630464 in /tmp
Generated package 11 in file /tmp/ORA600kju_20180113092948_COM_1.zip, mode complete
adrci> ips pack incident 1630463 in /tmp
Generated package 12 in file /tmp/ORA600kju_20180113093112_COM_1.zip, mode complete
opatch lsinventory
'Database > ORACLE' 카테고리의 다른 글
| 오라클 수평 출력 print_table 기능 (0) | 2018.02.04 |
|---|---|
| ora-00257 archiver error. connect internal only until freed (0) | 2018.01.08 |
| expdp failed with ORA-31641: unable to create dump file ORA-27054: NFS file system where the file is created or resides is not mounted with correct options (0) | 2018.01.08 |
| impdp - ORA-31640 ORA-31693 ORA-19505 ORA-27037 (0) | 2018.01.08 |
| PCTFREE,PCTUSED,FREELIST (0) | 2018.01.05 |