--> Linux环境下添加Net服务名：
进入oracle的主目录，更改以下文件
product/9.2.0/network/admin/tnsnames.ora
添加以下内容
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.13.14)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = supersun)
)
)
这里的test是Net服务名，supersun是全局数据库名，(HOST = 192.168.13.14)(PORT = 1521)是主地地址及使用的端口。
测试：
[oracle@supersun.biz admin]$ tnsping test
TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 24-OCT-2007 15:01:23
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/home/oracle/product/9.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.13.14)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = supersun)))
OK (0 msec)
[oracle@supersun.biz admin]$ tnsping test
TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 24-OCT-2007 15:01:23
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/home/oracle/product/9.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.13.14)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = supersun)))
OK (0 msec)
发表评论