Oracle 10g ORA-12154 TNS: failed to parse the specified connection identifier

Source: Internet
Author: User

Summarize and organize yourself:

1. Check the registry, Oracle_Home under HKey_LocalMachineSoftwareOracle. If not, change it to correct;

2. uninstall ODP. net (or uninstall ODT. net, ODT contains ODP, ODT is. net is an integrated plug-in for connecting to and browsing oracle databases, and provides drag and drop operations on oracle databases, similar to. net for the resource manager of SQL Server );

3. If the ODT for. Net directory still exists, delete or rename the directory;

Restart the system and re-connect the ASP. Net program. If the same error persists, let's take a look. I suggest you reinstall Oracle.

Cause analysis: the system was originally installed with ORACLE 10G 10.1.0, and 10.2.0 was installed before it was restarted. As a result, the listener could not be started, but it still pointed to the location of 10.1.0, the listener cannot be started.

Processing Process:

1. Search for the Registry, point the listener to a new location, restart the service, and OK;

2. PL/SQL DEVELOPER cannot be connected. Other methods are normal. Uninstall ODP for. Net, which was originally installed on another logical disk, and reinstall it to the same location as ORACLE 10.2.0. When the system is restarted, the DEVELOPER still reports an error. However, the error message is blank.

3. After the DEVELOPER settings are changed, go to TOOLS> PREFERENCES... settings. In the CONNECTION under ORACLE, set oracle home and oci libiary to NULL for automatic detection. The connection is normal and the problem is solved.

Related Article

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.