質問編集履歴
1
修正箇所の指摘ありがとうございます！［コード］に修正させていただきました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -14,6 +14,74 @@
|
|
|
14
14
|
|
|
15
15
|
|
|
16
16
|
|
|
17
|
+
<code>
|
|
18
|
+
|
|
19
|
+
|
|
20
|
+
|
|
21
|
+
java.sql.SQLException: The Network Adapter could not establish the connection
|
|
22
|
+
|
|
23
|
+
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
|
|
24
|
+
|
|
25
|
+
at oracle.jdbc.driver.PhysicalCo nnection.<init>(PhysicalConnection.java:531)
|
|
26
|
+
|
|
27
|
+
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
|
|
28
|
+
|
|
29
|
+
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
|
|
30
|
+
|
|
31
|
+
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
|
|
32
|
+
|
|
33
|
+
at java.sql.DriverManager.getConnection(DriverManager.java:582)
|
|
34
|
+
|
|
35
|
+
at java.sql.DriverManager.getConnection(DriverManager.java:185)
|
|
36
|
+
|
|
37
|
+
at study.DBAccess.connect(DBAccess.java:30)
|
|
38
|
+
|
|
39
|
+
at study.exec.main(exec.java:14)
|
|
40
|
+
|
|
41
|
+
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
|
|
42
|
+
|
|
43
|
+
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:359)
|
|
44
|
+
|
|
45
|
+
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:422)
|
|
46
|
+
|
|
47
|
+
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:672)
|
|
48
|
+
|
|
49
|
+
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:237)
|
|
50
|
+
|
|
51
|
+
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
|
|
52
|
+
|
|
53
|
+
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
|
|
54
|
+
|
|
55
|
+
... 8 more
|
|
56
|
+
|
|
57
|
+
Caused by: java.net.ConnectException: Connection refused: connect
|
|
58
|
+
|
|
59
|
+
at java.net.PlainSocketImpl.socketConnect(Native Method)
|
|
60
|
+
|
|
61
|
+
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
|
|
62
|
+
|
|
63
|
+
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
|
|
64
|
+
|
|
65
|
+
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
|
|
66
|
+
|
|
67
|
+
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
|
|
68
|
+
|
|
69
|
+
at java.net.Socket.connect(Socket.java:525)
|
|
70
|
+
|
|
71
|
+
at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:141)
|
|
72
|
+
|
|
73
|
+
at oracle.net.nt.ConnOption.connect(ConnOption.java:123)
|
|
74
|
+
|
|
75
|
+
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:337)
|
|
76
|
+
|
|
77
|
+
... 13 more
|
|
78
|
+
|
|
79
|
+
|
|
80
|
+
|
|
81
|
+
</code>
|
|
82
|
+
|
|
83
|
+
|
|
84
|
+
|
|
17
85
|
上の画像のように接続のテストの段階でこのエラーが出てしまっていて
|
|
18
86
|
|
|
19
87
|
これを解決するために、
|
|
@@ -21,6 +89,36 @@
|
|
|
21
89
|
|
|
22
90
|
|
|
23
91
|
|
|
92
|
+
|
|
93
|
+
|
|
94
|
+
|
|
95
|
+
<code>
|
|
96
|
+
|
|
97
|
+
|
|
98
|
+
|
|
99
|
+
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DESKTOP-4B6J5J5)(PORT=1521)))に接続中
|
|
100
|
+
|
|
101
|
+
TNS-12541: TNS: リスナーがありません。
|
|
102
|
+
|
|
103
|
+
TNS-12560: TNS: プロトコル・アダプタ・エラー
|
|
104
|
+
|
|
105
|
+
TNS-00511: リスナーがありません。
|
|
106
|
+
|
|
107
|
+
64-bit Windows Error: 61: Unknown error
|
|
108
|
+
|
|
109
|
+
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))に接続中
|
|
110
|
+
|
|
111
|
+
TNS-12541: TNS: リスナーがありません。
|
|
112
|
+
|
|
113
|
+
TNS-12560: TNS: プロトコル・アダプタ・エラー
|
|
114
|
+
|
|
115
|
+
TNS-00511: リスナーがありません。
|
|
116
|
+
|
|
117
|
+
64-bit Windows Error: 2: No such file or directory
|
|
118
|
+
|
|
119
|
+
|
|
120
|
+
|
|
121
|
+
</code>
|
|
24
122
|
|
|
25
123
|
|
|
26
124
|
|