Background:
On this machine (
Win7 64-bit flagship edition ), install the Oracle 11g Client (
32-bit Oracle client installed, if the 64-bit Oracle client is installed, in the cmd command, enter Sqlplus/nolog command is unrecognized, that is, unrecognized), and after setting the appropriate local service, use PL/SQL developer to prompt the following error:
"
Could not Load" ... \bin\oci.dll"" This error, 64-bit win7 with PL/SQL, often meet "Could not load" ... \bin\oci.dll "" This error, I checked the information, The reason is that PL/SQL supports only 32-bit OS, and the workaround is to load an additional Oci.dll file.
Workaround: Link
After correcting the error one, the following error is also indicated:
Ora-12154:tns: Unable to resolve the specified connection identifier
Workaround:
Enter the main interface of the PL SQL developer, select Cancel on the login screen without logging into the main interface, then select Menu Tools (Tools)-preferences (preferences), in the Settings window, select Oracle-connection (Connect), In the corresponding Settings window, locate the Oracle Home (Oracle home directory), select the version of the client you installed locally (for example), save the settings, and then restart Plsql Developer, then you can log in normally.