error "OPatch cannot find a valid oraInst.loc file to locate Central Inventory

Error tersebut terjadi ketika akan menjalankan command opatch lsinventory untuk mengetahui patch yang sudah terinstall pada database.

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

bash-3.2$ opatch lsinventory
Invoking OPatch 10.2.0.4.2
 
Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation.  ALL rights reserved.
 
 
Oracle Home       : /export/home/users/oracle/product/10.2.0
Central Inventory : n/a
   FROM           : 
OPatch version    : 10.2.0.4.2
OUI version       : 10.2.0.4.0
OUI location      : /export/home/users/oracle/product/10.2.0/oui
Log file location : n/a
 
OPatch cannot find a valid oraInst.loc file TO locate Central Inventory.
 
OPatch failed WITH error code 104

 

Hal ini terjadi karena file oraInst.loc tidak ditemukan di direktori /etc/.

Solusi untuk memperbaikinya yaitu dengan mengcopy file oraInst.loc ke folder /etc atau bisa juga dengan set inventory location file oraInst tersebut

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
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237

bash-3.2$ opatch lsinventory -invPtrLoc /export/home/users/oracle/product/10.2.0/oraInst.loc 
Invoking OPatch 10.2.0.4.2
 
Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation.  ALL rights reserved.
 
 
Oracle Home       : /export/home/users/oracle/product/10.2.0
Central Inventory : /export/home/users/oracle/oraInventory
   FROM           : /export/home/users/oracle/product/10.2.0/oraInst.loc
OPatch version    : 10.2.0.4.2
OUI version       : 10.2.0.4.0
OUI location      : /export/home/users/oracle/product/10.2.0/oui
Log file location : /export/home/users/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2011-11-24_17-14-40PM.log
 
Lsinventory Output file location : /export/home/users/oracle/product/10.2.0/cfgtoollogs/opatch/lsinv/lsinventory2011-11-24_17-14-40PM.txt
 
--------------------------------------------------------------------------------
Installed Top-level Products (2): 
 
Oracle DATABASE 10g                                                  10.2.0.1.0
Oracle DATABASE 10g Release 2 Patch SET 3                            10.2.0.4.0
There are 2 products installed IN this Oracle Home.
 
 
Interim patches (41) :
 
Patch  9442339      : applied ON Tue Jan 18 19:10:20 WIT 2011
   Created ON 18 Mar 2010, 11:29:52 hrs PST8PDT
   Bugs fixed:
     8210889, 8479537, 9442339, 6923450
 
Patch  9442335      : applied ON Tue Jan 18 19:10:14 WIT 2011
   Created ON 18 Mar 2010, 11:29:50 hrs PST8PDT
   Bugs fixed:
     9442335
 
Patch  9442331      : applied ON Tue Jan 18 19:10:12 WIT 2011
   Created ON 18 Mar 2010, 11:29:48 hrs PST8PDT
   Bugs fixed:
     9442331
 
Patch  9442328      : applied ON Tue Jan 18 19:10:09 WIT 2011
   Created ON 18 Mar 2010, 11:29:46 hrs PST8PDT
   Bugs fixed:
     9442328
 
Patch  9352191      : applied ON Tue Jan 18 19:10:06 WIT 2011
   Created ON 18 Mar 2010, 11:29:43 hrs PST8PDT
   Bugs fixed:
     8534387, 8290506, 7375644, 9352191, 7150470, 7592346, 9119226, 8836308
 
Patch  9173253      : applied ON Tue Jan 18 19:10:03 WIT 2011
   Created ON 2 DEC 2009, 22:44:53 hrs PST8PDT
   Bugs fixed:
     9173253
 
Patch  9173248      : applied ON Tue Jan 18 19:10:00 WIT 2011
   Created ON 2 DEC 2009, 22:44:51 hrs PST8PDT
   Bugs fixed:
     9173248
 
Patch  9173244      : applied ON Tue Jan 18 19:09:55 WIT 2011
   Created ON 2 DEC 2009, 22:44:50 hrs PST8PDT
   Bugs fixed:
     9173244
 
Patch  8836686      : applied ON Tue Jan 18 19:09:51 WIT 2011
   Created ON 1 Sep 2009, 10:39:13 hrs PST8PDT
   Bugs fixed:
     8836686
 
Patch  8836684      : applied ON Tue Jan 18 19:09:48 WIT 2011
   Created ON 1 Sep 2009, 10:39:11 hrs PST8PDT
   Bugs fixed:
     8836684
 
Patch  8836683      : applied ON Tue Jan 18 19:09:45 WIT 2011
   Created ON 1 Sep 2009, 10:39:09 hrs PST8PDT
   Bugs fixed:
     8309623, 8836683
 
Patch  8836681      : applied ON Tue Jan 18 19:09:42 WIT 2011
   Created ON 1 Sep 2009, 10:39:07 hrs PST8PDT
   Bugs fixed:
     8836681, 8309587
 
Patch  8836678      : applied ON Tue Jan 18 19:09:37 WIT 2011
   Created ON 1 Sep 2009, 10:39:06 hrs PST8PDT
   Bugs fixed:
     8836678
 
Patch  8836677      : applied ON Tue Jan 18 19:09:34 WIT 2011
   Created ON 11 Sep 2009, 01:14:30 hrs PST8PDT
   Bugs fixed:
     8836677
 
Patch  8836675      : applied ON Tue Jan 18 19:09:30 WIT 2011
   Created ON 1 Sep 2009, 10:39:01 hrs PST8PDT
   Bugs fixed:
     8309637, 8836675
 
Patch  8836671      : applied ON Tue Jan 18 19:09:27 WIT 2011
   Created ON 1 Sep 2009, 10:39:01 hrs PST8PDT
   Bugs fixed:
     8836671
 
Patch  8836667      : applied ON Tue Jan 18 19:09:25 WIT 2011
   Created ON 1 Sep 2009, 10:38:59 hrs PST8PDT
   Bugs fixed:
     8836667
 
Patch  8568405      : applied ON Tue Jan 18 19:09:22 WIT 2011
   Created ON 8 Jun 2009, 20:04:47 hrs PST8PDT
   Bugs fixed:
     8568405
 
Patch  8568404      : applied ON Tue Jan 18 19:09:17 WIT 2011
   Created ON 8 Jun 2009, 20:04:46 hrs PST8PDT
   Bugs fixed:
     8568404
 
Patch  8568402      : applied ON Tue Jan 18 19:09:14 WIT 2011
   Created ON 8 Jun 2009, 20:04:44 hrs PST8PDT
   Bugs fixed:
     6870937, 8568402
 
Patch  8568398      : applied ON Tue Jan 18 19:09:09 WIT 2011
   Created ON 25 Jun 2009, 12:05:00 hrs PST8PDT
   Bugs fixed:
     6392076, 8568398
 
Patch  8568397      : applied ON Tue Jan 18 19:09:01 WIT 2011
   Created ON 8 Jun 2009, 20:04:39 hrs PST8PDT
   Bugs fixed:
     8568397
 
Patch  8568395      : applied ON Tue Jan 18 19:08:58 WIT 2011
   Created ON 8 Jun 2009, 20:04:38 hrs PST8PDT
   Bugs fixed:
     8309639, 8568395
 
Patch  8309642      : applied ON Tue Jan 18 19:08:55 WIT 2011
   Created ON 24 Mar 2009, 12:34:40 hrs PST8PDT
   Bugs fixed:
     8309642
 
Patch  8309632      : applied ON Tue Jan 18 19:08:52 WIT 2011
   Created ON 24 Mar 2009, 12:34:37 hrs PST8PDT
   Bugs fixed:
     8309632
 
Patch  8309592      : applied ON Tue Jan 18 19:08:48 WIT 2011
   Created ON 24 Mar 2009, 12:34:34 hrs PST8PDT
   Bugs fixed:
     8309592
 
Patch  7609058      : applied ON Tue Jan 18 19:08:44 WIT 2011
   Created ON 31 DEC 2008, 04:15:23 hrs PST8PDT
   Bugs fixed:
     7609058
 
Patch  7609057      : applied ON Tue Jan 18 19:08:40 WIT 2011
   Created ON 31 DEC 2008, 04:17:07 hrs PST8PDT
   Bugs fixed:
     7609057
 
Patch  7375617      : applied ON Tue Jan 18 19:08:37 WIT 2011
   Created ON 16 Sep 2008, 01:15:59 hrs PST8PDT
   Bugs fixed:
     7375617
 
Patch  7375613      : applied ON Tue Jan 18 19:08:34 WIT 2011
   Created ON 16 Sep 2008, 01:15:57 hrs PST8PDT
   Bugs fixed:
     7375613
 
Patch  7375611      : applied ON Tue Jan 18 19:08:31 WIT 2011
   Created ON 16 Sep 2008, 01:15:53 hrs PST8PDT
   Bugs fixed:
     7375611
 
Patch  7197583      : applied ON Tue Jan 18 19:08:27 WIT 2011
   Created ON 3 Jul 2008, 02:11:22 hrs PST8PDT
   Bugs fixed:
     7197583
 
Patch  7155254      : applied ON Tue Jan 18 19:08:22 WIT 2011
   Created ON 3 Jul 2008, 02:10:57 hrs PST8PDT
   Bugs fixed:
     7155254
 
Patch  7155253      : applied ON Tue Jan 18 19:07:35 WIT 2011
   Created ON 3 Jul 2008, 02:10:55 hrs PST8PDT
   Bugs fixed:
     7155253
 
Patch  7155252      : applied ON Tue Jan 18 19:06:57 WIT 2011
   Created ON 3 Jul 2008, 02:10:54 hrs PST8PDT
   Bugs fixed:
     7155252
 
Patch  7155251      : applied ON Tue Jan 18 19:06:52 WIT 2011
   Created ON 3 Jul 2008, 02:10:52 hrs PST8PDT
   Bugs fixed:
     7155251
 
Patch  7155250      : applied ON Tue Jan 18 19:06:47 WIT 2011
   Created ON 3 Jul 2008, 02:10:51 hrs PST8PDT
   Bugs fixed:
     7155250
 
Patch  7155249      : applied ON Tue Jan 18 19:06:43 WIT 2011
   Created ON 3 Jul 2008, 02:10:48 hrs PST8PDT
   Bugs fixed:
     7155249
 
Patch  7155248      : applied ON Tue Jan 18 19:06:40 WIT 2011
   Created ON 3 Jul 2008, 02:10:38 hrs PST8PDT
   Bugs fixed:
     7155248
 
Patch  7385253      : applied ON Tue Jan 18 19:06:02 WIT 2011
   Created ON 29 Sep 2008, 02:36:11 hrs PST8PDT
   Bugs fixed:
     7385253
 
Patch  5523375      : applied ON Tue Jan 18 19:05:46 WIT 2011
   Created ON 3 Jul 2008, 04:08:44 hrs PST8PDT
   Bugs fixed:
     5523375
 
 
 
--------------------------------------------------------------------------------
 
OPatch succeeded.

 

posted @ 2014-04-20 19:27  zero516cn  阅读(2481)  评论(0)  编辑  收藏  举报