1. I have always heard that PL / SQL Developer is good, I have been useless, but I found no place to configure the database connection after installation, I feel weird, I have heard that I have to install a client, and I have an oracle Net Manager in Oracle Net Manager. The prompt configuration is OK, then enter the PL / SQL Developer is no problem. 2. Pl / Sqldeveloper has an automatic prompt function on the underscore, is not bad:) 3. About PL / SQLDeveloper failure resolution: [Transfer from: http://www.cnblogs.com/xspin/archive/2004/12/13/38423 .html]
After installing ORACLE, change the Windows computer name, causing part of the Oracle third-party tool, such as: PLSQL Developer unconventional, and prompt ORA-12541: TNS: NO Listener or ORA-12547: TNS: Loss Contact and other error messages.
A: From Oracle's error tips, it is to say TNS: no listener, it is estimated that some service is not started, open Windows Management Tools -> Services, one look, there is a service such as OracleraHome90 TNSListener, and error message is consistent, Basically, it is definitely the issue triggered by this service. At another look, the service did not start, and the service was started. After refreshing, the service is actually turned off immediately. Retry N times, the same result. Go to Google Search, I didn't expect this or a universal problem. One of them made a person to open the listener.ora in the installation directory. Such as: D: / Oracle / ORA90 / NETWORK / Admin / Listener.ora. Open the configuration file and found the following configuration information: listener = (description_list = (address_list = (address = (protocol = IPC))) (address_list = (address = (protocol = TCP) (Host = local))))))))) When seeing this row Host = Local, the problem is solved. It turned out that after a few days of installed Oracle, the Windows computer name was changed, and the listening host name recorded in this configuration file was still the original name. This also blame, the OracleraHome90TnsListener service could not start, and immediately modified to the current computer Name, start OracleraHome90TnsListener service successfully, PL / SQL Developer is successfully connected to the Oracle database, and cannot log in to troubleshoot.
Summary: Oracle Comparison emphasizes manual function adjustment, place some configuration information in the configuration file. Unlike SQL Server, almost any information is placed in the registry, of course, this is also in line with Oracle as a spirit of cross-platform database. But for beginners, there is a difficulty, unlike SQL Server, "fool", then solve this problem, almost reinstall Oracle, it seems that there are more Google multi-analyzes, or trial nothing.
