teratail header banner
teratail header banner
質問するログイン新規登録

質問編集履歴

3

listener\.oraの修正

2016/12/30 08:29

投稿

erk024
erk024

スコア13

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の追記

2016/12/30 08:28

投稿

erk024
erk024

スコア13

title CHANGED
File without changes
body CHANGED
@@ -24,8 +24,87 @@
24
24
 
25
25
  ![イメージ説明](6dfbd43bfc404087db607e6b1681e24d.png)
26
26
 
27
+ ※追記
27
28
  ●サービス
28
29
  ![イメージ説明](1ab74a62c7f1e5e981488937bdc0276f.png)
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

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

2016/12/30 05:55

投稿

erk024
erk024

スコア13

title CHANGED
File without changes
body CHANGED
@@ -24,6 +24,8 @@
24
24
 
25
25
  ![イメージ説明](6dfbd43bfc404087db607e6b1681e24d.png)
26
26
 
27
+ ●サービス
28
+ ![イメージ説明](1ab74a62c7f1e5e981488937bdc0276f.png)
27
29
 
28
30
  以上となります。
29
31
  よろしくお願いいたします。