tnsping <service_name> 这个语法,假设现在别人未提供给我service_name,给的是SID.如下:
SALES =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.188.219)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID= sales)
))
。那我用tnsping sales 命令有意义吗?
SALES =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.188.219)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID= sales)
))
。那我用tnsping sales 命令有意义吗?
sid就是服务器的全局数据库名这样理解正确吗
一台机器上如果有多个数据库,那么不能使用相同的SID。
一般就和你的数据库名相同……