Oracle Client Plsql Connection failure resolution _oracle

Last week, the blog wrote the Oracle Client Connection server article to solve the problem of installing on their own laptop.

The original computer and server in a local area network, so each time is a remote server, but the remote is not the solution Kazakhstan, because many people use the same server, so the use of extremely inconvenient, installed on their own books, and compare cards. That's why the top blog appears. Xi hee, digression. Anyway

Back from home, continue my work, open Oracle client Plsql, ah, suddenly not connected.

Yi, this is what is going on, the last few days running normal miles, home three or four days, how did it?

Encounter problems, calmly analyze their errors, from the error, you can tell that the target host, that is, the client could not find the server.

First we should understand how our Oracle clients are connected to the server, the previous blog, has been introduced. The basic information of the Oracle server is obtained through the configuration in the Tnsnames.ora file. Now that we understand the principle, we have identified the source of the problem.

In the Tnsnames.ora file

# 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 = (ADD Ress_list = (Address = (PROTOCOL = IPC) (KEY = EXTPROC1))) (Connect_data = (SID = plsextproc) (presentation = RO))

Typically, the connected host host changes. For example, the server's IP, the server's computer name changed.

At this point the solution, as long as the comparison file host and server name or IP can.

Another reliable method is: Now that you know the wrong positioning, then directly change the client Tnsnames.ora file, copy the Tnsnames.ora file from the server, put the client.

Therefore: encounter problems, calm analysis, clear positioning errors, reduce time, improve efficiency.