tnsnames.ora

发布时间：2020-12-12 16:14:46 所属栏目：百科来源：网络整理

导读：情景1: name1 = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=locahost)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=xxxx)) ) 情景2: name2= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp)(host = localhost)(port = 1521)) ) (CONNECT_DATA =

情景1:

name1 = (DESCRIPTION=

(ADDRESS=(PROTOCOL=tcp)(HOST=locahost)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=xxxx))
)

情景2:

name2=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(host = localhost)(port = 1521))
)
(CONNECT_DATA =
(server = DEDICATED)
(SID = xxxxxx)
)

)

SID:

实例名,由该用户的环境变量ORACLE_SID（注意这里是大写）决定。在windows平台下，则是注册表中oracle_sid值决定

SERVICE_NAME:

SERVICE_NAME指的是listener中的全局数据库名：这个名字是由

listener.ora中GLOBAL_DBNAME参数决定的

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!