oracle 10g里中的listener.ora tnsname.ora和sqlnet.ora三个文件的作用含义是什么?里面的各个变量是怎样解释?
比如:
我创建了一个数据库实例db01
listener.ora文件里:
# listener.ora Network Configuration File: f:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = db01)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = db01)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.53)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)这些怎样解释?
tnsnames.ora文件里怎么解释:KF25653 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.53)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = db01)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)sqlnames.ora文件里也有如下的东东:
# sqlnet.ora Network Configuration File: d:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# 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= (NONE) //好像这里可以设置很多选项的,但不知道是什么意思?请各位解释下。NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
比如:
我创建了一个数据库实例db01
listener.ora文件里:
# listener.ora Network Configuration File: f:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = db01)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = db01)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.53)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)这些怎样解释?
tnsnames.ora文件里怎么解释:KF25653 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.53)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = db01)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)sqlnames.ora文件里也有如下的东东:
# sqlnet.ora Network Configuration File: d:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# 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= (NONE) //好像这里可以设置很多选项的,但不知道是什么意思?请各位解释下。NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP 协议)(HOST = 172.20.10.53 数据库主机)(PORT = 1521 端口号))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))外部过程
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 外部过程连接,一般很少使用
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)KF25653 连接串名称 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP 连接协议)(HOST = 172.20.10.53 数据库主机)(PORT = 1521 连接端口))
(CONNECT_DATA =
(SERVER = DEDICATED 专用服务器连接方式)
(SERVICE_NAME = db01 服务名)
)
)SQLNET.AUTHENTICATION_SERVICES= (NONE)
指定是否允许操作系统验证,也就是你登录数据库所在的操作系统后,不使用数据库用户密码就可登录
none表示不允许,如果为NTS或者ALL则允许,例:c:\>sqlplus / as sysdbaNAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
TNSNAMES TNS连接串连接方式
EZCONNECT简单连接方式
tnsnames.ora是作为客户端程序连接时要查询的远程服务名列表,用于客户端
sqlnet.ora,用于配置网络连接时所使用的连接方式,验证方式等信息
http://home.ixpub.net/space.php?uid=22032845&do=blog&id=407669
http://linux.chinaunix.net/techdoc/database/2008/06/20/1012282.shtml
相信你会有收获
tnsnames.ora 是客户端的配置文件
sqlnet.ora,不清楚,望其他高手回答
tnsname.ora 这个文件里配置网络实例名
sqlnet.ora 用于配置网络连接时所使用的连接方式,验证方式您的例子中,db01就是实例名,实例就是一个数据库的驱动,一个oracle数据库可以有一个或多个实例,一般我们用一个实例的情况是比较多的。具体的实例的概念和原理,您可以去看一下书籍,有好多的缓冲区和后台进程