PL/SQL Developer Ora-12154:tns: Unable to resolve the specified connection identifier

Source: Internet
Author: User
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.



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.