oracle-网络服务名的配置.ppt

《oracle-网络服务名的配置.ppt》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、网络服务名的配置OverviewofNamingMethodsNamingmethodsareusedbyaclientapplicationtoresolveaconnectidentifiertoaconnectdescriptorwhenattemptingtoconnecttoadatabaseservice.OracleNetprovidesfivenamingmethods:HostnamingLocalnamingDirectorynamingOracleNamesExternalnamingLocalNaminglistener.oraServerClienttnsnam

2、es.orasqlnet.oraConfiguringthetnsnames.oraFileUsingNetManagerGeneratedFiles:tnsnames.ora#TNSNAMES.ORANetworkConfiguration#File:D:oracleora92NETWORKADMINtnsnames.ora#GeneratedbyOracleconfigurationtools.U461=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ed-pdsun1)(PORT=8461)))(CONNE

3、CT_DATA=(SERVICE_NAME=U461)))GeneratedFiles:sqlnet.oraTroubleshootingtheClientSideThefollowingerrorcodesarerelatedtoproblemsontheclientside:ORA-12154“TNS:couldnotresolveservicename”ORA-12198“TNS:couldnotfindpathtodestination”ORA-12203“TNS:unabletoconnecttodestination”ORA-12533“TNS:illegalADDRESSp

4、arameters”ORA-12541“TNS:nolistener”