sqlnet.ora文件内容如下:# This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES = (NTS)
2.Oracle中网络服务名的配置文件:tnsnames.ora文件
3.Sqlnet.ora文件(由于用的不多,暂时不知道这个文件的具体用处);请教大神能够详细讲解一下 关于以上三个文件的详细用处,谢谢!!!!
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL1)
)
)
ORCL2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL2)
)
)
ORCL3=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =127.0.0.1)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL3)
)
)
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES = (NTS)
当采用本地命名方法时,客户端就需要配置本地网络服务名的配置文件tnsnames.ora;当服务端需要连接其他分布式服务器时,才需要配置tnsnames.ora;
如果要配置命名方法,在客户端还会配置命名方法配置文件sqlnet.ora
第四章 网络服务与网络管理