oracle的sqlnet.ora、tnsnames.ora、listener.ora的常规配置

ijhud1t3cn

　　文件一：
　　sqlnet.ora 定义数据库连接时连接字符串的寻找方式，一般不用手动配置，默认就好，如
　　

# sqlnet.ora Network Configuration File: E:\az\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= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

　　 文件二：
　　
　　tnsnames.ora 定义本地，远程数据库连接信息，如：连接方式，连接地址，连接端口号，一般定义如下
　　

# tnsnames.ora Network Configuration File: E:\az\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
192.168.22.24 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.22.24)(PORT = 1521))
)
(CONNECT_DATA =(SID = ORCL)
)
)


　　
　　
　　文件三：
　　listener.ora  一般书写如下 
　　

# listener.ora Network Configuration File: E:\az\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 = PLSExtProc)
(ORACLE_HOME = E:\az\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =  
(GLOBAL_DBNAME = ORCL)  
(ORACLE_HOME = E:\az\oracle)  
(SID_NAME = ORCL)  
)  
)
LISTENER =  
(DESCRIPTION_LIST =  
(DESCRIPTION =  
(ADDRESS = (PROTOCOL = TCP)(HOST = Leeo-PC)(PORT = 1521))  
)  
)