Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve exp export user and object error report ora--12154". In daily operation, I believe that many people have doubts about how to solve the problem of exp export user and object error report ora--12154. The editor consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubt of "how to solve the problem of exp export user and object error ora--12154". Next, please follow the editor to study!

Today, when you go from one exp to another library imp,

The error is as follows

[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 2019Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.IMP-00058: ORACLE error 12154 encounteredORA-12154: TNS:could not resolve the connect identifier specifiedIMP-00000: Import terminated unsuccessfully

After checking, it is found that tnsnames.ora needs to be edited.

Navigate to the directory

[oracle@lzr2 orcl] $cd $ORACLE_ Home [oracle @ lzr2 11.2.0] $lsapex csmig dv j2ee md opmn precomp sqlplus wwgassistants css emcli javavm mesg oracore racg srvm xdkbin ctx EMStage jdbc mgw oraInst.loc rdbms suptoolsccr Cv has jdev network ord relnotes sysmancdata dbs hs jdk nls oui root.sh timingframeworkcfgtoollogs dc_ocm ide jlib oc4j owb scheduler ucpclone deinstall install ldap odbc owm slax uixconfig demo instantclient lib Olap perl sqldeveloper usmcrs diagnostics inventory log OPatch plsql sqlj utl [oracle@lzr2 11.2.0] $cd network/admin [oracle@lzr2 admin] $lslistener.ora samples shrept.lst

Found that this file is not available, create a Local Service Name with netca

[oracle@lzr2 admin] $export DISPLAY=192.168.138.1:0.0 [oracle@lzr2 admin] $netca

After that, imp and exp will not be mistaken.

At this point, the study on "how to solve the problem of exp exporting user and object error ora--12154" is over. I hope to be able to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.