Exp-00056 Oracle Error 12154 Encountered
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and exp 00056 oracle error 12560 encountered policies of this site About Us Learn more about Stack Overflow the ora 12154 tns could not resolve the connect identifier specified company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges
Exp 00056 Oracle Error 1017 Encountered
Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community.
Exp 00056 Oracle Error 1034 Encountered
Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Oracle error 12154 while importing DMP file up vote 2 down vote favorite My Setup I'm running Windows 7 64-bit, using Oracle DB 11g R2 for Windows 64-bit. I have oracle error 12154 encountered import Oracle SQL Developer Release 3.0 (4.0.2.15.21) as the GUI for my database. Question I followed the instructions from this post on how to import an Oracle .DMP file. I issued this command into the command prompt: C:\>imp sys@dev/password12345 FROMUSER=FOOADMIN TOUSER=FOOADMIN file=c:\fooadmin.dmp full=yes It then prompts me for a password in which I enter the correct one and then I receive this error: IMP-00058: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve the connect identifier specified IMP-00000: Import terminated unsuccessfully Actual Question: How do I fix this error and be able to import the .dmp file successfully? Or what are some steps I can head towards to potentially get this working...? My Files & What I've Done I have looked through countless posts on this same issue. My tnsnames.ora, listener.ora, & sqlnet.ora are located in this directory: C:\oracle\product\11.2.0\dbhome\NETWORK\ADMIN My connection in my tnsnames.ora file looks like this (I have also tried to put my computer name as the HOST, instead of 127.0.0.1)... DEV = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVIC
Post your question and get tips & solutions from a community of 418,548 IT Pros & Developers. It's quick & easy. EXP-00056 ORACLE error 12154 encountered P: 61 osman7king I have tried to export a database, but i got the following message: EXP-00056 ORACLE error 12154 encountered ORA-12154: TNS could not resolve the connect identifier specified but i can access the database successfully and the TNS is correct. Thanks Nov 26 '11 #1 Post Reply Share this Question 3 Replies Expert 100+ P: 699 rski Show the command you use to export http://dba.stackexchange.com/questions/74365/oracle-error-12154-while-importing-dmp-file database. Nov 26 '11 #2 reply P: 61 osman7king dear rski.. I have fixed the problem. there was a '@' charactre in the password of my database, and after I change the password and remove that character from it, the problem has been fixed and the export operation has been done successfully. THANKS. Nov 29 '11 #3 reply P: 1 Andrewpaul Dear osman7king, Oracle 12154 error https://bytes.com/topic/oracle/answers/925029-exp-00056-oracle-error-12154-encountered means TNS could not resolve the connect identifier specified. A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. You can try below instruction There was a '@' character in the password of your database, and after you change the password and remove that character from it, the problem has been fixed and the export operation has been done successfully. For more solution visit, Feb 15 '12 #4 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Similar topics regular exp using exp() inside many nested for loops causing Memory overflow finding underflow/overflow threshold for exp(x) exp exp function help! Opening for IBM/DB2 Content Manager with 2yrs of Exp In Chennai Help needed with reg exp please reg exp help math.exp(complex) reg exp question: removing class and style from html Browse more Oracle Database Questions on Bytes Question stats viewed: 7544 replies: 3 date asked: Nov 26 '11 Follow this discussion BYTES.COM © 2016 Formerly "TheScripts.com
·Proponer ·Temas ·Top 10 ·Trucos ·Tutoriales ·Usuario ·Wiki NickContraseñaNuevo usuario English Proyecto AjpdSoft: Foros AjpdSoft :: Índice Fecha y hora actual: Sab Oct 15, 2016 8:52 am Foros de discusión Ver mensajes sin respuesta Foro http://www.ajpdsoft.com/modules.php?name=Foros&file=viewtopic&t=1081 Último Mensaje Programación Borland Delphi, Codegear Delphi .Net Lenguaje de programación de Codegear. Trucos Delphi, utilidades, solución de errores, dudas. Mar Mar 22, 2016 6:59 pmfiderosado VB.Net, C# .Net, Visual Studio .Net http://www.cnblogs.com/gw811/p/3696346.html Lenguaje de programación de Microsoft: Microsoft Visual Basic 6, Microsoft Visual Basic .Net, Microsoft Visual Studio .Net, Microsoft Visual C# .Net Dom Jun 05, 2016 10:31 amtcubells PHP, CMS, Joomla, WordPress, oracle error Alfresco, Apache, Tomcat, Drupal Lenguaje de programación para servidores Web (PHP Hypertext Pre-processor), para creación de contenido web dinámico. En este foro damos cabida también a los CMS como Joomla!, WordPress, Alfresco, Drupal, PHP-Nuke. También a los servicios web Apache, Tomcat, JBoss. Mie Feb 10, 2016 7:32 amalonsojpd Android, Java, software para smartphones Lenguaje de programación Java para desarrollo de aplicaciones para Android. Desarrollo 00056 oracle error de aplicaciones para smartphones y tablets Sab Ago 15, 2015 8:50 pmalonsojpd Base de Datos Oracle Database, motor de base de datos profesional Base de Datos Oracle (sistema de gestión de base de datos relacional), propiedad de Oracle Corporation. Errores Oracle, copia de seguridad, dudas. Mar Oct 04, 2016 12:16 pmquimby06 MySQL Server, MySQL Client, motor de bd gratuito Base de Datos MySQL Server. Motor de base de datos gratuito y open source. Errores, consultas SQL, dudas sobre MySQL. Sab Jun 25, 2016 8:56 pmCarlos_rrf Microsoft SQL Server, motor de base de datos profesional Microsoft SQL Server. Motor de base de datos profesional de Microsoft. Errores, dudas, consultas, copia de seguridad. Mar Oct 27, 2015 7:27 pmalonsojpd Access, base de datos Microsoft Access (mdb) Microsoft Access (MDB). Base de datos de escritorio de Microsoft. Dudas, errores, consultas, informes, macros. Mie Sep 07, 2016 4:34 pmBalanta Windows Windows 10, Windows 7, Windows Server 2010, W2008, W2003 Sistemas operativos Microsoft Windows, cualquier versión (Windows 3.11, Windows 9x, Windows ME, Windows XP, Windows Vista, Windows 7, Windows 8, Windows 10, Windows Server 2000, 2003, 2008, 2010). Trucos, utilidades, solución a errores. Lun
imgpf/imgpf@orcl file=/prlife/db/USDMP20140428.dmp Export: Release 11.2.0.4.0 - Production on Mon Apr 28 09:53:47 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. EXP-00056: ORACLE error 12154 encounteredORA-12154: TNS:could not resolve the connect identifier specifiedEXP-00000: Export terminated unsuccessfully 查看$ORACLE_HOME/network/admin下的tnsnames.ora 文件,如下所示: ORCL_YZJ = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.132.2.147)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) 于是,执行导出表命令如下,导出æˆåŠŸï¼š [oracle@yingxiang-testServer1 ~]$exp imgpf/imgpf@ORCL_YZJ file=/home/oracle/table_space/USDMP20140428.dmp Export: Release 11.2.0.4.0 - Production on Mon Apr 28 14:54:58 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport done in UTF8 character set and UTF8 NCHAR character setserver uses AL32UTF8 character set (possible charset conversion) About to export specified users .... exporting pre-schema procedural objects and actions posted @ 2014-04-28 14:34 zero516cn 阅读(...) 评论(...) 编辑 æ”¶è— åˆ·æ–°è¯„è®ºåˆ·æ–°é¡µé¢è¿”回顶部 公告 Copyright ©2016 zero516cn