oracle 网络服务名的配置
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
Oracle Net provides five naming methods:
Host naming Local naming Directory naming Oracle Names External naming
Local Naming
ClientΒιβλιοθήκη Baidu
Server
sqlnet.ora tnsnames.ora
网络服务名的配置
Overview of Naming
Methods
Naming methods are used by a client application to resolve a connect identifier to a connect descriptor when attempting to connect to a database service.
listener.ora
Configuring the tnsnames.ora File Using Net Manager
Generated Files: tnsnames.ora
# TNSNAMES.ORA Network Configuration # File:D:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools. U461 =
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ed-pdsun1)(PORT = 8461)) ) (CONNECT_DATA = (SERVICE_NAME = U461) ) )
Troubleshooting the Client Side
The following error codes are related to problems on the client side:
ORA-12154 “TNS:could not resolve service name” ORA-12198 “TNS:could not find path to destination” ORA-12203 “TNS:unable to connect to destination” ORA-12533 “TNS:illegal ADDRESS parameters” ORA-12541 “TNS:no listener”
Host naming Local naming Directory naming Oracle Names External naming
Local Naming
ClientΒιβλιοθήκη Baidu
Server
sqlnet.ora tnsnames.ora
网络服务名的配置
Overview of Naming
Methods
Naming methods are used by a client application to resolve a connect identifier to a connect descriptor when attempting to connect to a database service.
listener.ora
Configuring the tnsnames.ora File Using Net Manager
Generated Files: tnsnames.ora
# TNSNAMES.ORA Network Configuration # File:D:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools. U461 =
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ed-pdsun1)(PORT = 8461)) ) (CONNECT_DATA = (SERVICE_NAME = U461) ) )
Troubleshooting the Client Side
The following error codes are related to problems on the client side:
ORA-12154 “TNS:could not resolve service name” ORA-12198 “TNS:could not find path to destination” ORA-12203 “TNS:unable to connect to destination” ORA-12533 “TNS:illegal ADDRESS parameters” ORA-12541 “TNS:no listener”