(Original) Configuring TNSName is a very easy issue, nothing to say, I have never missed it before, but two small problems have been configured today (these two issues are not available when using GUI configuration, I think Java Starting too slow, manually configuring tnsname.ora) C: /> TNSPING 100
TNS Ping Utility for 32-Bit Windows: Version 9.2.0.1.0 - Production On 15-Oct-2004 12:38:38
Copyright (c) 1997 Oracle Corporation. All Rights Reserved.
Used parameter files: f: /oracle/ora92/neetwork/admin/sqlnet.ora
Used hostname adapter to resolve the aliastempting to contact (desk = *) (service_name = 100)) (pect = tcp) (host = 100))) TNS-12541: TNS: No Listener View the listening of the Server end, LSNRCTL status, the result is normal to view tnsname.ora 100 = (deScription = (address = (protocol = tcp) (host = 192.168.6.100)) (connect_data))) = (Service_name = oracas))))) is completely correct ... ****************************************** *********************************** Or C: /> TNSPING 226
TNS Ping Utility for 32-Bit Windows: Version 9.2.0.1.0 - Production On 15-Oct-2004 12:40:12
Copyright (c) 1997 Oracle Corporation. All Rights Reserved.
Used parameter files: f: /oracle/ora92/neetwork/admin/sqlnet.ora
TNS-03505: failed to resolve name (meaning that there is no 226 in file tnsname.ora) View tnsname.ora226 = (deScription = (address = (protocol = tcp) (host = 192.168.6.226) (port = 1521))))))))) is completely correct ... Finally, the reason why the above two problems should be more than one space in front of TNS. . . . . . Cold, actually this error ... So everyone is confirmed, careful details
