오라클 11g R2 diag collection 로그수집 가이드

2020. 7. 24. 15:42 내맘대로긍정

프린트 하기

OS환경 : Oracle Linux 6.8 (64bit)

DB 환경 : Oracle Database 11.2.0.4

방법 : 오라클 11g R2 diag collection 로그수집 가이드

DB에 문제가 발생했을때 로그를 수집해서 SR에 업로드 해야함

그 방법을 설명함

AHF(TFA) 파일을 다운받아 서버에 올려서 로그수집하기 어려운 경우(https://positivemh.tistory.com/607)

$GRID_HOME에 있는 diagcollection.sh 파일을 이용해 로그를 수집할 수 있음

RAC인 경우 양쪽노드에서 각각 수집해줘야함

로그 저장용 임시 폴더 생성

# mkdir -p log
# cd log
# pwd
/root/log

해당 폴더에서 로그수집쉘(diagcollection.sh) 실행

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
# /oracle/grid/product/11.2.0/grid/bin/diagcollection.sh
Production Copyright 2004, 2010, Oracle.  All rights reserved
Cluster Ready Services (CRS) diagnostic collection tool
The following CRS diagnostic archives will be created in the local directory.
crsData_orcl01_20200724_2359.tar.gz -> logs,traces and cores from CRS home. Note: core files will be packaged only with the --core option. 
ocrData_orcl01_20200724_2359.tar.gz -> ocrdump, ocrcheck etc 
coreData_orcl01_20200724_2359.tar.gz -> contents of CRS core files in text format
 
osData_orcl01_20200724_2359.tar.gz -> logs from Operating System
lsInventory_orcl01_20200724_2359 ->Opatch lsinventory details
Collecting crs data
Collecting OCR data 
Collecting information from core files
No corefiles found 
Collecting lsinventory details
Collecting OS logs
Collecting sysconfig data

수집된 로그 파일 확인

1
2
3
4
5
6
7
8
9
# ls -al
total 14104
drwxr-xr-x   2 root root     4096 Jul 24 23:59 .
dr-xr-x---. 18 root root     4096 Jul 24 23:58 ..
-rw-r--r--   1 root root 13954636 Jul 24 23:59 crsData_orcl01_20200724_2359.tar.gz
-rw-r--r--   1 root root     1080 Jul 24 23:59 lsInventory_orcl01_20200724_2359
-rw-r--r--   1 root root    25188 Jul 24 23:59 ocrData_orcl01_20200724_2359.tar.gz
-rw-r--r--   1 root root   419913 Jul 24 23:59 osData_orcl01_20200724_2359.tar.gz
-rw-r--r--   1 root root    24375 Jul 24 23:59 sysconfig_orcl01_20200724_2359.txt

각각 파일 확인

lsInventory_orcl01 파일

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
# cat lsInventory_orcl01_20200724_2359
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.
 
 
Oracle Home       : /oracle/grid/product/11.2.0/grid
Central Inventory : /oracle/app/oraInventory
   from           : /oracle/grid/product/11.2.0/grid/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.4.0
Log file location : /oracle/grid/product/11.2.0/grid/cfgtoollogs/opatch/opatch2020-07-24_23-59-20PM_1.log
 
Lsinventory Output file location : /oracle/grid/product/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2020-07-24_23-59-20PM.txt
 
--------------------------------------------------------------------------------
Installed Top-level Products (1): 
 
Oracle Grid Infrastructure 11g                                       11.2.0.4.0
There are 1 products installed in this Oracle Home.
 
 
There are no Interim patches installed in this Oracle Home.
 
 
Rac system comprising of multiple nodes
  Local node = orcl01
  Remote node = orcl02
 
--------------------------------------------------------------------------------
 
OPatch succeeded.

GRID_HOME에 대한 lsinventory 내역을 수집함

sysconfig_orcl01 파일 확인

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
# cat sysconfig_orcl01_20200724_2359.txt 
/bin/uname -a
(결과 생략)
=============================================
/bin/cat /proc/cpuinfo
(결과 생략)
=============================================
/bin/cat /proc/meminfo
(결과 생략)
=============================================
/sbin/ifconfig -a
(결과 생략)
=============================================
/sbin/fdisk -l
(결과 생략)
=============================================
/bin/mount
(결과 생략)
=============================================
/bin/cat /proc/slabinfo
(결과 생략)

os 정보, cpu, 메모리, 네트워크, 디스크 등에 대한 정보를 수집함

osData_orcl01 파일 확인

압축 해제

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
# tar -xvf osData_orcl01_20200724_2359.tar.gz 
var/log/messages
var/log/messages-20200628
var/log/messages-20200705
var/log/messages-20200712
var/log/messages-20200719
# cd var/log
# ls -al
total 6324
drwxr-xr-x 2 root root     122 Jul 25 00:13 .
drwxr-xr-x 3 root root      17 Jul 25 00:13 ..
-rw------- 1 root root  340041 Jul 24 23:59 messages
-rw------- 1 root root  946717 Jun 28 03:28 messages-20200628
-rw------- 1 root root 1726779 Jul  5 03:45 messages-20200705
-rw------- 1 root root 1722062 Jul 12 03:34 messages-20200712
-rw------- 1 root root 1728200 Jul 19 03:27 messages-20200719

OS에 있는 /var/log/message* 파일들을 수집함

1
2
3
4
5
6
# ls -al /var/log/me*
-rw------- 1 root root  340580 Jul 25 00:10 /var/log/messages
-rw------- 1 root root  946717 Jun 28 03:28 /var/log/messages-20200628
-rw------- 1 root root 1726779 Jul  5 03:45 /var/log/messages-20200705
-rw------- 1 root root 1722062 Jul 12 03:34 /var/log/messages-20200712
-rw------- 1 root root 1728200 Jul 19 03:27 /var/log/messages-20200719

ocrData_orcl01 파일 확인

압축 해제

1
2
3
4
5
# tar -xvf ocrData_orcl01_20200724_2359.tar.gz 
orcl01_OCRDUMP
orcl01_OLRDUMP
orcl01_OCRCHECK
orcl01_OCRBACKUP

orcl01_OLRDUMP, orcl01_OCRDUMP 파일 확인

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
# head orcl01_OLRDUMP 
07/24/2020 23:59:15
/oracle/grid/product/11.2.0/grid/bin/ocrdump.bin -local orcl01_OLRDUMP 
[SYSTEM]
UNDEF : 
SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root}
[SYSTEM.crs]
UNDEF : 
SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root}
 
# head orcl01_OCRDUMP 
07/24/2020 23:59:14
/oracle/grid/product/11.2.0/grid/bin/ocrdump.bin orcl01_OCRDUMP 
[SYSTEM]
UNDEF : 
SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root}
[SYSTEM.version]
UB4 (10) : 5
SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root}

OCR, OLR(Oracle Local Registry)에 대한 DUMP를 수집함

orcl01_OCRBACKUP, orcl01_OCRCHECK 파일 확인

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
# cat orcl01_OCRBACKUP 
 
orcl01     2020/07/24 22:58:18     /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/backup00.ocr
 
orcl01     2020/07/24 18:58:17     /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/backup01.ocr
 
orcl01     2020/07/24 14:58:17     /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/backup02.ocr
 
orcl01     2020/07/23 02:58:15     /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/day.ocr
 
orcl01     2020/07/20 02:58:11     /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available
 
# cat orcl01_OCRCHECK 
Status of Oracle Cluster Registry is as follows :
     Version                  :          3
     Total space (kbytes)     :     262120
     Used space (kbytes)      :       2952
     Available space (kbytes) :     259168
     ID                       : 1797319969
     Device/File Name         :  +OCR_VOTE
                                    Device/File integrity check succeeded
 
                                    Device/File not configured
 
                                    Device/File not configured
 
                                    Device/File not configured
 
                                    Device/File not configured
 
     Cluster registry integrity check succeeded
 
     Logical corruption check succeeded

ocrconfig -showbackup 정보와 ocrcheck 정보를 저장하고 있음

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
# ocrconfig -showbackup
 
orcl01     2020/07/24 22:58:18     /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/backup00.ocr
 
orcl01     2020/07/24 18:58:17     /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/backup01.ocr
 
orcl01     2020/07/24 14:58:17     /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/backup02.ocr
 
orcl01     2020/07/23 02:58:15     /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/day.ocr
 
orcl01     2020/07/20 02:58:11     /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available
 
# ocrcheck
Status of Oracle Cluster Registry is as follows :
     Version                  :          3
     Total space (kbytes)     :     262120
     Used space (kbytes)      :       2952
     Available space (kbytes) :     259168
     ID                       : 1797319969
     Device/File Name         :  +OCR_VOTE
                                    Device/File integrity check succeeded
 
                                    Device/File not configured
 
                                    Device/File not configured
 
                                    Device/File not configured
 
                                    Device/File not configured
 
     Cluster registry integrity check succeeded
 
     Logical corruption check succeeded

crsData_orcl01 파일확인

압축 해제

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
# tar -xvf crsData_orcl01_20200724_2359.tar.gz 
install/make.log
install/root_orcl01_2020-07-19_22-36-41.log
log/orcl01/alertorcl01.log  <- grid alert log
log/orcl01/crsd/crsdOUT.log
log/orcl01/crsd/crsd.log
log/orcl01/ctssd/ctssdOUT.log
log/orcl01/ctssd/octssd.l02
log/orcl01/ctssd/octssd.l01
log/orcl01/ctssd/octssd.log
log/orcl01/evmd/evmdOUT.log
log/orcl01/evmd/evmd.log
log/orcl01/cssd/cssdOUT.log
log/orcl01/cssd/ocssd.log
log/orcl01/mdnsd/mdnsdOUT.log
log/orcl01/mdnsd/mdnsd.log
log/orcl01/gpnpd/gpnpdOUT.log
log/orcl01/gpnpd/gpnpd.log
log/orcl01/gpnpd/orcl01.pid
log/orcl01/gipcd/gipcdOUT.log
log/orcl01/gipcd/gipcd.l10
log/orcl01/gipcd/gipcd.l09
log/orcl01/gipcd/gipcd.l08
log/orcl01/gipcd/gipcd.l07
log/orcl01/gipcd/gipcd.l06
log/orcl01/gipcd/gipcd.l05
log/orcl01/gipcd/gipcd.l04
log/orcl01/gipcd/gipcd.l03
log/orcl01/gipcd/gipcd.l02
log/orcl01/gipcd/gipcd.l01
log/orcl01/gipcd/gipcd.log
log/orcl01/cvu/cvulog/cvu20200724224430.log
log/orcl01/cvu/cvutrc/cvutrace.log.0
log/orcl01/cvu/cvutrc/cvuhelper.log.0
log/orcl01/cvu/cvutrc/cvutrace.log.1
log/orcl01/ohasd/ohasdOUT.log
log/orcl01/ohasd/ohasd.l02
log/orcl01/ohasd/ohasd.l01
log/orcl01/ohasd/ohasd.log
log/orcl01/agent/crsd/oraagent_oracle/oraagent_oracle.pid
log/orcl01/agent/crsd/oraagent_oracle/oraagent_oracle.l01
log/orcl01/agent/crsd/oraagent_oracle/oraagent_oracle.log
log/orcl01/agent/crsd/orarootagent_root/orarootagent_root.log
log/orcl01/agent/crsd/orarootagent_root/orarootagent_root.pid
log/orcl01/agent/crsd/scriptagent_oracle/scriptagent_oracleOUT.log
log/orcl01/agent/crsd/scriptagent_oracle/scriptagent_oracle.log
log/orcl01/agent/ohasd/oraagent_oracle/oraagent_oracle.log
log/orcl01/agent/ohasd/oraagent_oracle/oraagent_oracle.pid
log/orcl01/agent/ohasd/oraagent_oracle/oraagent_oracleOUT.log
log/orcl01/agent/ohasd/oracssdmonitor_root/oracssdmonitor_root.log
log/orcl01/agent/ohasd/oracssdagent_root/oracssdagent_root.log
log/orcl01/agent/ohasd/orarootagent_root/orarootagent_root.pid
log/orcl01/agent/ohasd/orarootagent_root/orarootagent_rootOUT.log
log/orcl01/agent/ohasd/orarootagent_root/orarootagent_root.l01
log/orcl01/agent/ohasd/orarootagent_root/orarootagent_root.log
log/orcl01/client/olsnodes.log
log/orcl01/client/oifcfg.log
log/orcl01/client/ocrconfig_19764.log
log/orcl01/client/clscfg.log
log/orcl01/client/gpnptool_20212.log
log/orcl01/client/gpnptool_20218.log
log/orcl01/client/crsctl_root.log
log/orcl01/client/crswrapexece.log
log/orcl01/client/gpnp_20994.log
log/orcl01/client/ocrcheck_21149.log
log/orcl01/client/ocrconfig_21162.log
log/orcl01/client/clscfg1.log
log/orcl01/client/gpnptool_21648.log
log/orcl01/client/css.log
log/orcl01/client/clsc.log
log/orcl01/client/css1.log
log/orcl01/client/clsc1.log
log/orcl01/client/crsctl_oracle.log
log/orcl01/client/ocr_22667_7.log
log/orcl01/client/clsc2.log
log/orcl01/client/ocrconfig_23192.log
log/orcl01/client/clsc3.log
log/orcl01/client/ocrcheck_26330.log
log/orcl01/client/ocrcheck_26992.log
log/orcl01/client/clsc4.log
log/orcl01/client/ocrdump_30718.log
log/orcl01/client/ocrdump_30721.log
log/orcl01/client/ocrcheck_30725.log
log/orcl01/client/ocrconfig_30738.log
log/orcl01/crfmond/crfmondOUT.log
log/orcl01/crfmond/crfmond.log
log/orcl01/crflogd/crflogdOUT.log
log/orcl01/crflogd/crflogd.log
cfgtoollogs/oracle.assistants.asm_2020-07-19_10-54-33-PM.log
cfgtoollogs/oracle.crs_2020-07-19_10-54-33-PM.log
cfgtoollogs/oracle.assistants.netca.client_2020-07-19_10-54-33-PM.log
cfgtoollogs/OuiConfigVariables_2020-07-19_10-54-33-PM.log
cfgtoollogs/CfmLogger_2020-07-19_10-54-33-PM.log
cfgtoollogs/configToolAllCommands
cfgtoollogs/configToolAllCommands.bak
cfgtoollogs/configToolFailedCommands
cfgtoollogs/configToolFailedCommands.bak
cfgtoollogs/cfgfw/CfmLogger_2020-07-19_10-34-19-PM.log
cfgtoollogs/cfgfw/oracle.crs_2020-07-19_10-34-19-PM.log
cfgtoollogs/cfgfw/oracle.assistants.netca.client_2020-07-19_10-34-19-PM.log
cfgtoollogs/cfgfw/OuiConfigVariables_2020-07-19_10-34-19-PM.log
cfgtoollogs/cfgfw/oracle.assistants.asm_2020-07-19_10-34-20-PM.log
cfgtoollogs/cfgfw/CfmLogger_2020-07-19_10-54-32-PM.log
cfgtoollogs/cfgfw/oracle.crs_2020-07-19_10-54-33-PM.log
cfgtoollogs/cfgfw/oracle.assistants.netca.client_2020-07-19_10-54-33-PM.log
cfgtoollogs/cfgfw/OuiConfigVariables_2020-07-19_10-54-33-PM.log
cfgtoollogs/cfgfw/oracle.assistants.asm_2020-07-19_10-54-33-PM.log
cfgtoollogs/crsconfig/rootcrs_orcl01.log
cfgtoollogs/crsconfig/srvmcfg0.log
cfgtoollogs/crsconfig/srvmcfg1.log
cfgtoollogs/crsconfig/srvmcfg2.log
cfgtoollogs/crsconfig/srvmcfg3.log
cfgtoollogs/crsconfig/srvmcfg4.log
cfgtoollogs/crsconfig/srvmcfg5.log
cfgtoollogs/crsconfig/srvmcfg6.log
cfgtoollogs/crsconfig/srvmcfg7.log
cfgtoollogs/crsconfig/srvmcfg8.log
cfgtoollogs/oui/UpdateNodeList2020-07-19_10-54-33PM.log
cfgtoollogs/oui/oraInstall2020-07-19_10-54-33PM.out
cfgtoollogs/oui/oraInstall2020-07-19_10-54-33PM.err
cfgtoollogs/oui/oraInstall2020-07-19_10-54-33PM.err.orcl02
cfgtoollogs/oui/oraInstall2020-07-19_10-54-33PM.out.orcl02
cfgtoollogs/oui/UpdateNodeList2020-07-19_10-54-33PM.log.orcl02
cfgtoollogs/oui/installActions2020-07-19_10-12-09PM.log
cfgtoollogs/oui/time2020-07-19_10-12-09PM.log
cfgtoollogs/oui/oraInstall2020-07-19_10-12-09PM.out
cfgtoollogs/oui/oraInstall2020-07-19_10-12-09PM.err
cfgtoollogs/oui/silentInstall2020-07-19_10-12-09PM.log
cfgtoollogs/oui/oraInstall2020-07-19_10-12-09PM.err.orcl02
cfgtoollogs/oui/oraInstall2020-07-19_10-12-09PM.out.orcl02
cfgtoollogs/oui/AttachHome2020-07-19_10-12-09PM.log.orcl02
cfgtoollogs/opatch/opatch_history.txt
cfgtoollogs/opatch/opatch2020-07-24_23-42-10PM_1.log
cfgtoollogs/opatch/lsinv/lsinventory2020-07-24_23-42-10PM.txt
oc4j/j2ee/home/log/oc4j_stdout_err.log
oc4j/j2ee/home/log/oc4j_2020_07_19_22_44_04.out
oc4j/j2ee/home/log/oc4j_2020_07_19_22_44_04.err
oc4j/j2ee/home/log/server.log
oc4j/j2ee/home/log/system-application.log
oc4j/j2ee/home/log/global-application.log
oc4j/j2ee/home/log/dbwlm.log
oc4j/j2ee/home/log/rmi.log
oc4j/j2ee/home/log/jms.log
oc4j/j2ee/home/log/oc4j_shutter_stdout_err.log
oc4j/j2ee/home/log/oc4j/log.xml
oc4j/j2ee/home/log/wsmgmt/auditing/log.xml
oc4j/j2ee/home/log/wsmgmt/logging/log.xml
oc4j/j2ee/home/log/dbwlm/auditing/log.xml
oc4j/j2ee/home/log/dbwlm/logging/log.xml

crs 로그들이 저장되어 있음

diagcollection.sh 쉘로는 grid관련 로그(grid alert log 등)들만 수집이됨

db alert log나 ASM alert log는 수집되지 않음

해당 로그는 수동으로 수집해줘야함

1
2
3
4
5
6
7
$ cd /oracle/app/oracle/diag/asm/+asm/+ASM1/trace
$ ls -al al*
-rw-r----- 1 oracle dba 30903 Jul 25 00:18 alert_+ASM1.log
 
$ cd /oracle/app/oracle/diag/rdbms/orcl/ORCL01/trace/
$ ls -al al*
-rw-r----- 1 oracle dba 38733 Jul 24 22:00 alert_ORCL1.log

추가로 OPatch 상세 정보도 수집

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
$ $ORACLE_HOME/OPatch/opatch lsinventory -detail
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.
 
 
Oracle Home       : /oracle/app/oracle/product/11.2.0/db_1
Central Inventory : /oracle/app/oraInventory
   from           : /oracle/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.4.0
Log file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-07-25_00-48-08AM_1.log
 
Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-07-25_00-48-08AM.txt
 
--------------------------------------------------------------------------------
Installed Top-level Products (1): 
 
Oracle Database 11g                                                  11.2.0.4.0
There are 1 products installed in this Oracle Home.
 
 
Installed Products (136): 
 
Agent Required Support Files                                         10.2.0.4.5
Assistant Common Files                                               11.2.0.4.0
Bali Share                                                           1.1.18.0.0
Buildtools Common Files                                              11.2.0.4.0
Character Set Migration Utility                                      11.2.0.4.0
Cluster Verification Utility Common Files                            11.2.0.4.0
Database Configuration and Upgrade Assistants                        11.2.0.4.0
Database SQL Scripts                                                 11.2.0.4.0
..(생략)
 
$ $GRID_HOME/OPatch/opatch lsinventory -detail
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.
 
 
Oracle Home       : /oracle/app/oracle/product/11.2.0/db_1
Central Inventory : /oracle/app/oraInventory
   from           : /oracle/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.4.0
Log file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-07-25_00-48-45AM_1.log
 
Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-07-25_00-48-45AM.txt
 
--------------------------------------------------------------------------------
Installed Top-level Products (1): 
 
Oracle Database 11g                                                  11.2.0.4.0
There are 1 products installed in this Oracle Home.
 
 
Installed Products (136): 
 
Agent Required Support Files                                         10.2.0.4.5
Assistant Common Files                                               11.2.0.4.0
Bali Share                                                           1.1.18.0.0
Buildtools Common Files                                              11.2.0.4.0
Character Set Migration Utility                                      11.2.0.4.0
Cluster Verification Utility Common Files                            11.2.0.4.0
Database Configuration and Upgrade Assistants                        11.2.0.4.0
..(생략)

참조 : https://positivemh.tistory.com/607

https://positivemh.tistory.com/483

https://positivemh.tistory.com/301

https://positivemh.tistory.com/544

https://positivemh.tistory.com/645

https://positivemh.tistory.com/647

https://positivemh.tistory.com/631

저작자표시

'ORACLE > Admin' 카테고리의 다른 글

오라클 일반 테이블과 blob 테이블 생성, 데이터 삭제 후 datapump 테스트 (0)	2020.08.01
오라클 11g 새로운 Job (0)	2020.07.27
Windows Server 2016 서버 정상종료 시 oracle shutdown 프로세스 (0)	2020.07.15
오라클 11g R2 컴포넌트 설명 (0)	2020.07.15
오라클 bdump 경로에 생기는 sbtio.log 파일 (0)	2020.07.10

내맘대로긍정

OracleDBA@kakao.com

Category

Menu

Comment

Link