Pl/sql Dev Connect Oracle pop-up blank prompt box solution sharing _oracle

No way, only their own research, after about a day, or do a good job, write a summary.

There are probably several solutions for this problem:

1. Insufficient permissions, resulting in pop-up empty bar prompt box. (directly on the link)

Http://jingyan.baidu.com/article/066074d6760959c3c21cb0d6.html

Right-click on the Pl/sql icon---properties---compatibility--Administrator to run this program on the hook, you can

2. Environment variables are not set right.

① searches the following files on the machine where the Oracle server is installed, Oci.dllocijdbc10.dll (of which 10 represents the Oracle version, and for other versions, it needs to be modified, for example, to Ocijdbc9.dll or Ocijdbc11.dll) Ociw32.dllorannzsbb10.dll (of which 10 represents Oracle Clothing Version of the service, if the other version, you need to modify, For example, change to Orannzsbb9.dll or Orannzsbb11.dll) Oraocci10.dll (where 10 represents the Oracle Server version and, in other versions, it needs to be modified, such as Oraocci9.dll or Oraocci11.dll) Oraocie I10.dll (Perhaps the server is not, if not, do not have to find) sqlnet.ora,tnsnames.ora,classes12.jar,ojdbc14.jar  to copy these found files to a folder, such as Oraclient , copy this folder to the client machine. If the placement path is D:\oraclient ② configuration Tnsnames.ora, modify the database connection string.  oracledata =     (DESCRIPTION =             (address_list =                (address = (PROTOCOL = TCP) (HOST = 192.168.0.58) (PORT = 1521)  &nbsp ;          )               (Connect_data =   &nbs P           (service_name = oracledata)               &NBSP ;      )   which, Oracledata isThe service name to be connected; HOST = 192.168.0.58 is the server IP address; port = 1521 is the port number.  ③ Add the first environment variable, named Tns_admin, with the value tnsnames.ora the path of the file (such as: D:\oraclient, especially after reloading or other operations, forgetting the tns_admin variable, Plsql login will report the specified connection identifier cannot be resolved, in order to be able to   find the Tnsnames.ora mentioned above. This is the most important step.   Add a second environment variable (optional): "Nls_lang = simplified Chinese_china. ZHS16GBK ", (American_america. US7ASCII is an ASCII encoding type, other types can go to the server to look at it or find it online (this step to do right, if the code is wrong, will produce garbled)  ④ download and install pl sql  Developer Configuration Application: Open pl sql developer, Login interface point Cancel, enter after the menu bar tools->preferences->connection settings: Oracle home=d : \oracleclientoci Library=d:\oracleclient\oci.dll ⑤ Open again plsql will have the Oracledata option in the database enter user name password can login.  

These system variables are important and, if set incorrectly, Pl/sql reads "Database" and "Connect as".

Reference: http://www.linuxidc.com/Linux/2014-01/94787.htm

3. Change time zone (see more in green version Oracle or PL/SQL)

Modify Time Zone

Required files (the first half of the road strength may be different, whichever is the installation path):
A:d:\oracle\product\10.2.0\db_1\wjlmgqs-pc_wjlmgqs\sysman\config\emd.properties
B:d:\oracle\product\10.2.0\db_1\sysman\config\emd.properties
C:d:\oracle\product\10.2.0\db_1\sysman\admin\supportedtzs.lst

Specific actions:
A: Open two emd.properties files, navigate to the last line of the file, and discover AGENTTZREGION=GMT
B: Open the Supportedtzs.lst file, locate your own time zone and select the parameters,
such as: Agenttzregion=asia/shanghai

4.windows firewall due to [shutdown Firewall test]

5. It may also be that the listener service fails to start, so you need to open the net Configuration Assistant repair, or create a new listener service.

I have tried all the above methods, but still encountered a blank window, it is really egg pain. Finally think, may be oraclient inside the file is not complete, usually should be incomplete or incorrect version of the result.

Results according to another online method [in fact the same method ②, but to the Oracle online download of the thin client file Instantclient-basic-nt-11.2.0.4.0.zip], I put the extracted files

Overwrite to oraclient file, connect again, finally succeed! Yes, oh, hope to help all the friends who have problems ~