方法一:
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
)
)
global_name又是来自Db_name. Db_domain
要修改global_name,执行ALTER DATABASE RENAME GLOBAL_NAME TO <db_name.db_domain>
方法2:
jingtai2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.111)(PORT = 1523))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = prod)——取自instance_name;
)
)
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配置](http://i2.51cto.com/images/blog/201801/16/70ce766787d6084746fc5ba9db48d5fa.png?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_100,g_se,x_10,y_10,shadow_90,type_ZmFuZ3poZW5naGVpdGk=)
global_name又是来自Db_name. Db_domain
![tnsnames.ora配置](http://i2.51cto.com/images/blog/201801/16/3fdb18a21218a021d2f3ddb71094803f.png?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_100,g_se,x_10,y_10,shadow_90,type_ZmFuZ3poZW5naGVpdGk=)
要修改global_name,执行ALTER DATABASE RENAME GLOBAL_NAME TO <db_name.db_domain>
方法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配置](http://i2.51cto.com/images/blog/201801/16/a60457025fbc49d7c29fb27b45d4390c.png?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_100,g_se,x_10,y_10,shadow_90,type_ZmFuZ3poZW5naGVpdGk=)
本文转自 rm_rf_db 51CTO博客,原文链接:http://blog.51cto.com/12185273/2061809,如需转载请自行联系原作者