Solve PL/SQL Dev connection to Oracle a blank prompt box appears, ploracle

Solve PL/SQL Dev connection to Oracle a blank prompt box appears, ploracle

The first time Oracle was installed, it was installed in a virtual machine. When PL/SQL Dev was used to connect to a remote database, a blank prompt box pops up. After a long time of searching online, there were many solutions, but it cannot solve this problem.

No way, you can only study it on your own. After about a day, do it well and write a summary.

 

There are several solutions to this problem:

 

1. Insufficient permissions. A prompt box is displayed. (Link directly)

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

Right-click the PL/SQL icon and choose Properties> compatibility> administrator to run the program.

 

2. environment variables are not set correctly.

 

① Search for the following files on the machine where the oracle server is installed, oci. dllocijdbc10.dll (10 represents the oracle version. If it is another version, you need to modify it, for example, change it to ocijdbc9.dll or ocijdbc11.dll) ociw32.dllorannzsbb10. dll (10 indicates the version of the oracle server. If it is another version, you need to modify it, for example, orannzsbb9.dll or orannzsbb11.dll) oraocci10.dll (10 indicates the version of the oracle server. If it is another version, you need to modify it, for example, oraocci9.dll or oraocci11.dll) oraociei10.dll (the server may not exist. If not, you do not need to find it) sqlnet. ora, tnsnames. ora, classes12.jar, and ojdbc14.jar copy these files to a folder, such as your lient. User Machine. For example, if the placement path is D: \ clientlient ②, configure tnsnames. ora and modify the database connection string. Oracledata = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.58) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = oracledata) where, oracledata is the 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 and the value is tnsnames. the path of the ora file (for example, D: \ your lient, especially after reinstallation or other operations, if you forget the TNS_ADMIN variable, the connection identifier cannot be parsed when you log on to plsql ), this is to find the tnsnames mentioned above. ora. This step is the most important. Add the second environment variable (optional): "NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK". (AMERICAN_AMERICA.US7ASCII is of the ASCII encoding type. For other types, go to the server and check it online) (This step is currently correct. If the encoding is incorrect, garbled characters are generated.) ④ download and install PL  SQLDeveloper configuration application: Open PL  SQLDeveloper, click Cancel on the logon page. On the menu bar, choose tools> preferences> connection settings: Oracle Home = D: \ oracleclientOCI library = D: \ oracleclient \ oci. dll ⑤ If you enable plsql again, you can log on to the database by entering the username and password with the oracledata option.

These System variables are very important. If the settings are incorrect, PL/SQL cannot read "Database" or "connection ".

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

 

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

 

Modify Time Zone

Files required (the first half may vary depending on the path of your installation ):
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 operations:
A: Open the two emd. properties files, locate the last line of the file, and find that agentTZRegion = GMT
B: Open the supportedtzs. lst file, find the time zone you want to locate, and then select the parameter,
For example, agentTZRegion = Asia/Shanghai

 

4. [disable the firewall for testing]

5. If the listener service cannot be started, you need to enable the Net Configuration Assistant or create a new listener service.

 

I tried all the methods above, but I still encountered a blank window prompt, which really hurts .. Finally, it may be because the file in the clientlient is incomplete, which is usually caused by incomplete files or incorrect versions.

Decompress the file.

Overwrite the clientlient file, connect again, and finally succeed! Yeah ~ Hope to help all the friends who encounter problems ~

PL/SQL developer cannot be connected. A blank dialog box is displayed. How can this problem be solved?

Find your installation directory, right-click plsqldev.exe, select Properties-compatibility =, and check [run this Program as an administrator] do not install Windows 7 in the Program Files (x86) Directory during installation.
 
Why is a blank prompt box displayed when you log on to PL/SQL?

You can first check your system environment variables and find the oracle configuration in path. my options are: E: \ oracle \ product \ 10.2.0 \ db_1 \ bin; after that, check to see if you have manually configured a system environment variable ORACLE_HOME (previously installed with the command line (previously configured with oracle_home manually), and delete and save the oracle_home system variable. Then restart pl/SQL to enter normally.