Solution for oracle client PLSQL connection failure

Oracle client PLSQL connection failure solution I wrote in my blog last week that the oracle client is connected to the server http://www.bkjia.com/database/201206/137699.html This article solves the troubles of installing on your own book. Www.2cto.com the original computer and server are in the same LAN, so every time they are remote servers, but remote is not the solution. Because multiple people use the same server, it is extremely inconvenient to use it, install it in your own book and compare the cards. Therefore, the above blog appears. Hey, digress. Let's get down to the truth. Back from home, continue my work, open oracle client PLSQL, ah, suddenly cannot connect. Hey, what's going on? I ran normally a few days ago. I went home for three or four days. Why? When a problem occurs, analyze the error calmly. From the error, you can find that the target host, that is, the client, cannot find the server. First of all, we should understand how the oracle client connects to the server. I have already discussed this in my previous blog. The basic information of the oracle server is obtained through the configuration in the tnsnames. ora file. Now that we understand the principles, we have clarified the source of the problem. Www.2cto.com in tnsnames. [html] <span> # tnsnames. ora Network Configuration File: F: \ quanxianguanliruanjian \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ tnsnames. ora # Generated by Oracle configuration tools. SMS = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = ShortBrain-PC) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sms) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDR ESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1) www.2cto.com (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO ))) </span> generally, the connected host is changed. For example, the ip address of the server and the computer name of the server are changed. In this case, you only need to compare the host and server name or ip address in the file. Another reliable method is: Since you know the location of the error, you can directly change the tnsnames. ora file in the client, copy the tnsnames. ora file from the server, and put it on the client. Therefore, when you encounter problems, analyze them calmly, identify errors, reduce time, and improve efficiency. Author: Liang huanyue