質問編集履歴
2
コード追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -121,3 +121,71 @@
|
|
|
121
121
|
のような感じでした。
|
|
122
122
|
|
|
123
123
|
原因がいろいろあると思いますが、よろしくお願いします。
|
|
124
|
+
|
|
125
|
+
|
|
126
|
+
|
|
127
|
+
追記 `lsnrctl status`の結果は以下のようになっています。
|
|
128
|
+
|
|
129
|
+
```
|
|
130
|
+
|
|
131
|
+
$ lsnrctl status
|
|
132
|
+
|
|
133
|
+
|
|
134
|
+
|
|
135
|
+
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 27-AUG-2019 00:09:37
|
|
136
|
+
|
|
137
|
+
|
|
138
|
+
|
|
139
|
+
Copyright (c) 1991, 2009, Oracle. All rights reserved.
|
|
140
|
+
|
|
141
|
+
|
|
142
|
+
|
|
143
|
+
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
|
|
144
|
+
|
|
145
|
+
STATUS of the LISTENER
|
|
146
|
+
|
|
147
|
+
------------------------
|
|
148
|
+
|
|
149
|
+
Alias LISTENER
|
|
150
|
+
|
|
151
|
+
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
|
|
152
|
+
|
|
153
|
+
Start Date 26-AUG-2019 07:56:57
|
|
154
|
+
|
|
155
|
+
Uptime 0 days 16 hr. 12 min. 40 sec
|
|
156
|
+
|
|
157
|
+
Trace Level off
|
|
158
|
+
|
|
159
|
+
Security ON: Local OS Authentication
|
|
160
|
+
|
|
161
|
+
SNMP OFF
|
|
162
|
+
|
|
163
|
+
Listener Parameter File /opt/oracle/product/11.2/network/admin/listener.ora
|
|
164
|
+
|
|
165
|
+
Listener Log File /opt/oracle/diag/tnslsnr/db/listener/alert/log.xml
|
|
166
|
+
|
|
167
|
+
Listening Endpoints Summary...
|
|
168
|
+
|
|
169
|
+
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
|
|
170
|
+
|
|
171
|
+
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db.example.com)(PORT=1521)))
|
|
172
|
+
|
|
173
|
+
Services Summary...
|
|
174
|
+
|
|
175
|
+
Service "orcl" has 1 instance(s).
|
|
176
|
+
|
|
177
|
+
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
|
|
178
|
+
|
|
179
|
+
Service "orcl.localdomain" has 2 instance(s).
|
|
180
|
+
|
|
181
|
+
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
|
|
182
|
+
|
|
183
|
+
Instance "orcl", status READY, has 1 handler(s) for this service...
|
|
184
|
+
|
|
185
|
+
Service "orclXDB.localdomain" has 1 instance(s).
|
|
186
|
+
|
|
187
|
+
Instance "orcl", status READY, has 1 handler(s) for this service...
|
|
188
|
+
|
|
189
|
+
The command completed successfully
|
|
190
|
+
|
|
191
|
+
```
|
1
リンク修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -10,7 +10,7 @@
|
|
|
10
10
|
|
|
11
11
|
いろいろな情報を参考に設定を試みておりますが、ここから先の設定がうまくできていない状態です。
|
|
12
12
|
|
|
13
|
-
http://www.noguopin.com/oracle/index.php?ORA-12514
|
|
13
|
+
[http://www.noguopin.com/oracle/index.php?ORA-12514](http://www.noguopin.com/oracle/index.php?ORA-12514)
|
|
14
14
|
|
|
15
15
|
|
|
16
16
|
|