Help us understand the problem. What is going on with this article?

oracle 初期設定 備忘録*完全なる私用*

完全なる私用のため、見栄えは範疇外。悪しからず。

ORACLE_HOMEに異常を発見

cmd
 C:\???\???>tnsping
 TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 - Production on 16-JUL-2019 14:38:45

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

TNS-03502: Message 3502 not found; No message file for product=NETWORK, facility=TNS
cmd
C:\???\???>>lsnrctl start XE

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 16-JUL-2019 14:43:08

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Message 1070 not found; No message file for product=NETWORK, facility=TNSTNS-12557: Message 12557 not found; No message file for product=NETWORK, facility=TNS
 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS
  TNS-00527: Message 527 not found; No message file for product=NETWORK, facility=TNS

参考にさせていただいたページ1
参考にさせていただいたページ2
参考にさせていただいたページ3

ORACLE_HOMEの問題は解決したものの、「TNS-12541: TNS: リスナーがありません。」が出る

cmd
C:\Users\CiNK03>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 16-7月 -2019 17:37:17

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))に接続中
TNS-12541: TNS: リスナーがありません。
 TNS-12560: TNS: プロトコル・アダプタ・エラー
  TNS-00511: リスナーがありません。
   32-bit Windows Error: 2: No such file or directory
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)))に接続中
TNS-12541: TNS: リスナーがありません。
 TNS-12560: TNS: プロトコル・アダプタ・エラー
  TNS-00511: リスナーがありません。
   32-bit Windows Error: 61: Unknown error
cmd
D:\>TNSPING XE

TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 - Production on 16-7月 -2019 17:51:39

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

パラメータ・ファイルを使用しました:
D:\app\oracle\product\11.2.0\server\network\admin\sqlnet.ora


エイリアスを解決するためにTNSNAMESアダプタを使用しました。
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))に接続の試行中
TNS-12541: TNS: リスナーがありません。

参考にさせていただいたサイト「似た症状のQA」

Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
Comments
No comments
Sign up for free and join this conversation.
If you already have a Qiita account
Why do not you register as a user and use Qiita more conveniently?
You need to log in to use this function. Qiita can be used more conveniently after logging in.
You seem to be reading articles frequently this month. Qiita can be used more conveniently after logging in.
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
ユーザーは見つかりませんでした