oracle提供了五种网络服务解析
- WBOYオリジナル
- 2016-06-07 15:26:461182ブラウズ
host naming ： 主机命名方法(客户端为windows xp,服务器端为linuxoracle 9i) 1、配置客户端的sqlnet.ora SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME) 2 、配置服务器端的listener.ora LISTENER = (DESCRIPTION = (A
host naming：主机命名方法(客户端为windows xp,服务器端为linux+oracle 9i)
1、配置客户端的sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)
2、配置服务器端的listener.ora
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = linuxoracle)(PORT = 1521)) #注意HOST配置为主机名
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = linuxoracle) #注意GLOBAL_DBNAME为主机名
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(SID_NAME = dg1)
)
(SID_DESC =
(GLOBAL_DBNAME = linuxoracle)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(SID_NAME = OEMREP)
)
)
3、链接：
C:Documents and Settings ew>sqlplus system/lijie123@linuxoracle
注：
1、如果没有正确配置GLOBAL_DBNAME,sqlplus连接时，会报如下错误:
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
2、ORA-12154: TNS: 无法解析指定的连接标识符。可能是客户端hosts或dns问题，打开hosts
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host
127.0.0.1 localhost
修该为:
...............................................................
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host
127.0.0.1 localhost
192.168.1.61 linuxoracle