質問編集履歴

1

ファイルの内容を伏字部分を交えて更新いたしました。

2020/11/16 06:26

投稿

beginner_Jiro
beginner_Jiro

スコア10

test CHANGED
File without changes
test CHANGED
@@ -53,3 +53,69 @@
53
53
 
54
54
 
55
55
  以上になります。よろしくお願いいたします。
56
+
57
+
58
+
59
+ ### tnsnames.ora、sqlnet.oraの追記
60
+
61
+ Orlofsky様よりご指摘いただき両ファイルの内容を下記に記載いたします。(機密項目は伏字とさせていただきます。)
62
+
63
+ ```sqlnet.ora
64
+
65
+ # sqlnet.ora Network Configuration File: C:\oracle\product\11.2.0\client_1\network\admin\sqlnet.ora
66
+
67
+ # Generated by Oracle configuration tools.
68
+
69
+
70
+
71
+ # This file is actually generated by netca. But if customers choose to
72
+
73
+ # install "Software Only", this file wont exist and without the native
74
+
75
+ # authentication, they will not be able to connect to the database on NT.
76
+
77
+
78
+
79
+ SQLNET.AUTHENTICATION_SERVICES= (NONE)
80
+
81
+
82
+
83
+ NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
84
+
85
+
86
+
87
+ ```
88
+
89
+
90
+
91
+ ```tnsnames.ora
92
+
93
+ # tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
94
+
95
+ # Generated by Oracle configuration tools.
96
+
97
+
98
+
99
+ #
100
+
101
+ xxx_DEV =
102
+
103
+ (DESCRIPTION =
104
+
105
+ (ADDRESS_LIST =
106
+
107
+ (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx))
108
+
109
+ )
110
+
111
+ (CONNECT_DATA =
112
+
113
+ (SERVER=DEDICATED)(SERVICE_NAME = xxxxDB)
114
+
115
+ )
116
+
117
+ )
118
+
119
+
120
+
121
+ ```