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.