teratail
回答率
85.48%
質問するログイン新規登録
トップに関する質問oracle 12c r1 データベース名がリスナーに反映されない？現象

編集履歴

質問編集履歴

2

間違い行があったため、修正

2020/04/13 13:12

投稿

ky_46
ky_46

スコア92

test CHANGED
File without changes
test CHANGED
@@ -228,11 +228,65 @@
228
228
 
229
229
  (ORACLE_HOME = C:\app\oraclehome\product\12.1.0\dbhome_1)
230
230
 
231
+ (PROGRAM = extproc)
232
+
233
+ (ENVS = "EXTPROC_DLLS=ONLY:C:\app\oraclehome\product\12.1.0\dbhome_1\bin\oraclr12.dll")
234
+
235
+ )
236
+
237
+ )
238
+
239
+
240
+
241
+ LISTENER =
242
+
243
+ (DESCRIPTION_LIST =
244
+
245
+ (DESCRIPTION =
246
+
247
+ (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.30)(PORT = 1521))
248
+
249
+ )
250
+
251
+ )
252
+
253
+
254
+
255
+
256
+
257
+ ```
258
+
259
+
260
+
261
+ という状態になっていたため、listener.ora.sample を参考に
262
+
263
+
264
+
265
+ ```
266
+
267
+ # listener.ora Network Configuration File: C:\app\oraclehome\product\12.1.0\dbhome_1\network\admin\listener.ora
268
+
269
+ # Generated by Oracle configuration tools.
270
+
271
+
272
+
273
+ SID_LIST_LISTENER =
274
+
275
+ (SID_LIST =
276
+
277
+ (SID_DESC =
278
+
279
+ # (SID_NAME = CLRExtProc)
280
+
281
+ (SID_NAME = orcl12c)
282
+
283
+ (ORACLE_HOME = C:\app\oraclehome\product\12.1.0\dbhome_1)
284
+
231
285
  (PROGRAM = orcl12c)
232
286
 
233
- (PROGRAM = extproc)
287
+ # (PROGRAM = extproc)
234
-
288
+
235
- (ENVS = "EXTPROC_DLLS=ONLY:C:\app\oraclehome\product\12.1.0\dbhome_1\bin\oraclr12.dll")
289
+ # (ENVS = "EXTPROC_DLLS=ONLY:C:\app\oraclehome\product\12.1.0\dbhome_1\bin\oraclr12.dll")
236
290
 
237
291
  )
238
292
 
@@ -258,62 +312,6 @@
258
312
 
259
313
  ```
260
314
 
261
-
262
-
263
- という状態になっていたため、listener.ora.sample を参考に
264
-
265
-
266
-
267
- ```
268
-
269
- # listener.ora Network Configuration File: C:\app\oraclehome\product\12.1.0\dbhome_1\network\admin\listener.ora
270
-
271
- # Generated by Oracle configuration tools.
272
-
273
-
274
-
275
- SID_LIST_LISTENER =
276
-
277
- (SID_LIST =
278
-
279
- (SID_DESC =
280
-
281
- # (SID_NAME = CLRExtProc)
282
-
283
- (SID_NAME = orcl12c)
284
-
285
- (ORACLE_HOME = C:\app\oraclehome\product\12.1.0\dbhome_1)
286
-
287
- (PROGRAM = orcl12c)
288
-
289
- # (PROGRAM = extproc)
290
-
291
- # (ENVS = "EXTPROC_DLLS=ONLY:C:\app\oraclehome\product\12.1.0\dbhome_1\bin\oraclr12.dll")
292
-
293
- )
294
-
295
- )
296
-
297
-
298
-
299
- LISTENER =
300
-
301
- (DESCRIPTION_LIST =
302
-
303
- (DESCRIPTION =
304
-
305
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.30)(PORT = 1521))
306
-
307
- )
308
-
309
- )
310
-
311
-
312
-
313
-
314
-
315
- ```
316
-
317
315
  に直したところ、Windows10のクライアント機からの>sqlplus SCOTT/tiger@orcl12cが
318
316
 
319
317
 

1

KOZ6.0さんのご指摘追記します

2020/04/13 13:12

投稿

ky_46
ky_46

スコア92

test CHANGED
File without changes
test CHANGED
@@ -197,3 +197,139 @@
197
197
 
198
198
 
199
199
  よろしくお願いいたします。
200
+
201
+
202
+
203
+
204
+
205
+ 追記します。
206
+
207
+
208
+
209
+ KOZ6.0さんのご指摘で、listener.oraを調べたところ
210
+
211
+
212
+
213
+ ```
214
+
215
+ # listener.ora Network Configuration File: C:\app\oraclehome\product\12.1.0\dbhome_1\network\admin\listener.ora
216
+
217
+ # Generated by Oracle configuration tools.
218
+
219
+
220
+
221
+ SID_LIST_LISTENER =
222
+
223
+ (SID_LIST =
224
+
225
+ (SID_DESC =
226
+
227
+ (SID_NAME = CLRExtProc)
228
+
229
+ (ORACLE_HOME = C:\app\oraclehome\product\12.1.0\dbhome_1)
230
+
231
+ (PROGRAM = orcl12c)
232
+
233
+ (PROGRAM = extproc)
234
+
235
+ (ENVS = "EXTPROC_DLLS=ONLY:C:\app\oraclehome\product\12.1.0\dbhome_1\bin\oraclr12.dll")
236
+
237
+ )
238
+
239
+ )
240
+
241
+
242
+
243
+ LISTENER =
244
+
245
+ (DESCRIPTION_LIST =
246
+
247
+ (DESCRIPTION =
248
+
249
+ (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.30)(PORT = 1521))
250
+
251
+ )
252
+
253
+ )
254
+
255
+
256
+
257
+
258
+
259
+ ```
260
+
261
+
262
+
263
+ という状態になっていたため、listener.ora.sample を参考に
264
+
265
+
266
+
267
+ ```
268
+
269
+ # listener.ora Network Configuration File: C:\app\oraclehome\product\12.1.0\dbhome_1\network\admin\listener.ora
270
+
271
+ # Generated by Oracle configuration tools.
272
+
273
+
274
+
275
+ SID_LIST_LISTENER =
276
+
277
+ (SID_LIST =
278
+
279
+ (SID_DESC =
280
+
281
+ # (SID_NAME = CLRExtProc)
282
+
283
+ (SID_NAME = orcl12c)
284
+
285
+ (ORACLE_HOME = C:\app\oraclehome\product\12.1.0\dbhome_1)
286
+
287
+ (PROGRAM = orcl12c)
288
+
289
+ # (PROGRAM = extproc)
290
+
291
+ # (ENVS = "EXTPROC_DLLS=ONLY:C:\app\oraclehome\product\12.1.0\dbhome_1\bin\oraclr12.dll")
292
+
293
+ )
294
+
295
+ )
296
+
297
+
298
+
299
+ LISTENER =
300
+
301
+ (DESCRIPTION_LIST =
302
+
303
+ (DESCRIPTION =
304
+
305
+ (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.30)(PORT = 1521))
306
+
307
+ )
308
+
309
+ )
310
+
311
+
312
+
313
+
314
+
315
+ ```
316
+
317
+ に直したところ、Windows10のクライアント機からの>sqlplus SCOTT/tiger@orcl12cが
318
+
319
+
320
+
321
+ ```
322
+
323
+ ERROR:
324
+
325
+ ORA-12518: TNS:listener could not hand off client connection
326
+
327
+ ```
328
+
329
+ に変化しました。
330
+
331
+
332
+
333
+ googleで調べると、サービスが起動していないのでは？
334
+
335
+ という記事がみつかりましたが、WindowsServer2016上でぇあ、OracleServiceORCL12Cは自動で起動されています。