質問編集履歴
3
listener\.oraの修正
title
CHANGED
File without changes
|
body
CHANGED
@@ -41,6 +41,11 @@
|
|
41
41
|
(PROGRAM = extproc)
|
42
42
|
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\oracle\product\12.1.0\dbhome_1\bin\oraclr12.dll")
|
43
43
|
)
|
44
|
+
(SID_DESC =
|
45
|
+
(GLOBAL_DBNAME = ORCL)
|
46
|
+
(ORACLE_HOME = C:\app\oracle\product\12.1.0\dbhome_1)
|
47
|
+
(SID_NAME = ORCL)
|
48
|
+
)
|
44
49
|
)
|
45
50
|
|
46
51
|
LISTENER =
|
@@ -51,7 +56,6 @@
|
|
51
56
|
)
|
52
57
|
)
|
53
58
|
|
54
|
-
|
55
59
|
```
|
56
60
|
●C:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora
|
57
61
|
```ここに言語を入力
|
2
listener\.ora/sqlnet\.ora/tnsnames\.oraの追記
title
CHANGED
File without changes
|
body
CHANGED
@@ -24,8 +24,87 @@
|
|
24
24
|
|
25
25
|

|
26
26
|
|
27
|
+
※追記
|
27
28
|
●サービス
|
28
29
|

|
29
30
|
|
31
|
+
●C:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\listener.ora
|
32
|
+
```ここに言語を入力
|
33
|
+
# listener.ora Network Configuration File: C:\app\oracle\product\12.1.0\dbhome_1\network\admin\listener.ora
|
34
|
+
# Generated by Oracle configuration tools.
|
35
|
+
|
36
|
+
SID_LIST_LISTENER =
|
37
|
+
(SID_LIST =
|
38
|
+
(SID_DESC =
|
39
|
+
(SID_NAME = CLRExtProc)
|
40
|
+
(ORACLE_HOME = C:\app\oracle\product\12.1.0\dbhome_1)
|
41
|
+
(PROGRAM = extproc)
|
42
|
+
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\oracle\product\12.1.0\dbhome_1\bin\oraclr12.dll")
|
43
|
+
)
|
44
|
+
)
|
45
|
+
|
46
|
+
LISTENER =
|
47
|
+
(DESCRIPTION_LIST =
|
48
|
+
(DESCRIPTION =
|
49
|
+
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.4)(PORT = 1521))
|
50
|
+
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
|
51
|
+
)
|
52
|
+
)
|
53
|
+
|
54
|
+
|
55
|
+
```
|
56
|
+
●C:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora
|
57
|
+
```ここに言語を入力
|
58
|
+
# sqlnet.ora Network Configuration File: C:\app\oracle\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
|
59
|
+
# Generated by Oracle configuration tools.
|
60
|
+
|
61
|
+
# This file is actually generated by netca. But if customers choose to
|
62
|
+
# install "Software Only", this file wont exist and without the native
|
63
|
+
# authentication, they will not be able to connect to the database on NT.
|
64
|
+
|
65
|
+
SQLNET.AUTHENTICATION_SERVICES= (NTS)
|
66
|
+
|
67
|
+
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
|
68
|
+
|
69
|
+
|
70
|
+
```
|
71
|
+
|
72
|
+
●C:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
|
73
|
+
```ora
|
74
|
+
# tnsnames.ora Network Configuration File: C:\app\oracle\product\12.1.0\dbhome_1\network\admin\tnsnames.ora
|
75
|
+
# Generated by Oracle configuration tools.
|
76
|
+
|
77
|
+
ORACLR_CONNECTION_DATA =
|
78
|
+
(DESCRIPTION =
|
79
|
+
(ADDRESS_LIST =
|
80
|
+
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
|
81
|
+
)
|
82
|
+
(CONNECT_DATA =
|
83
|
+
(SID = CLRExtProc)
|
84
|
+
(PRESENTATION = RO)
|
85
|
+
)
|
86
|
+
)
|
87
|
+
|
88
|
+
SAMPLEDB01 =
|
89
|
+
(DESCRIPTION =
|
90
|
+
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.4)(PORT = 1521))
|
91
|
+
(CONNECT_DATA =
|
92
|
+
(SERVER = DEDICATED)
|
93
|
+
(SERVICE_NAME = sampledb01)
|
94
|
+
)
|
95
|
+
)
|
96
|
+
|
97
|
+
OCD =
|
98
|
+
(DESCRIPTION =
|
99
|
+
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
|
100
|
+
(CONNECT_DATA =
|
101
|
+
(SERVER = DEDICATED)
|
102
|
+
(SERVICE_NAME = OCD)
|
103
|
+
)
|
104
|
+
)
|
105
|
+
```
|
106
|
+
|
107
|
+
|
108
|
+
|
30
109
|
以上となります。
|
31
110
|
よろしくお願いいたします。
|
1
サービス画面キャプチャの追加
title
CHANGED
File without changes
|
body
CHANGED
@@ -24,6 +24,8 @@
|
|
24
24
|
|
25
25
|

|
26
26
|
|
27
|
+
●サービス
|
28
|
+

|
27
29
|
|
28
30
|
以上となります。
|
29
31
|
よろしくお願いいたします。
|