After installing the oracle client, what should I do if I cannot connect to the client using plsql ?, Oracleplsql
After 64-bit oracle is installed and tested with SQL plus, you can successfully connect to the client, but cannot connect with plsql.
1. The test results with SQL plus are as follows:
2. The created instance cannot be found using plsql.
Unable to find the database, and no identity login box, click [Cancel], enter plsql to try to connect to the oracle client
3. log out and log on again. Click OK. An error is displayed:
The general meaning of this error is that the 64-bit database installed cannot be identified by plsql, and a 32-bit database needs to be installed.
4. In order not to uninstall the original 64-bit oracle database, download the compressed file of the 32-bit oracle client. decompress the file and place it in the 64-bit database directory;
5. Reset the link path in plsql (the path of the 32-bit client is now set)
6. Set these three variables in the system variables: The first two are the paths of the decompressed compressed package files;
The third system variable is the system variable added to prevent plsql from garbled Chinese characters (I checked it online and didn't use it any more, but add it, just in case)
7. Restart your computer; log on to plsql; then you can find the TNS of the database:
8. However, an error still occurred while logging on. The original database cannot be found,
8. Later, I re-used the tool provided by oracle to create an instance and log on again to log on to the newly created database instance. I used the statement to query the current time for testing and found that the data can be queried successfully, this is the final solution.
So far, it has finally been completed.