Oracle lead DMP File Ora-12154:tns: Unable to resolve the specified connection identifier solution

The fact that TNS cannot be resolved is a common problem in Oracle operations for two reasons:
(1) Oracle server is not installed (generally not recommended for reloading, because Oracle offload is not completely impossible to reinstall)
(2) TNS is not configured

Now this blog gives a solution:

Now let's test if TNS can ping, the interface of success is as follows

(1) Add the following code to the TNS configuration file for the Oracle installation path

# tnsnames.ora Network Configuration File: d:\Oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora# Generated by Oracle configuration tools.ORCL =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = ORCL)    )  )

Where ORCL is my database name, which needs to be configured as needed

(2) Configuring TNS environment variables
Environment variables are similar to the following:

D:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN

Add: Examples of steps for Oracle database restore are given below
1, the testdb.bmp placed in the Dpdump directory, the following path:
E:\app\Administrator\admin\orcl\dpdump

2. Create user
Create user testdb65 identified by "testdb65" default tablespace users Temporary
Tablespace temp;
User authorization
Grant CONNECT,DBA to testdb65;

3. CREATE TABLE Space
CREATE tablespace nnc_data01 datafile ' D:\tablespace\nnc_data01.dbf ' SIZE 500M
Autoextend on NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K;
CREATE tablespace nnc_index01 datafile ' D:\tablespace\nnc_index01.dbf ' SIZE 100M
Autoextend on
NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K;

4, import BGYHR2 is the source library
IMPDP Testdb65/[email protected] schemas=testdb65 dumpfile=testdb65.dmp
IMPDP Ncjob65/[email protected] schemas=testdb65 dumpfile=testdb65.dmp

Export Scott is the library to export
EXPDP Lfwtrain/[email protected] schemas= Current user dumpfile=expdptest.dmp

Add: The following gives the Plsql developer client connection to remote Oracle with a solution that TNS cannot resolve

See my blog for details: http://blog.csdn.net/u014427391/article/details/56479085

Oracle lead DMP File Ora-12154:tns: Unable to resolve the specified connection identifier solution