Troubleshoot PL/SQL Dev connection Oracle popup blank Prompt box

The first time to install Oracle, installed in the virtual machine, with PL/SQL dev connection to the remote database is always pop-up blank prompt box, online search for a long time, the solution is also a lot, but there is no way to solve my situation.

No way, can only study, after about a day, or well done, write a summary.

There are several possible solutions to this problem:

1. Insufficient permissions, resulting in a popup empty bar prompt box. (directly on the link)

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

On the PL/SQL icon, right-click---properties---compatibility--run this program as an administrator.

2. The environment variable is not set.

① search for the following files on the machine where the Oracle server is installed, Oci.dllocijdbc10.dll (where 10 represents the Oracle version, and if other versions are modified, for example to Ocijdbc9.dll or Ocijdbc11.dll) Ociw32.dllorannzsbb10.dll (where 10 represents Oracle Version of the service, if it is a different version, you need to modify it, For example, change to Orannzsbb9.dll or Orannzsbb11.dll) Oraocci10.dll (where 10 represents the Oracle server version and, if other versions, it needs to be modified, for example, to Oraocci9.dll or Oraocci11.dll) Oraocie I10.dll (may not be the server, if not, do not need to find) sqlnet.ora,tnsnames.ora,classes12.jar,ojdbc14.jar  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 ;      )   where Oracledata isThe name of the service to connect to; HOST = 192.168.0.58, which is the server IP address; port = 1521 is the port number.  ③ adds the first environment variable, named Tns_admin, with the value tnsnames.ora the path to the file (for example, D:\oraclient, especially after reloading or other operations, forgetting the tns_admin variable, Plsql login will be reported cannot parse the specified connection identifier), this is to be able to   find the above said Tnsnames.ora. This is the most important step.  Add a second environment variable (optional):"Nls_lang = simplified Chinese_china. ZHS16GBK ", (American_america. US7ASCII is the ASCII encoding type, other types can go to the server to look at or online look up (this step temporarily to do, if the encoding is not correct, will be garbled) ④ download and install PL SQLDeveloper Configuration app: Open PL SQLDeveloper, Login interface point Cancel, enter after select Menu bar tools->preferences->connection settings: Oracle home=d:\oracleclientoci library=d:\ Oracleclient\oci.dll⑤ Open again plsql will be in the database in the Oracledata option to enter the user name password can be logged in.

These system variables are important, and PL/SQL cannot read "database" and "Connect as" if the settings are not correct.

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

3. Modify the time zone (mostly in the green version of Oracle or PL/SQL)

Modify Time Zone

Required files (the first half of the road may be different, with its own installation path whichever):
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 operation:
A: Open two emd.properties files, navigate to the last line of file, discover AGENTTZREGION=GMT
B: Open the Supportedtzs.lst file, locate your own time zone in it, then select the parameters,
such as: Agenttzregion=asia/shanghai

Firewall caused by 4.windows [firewall test can be turned off]

5. It is also possible that the listener service cannot 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 encounter the hint blank window, it is really egg pain. In the end, it may be that the files in the oraclient are not complete, usually should be incomplete or the version is wrong.

Results according to another method on the Internet [in fact, the same method ②, but to the Oracle official website to download a streamlined client file Instantclient-basic-nt-11.2.0.4.0.zip], I put the extracted files

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