teratail
回答率
85.48%
質問するログイン新規登録
トップに関する質問Oracle SQL Developerのデータベース接続について

編集履歴

質問編集履歴

3

listener\.oraの修正

2016/12/30 08:29

投稿

erk024
erk024

スコア13

test CHANGED
File without changes
test CHANGED
@@ -84,6 +84,16 @@
84
84
 
85
85
  )
86
86
 
87
+ (SID_DESC =
88
+
89
+ (GLOBAL_DBNAME = ORCL)
90
+
91
+ (ORACLE_HOME = C:\app\oracle\product\12.1.0\dbhome_1)
92
+
93
+ (SID_NAME = ORCL)
94
+
95
+ )
96
+
87
97
  )
88
98
 
89
99
 
@@ -104,8 +114,6 @@
104
114
 
105
115
 
106
116
 
107
-
108
-
109
117
  ```
110
118
 
111
119
  ●C:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora

2

listener\.ora/sqlnet\.ora/tnsnames\.oraの追記

2016/12/30 08:28

投稿

erk024
erk024

スコア13

test CHANGED
File without changes
test CHANGED
@@ -50,12 +50,170 @@
50
50
 
51
51
 
52
52
 
53
+ ※追記
54
+
53
55
  ●サービス
54
56
 
55
57
  ![イメージ説明](1ab74a62c7f1e5e981488937bdc0276f.png)
56
58
 
57
59
 
58
60
 
61
+ ●C:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\listener.ora
62
+
63
+ ```ここに言語を入力
64
+
65
+ # listener.ora Network Configuration File: C:\app\oracle\product\12.1.0\dbhome_1\network\admin\listener.ora
66
+
67
+ # Generated by Oracle configuration tools.
68
+
69
+
70
+
71
+ SID_LIST_LISTENER =
72
+
73
+ (SID_LIST =
74
+
75
+ (SID_DESC =
76
+
77
+ (SID_NAME = CLRExtProc)
78
+
79
+ (ORACLE_HOME = C:\app\oracle\product\12.1.0\dbhome_1)
80
+
81
+ (PROGRAM = extproc)
82
+
83
+ (ENVS = "EXTPROC_DLLS=ONLY:C:\app\oracle\product\12.1.0\dbhome_1\bin\oraclr12.dll")
84
+
85
+ )
86
+
87
+ )
88
+
89
+
90
+
91
+ LISTENER =
92
+
93
+ (DESCRIPTION_LIST =
94
+
95
+ (DESCRIPTION =
96
+
97
+ (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.4)(PORT = 1521))
98
+
99
+ (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
100
+
101
+ )
102
+
103
+ )
104
+
105
+
106
+
107
+
108
+
109
+ ```
110
+
111
+ ●C:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora
112
+
113
+ ```ここに言語を入力
114
+
115
+ # sqlnet.ora Network Configuration File: C:\app\oracle\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
116
+
117
+ # Generated by Oracle configuration tools.
118
+
119
+
120
+
121
+ # This file is actually generated by netca. But if customers choose to
122
+
123
+ # install "Software Only", this file wont exist and without the native
124
+
125
+ # authentication, they will not be able to connect to the database on NT.
126
+
127
+
128
+
129
+ SQLNET.AUTHENTICATION_SERVICES= (NTS)
130
+
131
+
132
+
133
+ NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
134
+
135
+
136
+
137
+
138
+
139
+ ```
140
+
141
+
142
+
143
+ ●C:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
144
+
145
+ ```ora
146
+
147
+ # tnsnames.ora Network Configuration File: C:\app\oracle\product\12.1.0\dbhome_1\network\admin\tnsnames.ora
148
+
149
+ # Generated by Oracle configuration tools.
150
+
151
+
152
+
153
+ ORACLR_CONNECTION_DATA =
154
+
155
+ (DESCRIPTION =
156
+
157
+ (ADDRESS_LIST =
158
+
159
+ (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
160
+
161
+ )
162
+
163
+ (CONNECT_DATA =
164
+
165
+ (SID = CLRExtProc)
166
+
167
+ (PRESENTATION = RO)
168
+
169
+ )
170
+
171
+ )
172
+
173
+
174
+
175
+ SAMPLEDB01 =
176
+
177
+ (DESCRIPTION =
178
+
179
+ (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.4)(PORT = 1521))
180
+
181
+ (CONNECT_DATA =
182
+
183
+ (SERVER = DEDICATED)
184
+
185
+ (SERVICE_NAME = sampledb01)
186
+
187
+ )
188
+
189
+ )
190
+
191
+
192
+
193
+ OCD =
194
+
195
+ (DESCRIPTION =
196
+
197
+ (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
198
+
199
+ (CONNECT_DATA =
200
+
201
+ (SERVER = DEDICATED)
202
+
203
+ (SERVICE_NAME = OCD)
204
+
205
+ )
206
+
207
+ )
208
+
209
+ ```
210
+
211
+
212
+
213
+
214
+
215
+
216
+
59
217
  以上となります。
60
218
 
61
219
  よろしくお願いいたします。

1

サービス画面キャプチャの追加

2016/12/30 05:55

投稿

erk024
erk024

スコア13

test CHANGED
File without changes
test CHANGED
@@ -50,6 +50,10 @@
50
50
 
51
51
 
52
52
 
53
+ ●サービス
54
+
55
+ ![イメージ説明](1ab74a62c7f1e5e981488937bdc0276f.png)
56
+
53
57
 
54
58
 
55
59
  以上となります。