TNS-+无法解析指定的连接标识符启事及处理办法（国外英文资料）.doc

TNS-+无法解析指定的连接标识符原因及处理办法（国外英文资料） 2, PL/SQL DEVELOPER is not a connection, and other methods are normal. Uninstall the ODP from other logical disks to the same location as ORACLE 10.2.0. Restart the system, DEVELOPER or error, but some times error message is empty. Because the DEVELOPER Settings have changed, go to the menu TOOLS... Settings, in the CONNECTION under ORACLE, set the ORACLE HOME and OCI LIBIARY to null to detect automatically. Connection is normal, problem solved. Second, the application is wrong: One of the things thats hard to think of is the cause of ore-12154 When using OracleClient. OracleConnection (I was Oracle 9 I, the other version unknown), if you perform directory is too long or have braces (not inspect what symbol), such as it was the right thing even if your service name, can also cause problems ORA - 12154 TNS: unable to process the service name, when this problem, please also consider this reason. B. do the proper configuration How to configure the tnsname.ora file correctly: The client can be configured using the oracle Net Configuration Assistant or oracle Net Manager graphical Configuration tool on the client machine, which actually modifies the tnsnames.ora file. So we can modify the tnsnames.ora file directly to modify the tnsnames.ora file directly. The location of the file is:... Networkadmintnsnames. Ora (for Windows) ... / network/admin/tnsnames.ora (for Unix) Here, the server named testserver, or , USES a listening port of 1521, and a test network service name (database alias) for the tnsnams.ora file is: Test = (the DESCRIPTION = (ADDRESS_LIST = (PROTOCOL = TCP) (HOST = testserver) (PORT = 1521)) ) (CONNECT_DATA = (service_name= ) ) ) Heres the smiley face. The red content is for the content that needs to be modified according to the actual situation, which explains the following: PROTOCOL: the PROTOCOL that the client communicates with the server is generally TCP, which is generally not changed. HOST: database listeners mac