今天从一个exp到另一个库imp的时候
报错如下
[oracle@lzr2 orcl]$ imp system/tf@orcl fromuser=hr touser=hr file=/u01/hr.dmp ignore=y; Import: Release 11.2.0.4.0 - Production on Fri Feb 15 21:15:23 2019 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. IMP-00058: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve the connect identifier specified IMP-00000: Import terminated unsuccessfully
查阅之后发现是tnsnames.ora需要编辑一下
定位到目录
[oracle@lzr2 orcl]$ cd $ORACLE_HOME [oracle@lzr2 11.2.0]$ ls apex csmig dv j2ee md opmn precomp sqlplus wwg assistants css emcli javavm mesg oracore racg srvm xdk bin ctx EMStage jdbc mgw oraInst.loc rdbms suptools ccr cv has jdev network ord relnotes sysman cdata dbs hs jdk nls oui root.sh timingframework cfgtoollogs dc_ocm ide jlib oc4j owb scheduler ucp clone deinstall install ldap odbc owm slax uix config demo instantclient lib olap perl sqldeveloper usm crs diagnostics inventory log OPatch plsql sqlj utl [oracle@lzr2 11.2.0]$ cd network/admin [oracle@lzr2 admin]$ ls listener.ora samples shrept.lst
发现没有这个文件,用netca创建一个Local Service Name
[oracle@lzr2 admin]$ export DISPLAY=192.168.138.1:0.0 [oracle@lzr2 admin]$ netca
之后再执行imp和exp就不会报错了
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31060213/viewspace-2636101/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31060213/viewspace-2636101/