ORA-12154 TNS cannot parse the specified identifier

Source: Internet
Author: User

ORA-12154 TNS cannot parse the specified identifier

Report on using pl/SQL developer to access a remote Linux database in Win
ORA-12154 TNS cannot parse the identifier, but SQLPLUS is normal under Win
C: \> tnsping lin_hjj

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0-Production on 23-FEB-2014 22:56:32

Copyright (c) 1997,201 0, Oracle. All rights reserved.

Used parameter files:
C: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ network \ admin \ sqlnet. ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.171) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = hjj) (INSTANCE_NAME = hjj )))
OK (60 msec)
C: \> sqlplus sys/oracle @ lin_hjj as sysdba

SQL * Plus: Release 11.2.0.1.0 Production on Sun Feb 23 22:56:57 2014

Copyright (c) 1982,201 0, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
And Real Application Testing options
I did not solve the problem after finding it online for a while, because the situations are different.
Suddenly, after the Oracle11g database is created, it cannot be connected using PL/SQL. The host downloads instantclient-basic-win32-11.2.0.1.0.zip ON THE oracleofficial Network (Note: it corresponds to the DB version)
Decompress the package to the instantclient_11_2 directory. Copy the NETWORK/ADMIN under ORACLE_HOME to the unzipped instantclient_11_2 directory.
Then open the Oracle Home Directory (full directory of instantclient_11_2, for example, D: \ instantclient_11_2) in the PL/SQL DEV --> tool --> preference --> left ORACLE --> connection ), the OCI library will automatically detect this vulnerability.
Then perform the test. The connection is successful.

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.