查看: 1689|回复: 0

[Mysql数据库] tnsnames.ora配置

发表于 2018-1-24 08:00:01

方法一:
jingtai =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.111)(PORT = 1523))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prod.enmoedu.com)——取自global_name,可以理解为service_name等同于global_name
)
)
tnsnames.ora配置
global_name又是来自Db_name. Db_domain
tnsnames.ora配置
要修改global_name,执行ALTER DATABASE RENAME GLOBAL_NAME TO
方法2:
jingtai2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.111)(PORT = 1523))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = prod)——取自instance_name;
)
)
tnsnames.ora配置



回复

使用道具 举报