Oracle Error 12154 Encountered Import
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 policies of this site About Us Learn more
Imp-00000: Import Terminated Unsuccessfully
about Stack Overflow the company Business Learn more about hiring developers or posting imp-00058 oracle error 12560 encountered ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and imp-00058 oracle error 1034 encountered answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask
Imp-00058: Oracle Error 1950 Encountered
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 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
Imp-00058: Oracle Error 3135 Encountered
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) (SERVICE_NAME = DEV) ) ) PATH Variables I added the following to my PATH (I realize there may be some unnecessary item in there, I just wanted to be on the safe side. ): C:\oracle\product\11.2.0\dbhome\bin;C:\oracle\product\11.2.0\client_1;C:\oracle\product\11.2.0\client_1\bin;%ORACLE_HOME%\bin; I also created two more variables in my System Variables... TNS_ADMIN C:\oracle\product\11.2.0\dbhome\NETWORK\ADMIN TNS_NAMES C:\oracle\product\11.2.0\dbhome\
23:16 oracle@learner Messages: 71Registered: October 2011 Member I am not able to exp/imp .dmp file. Thanks you in advance. Microsoft Windows [Version 6.1.7600] Copyright (c) 2009 Microsoft Corporation. may be an data pump export dump file All rights reserved. C:\Users\Administrator>d: D:\>imp Import: Release 10.2.0.1.0 - Production on Mon
Imp-00058 Oracle Error 904 Encountered
Oct 24 08:45:48 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Username: tiger Password: IMP-00058: ORACLE error imp-00038: could not convert to environment character set's handle 12560 encountered ORA-12560: TNS:protocol adapter error IMP-00000: Import terminated unsuccessfully D:\>imp tiger/tiger@orclimpl full=y ignore=y file=tiger.d mp log=tiger.log fromuser=tiger touser=abc Import: Release 10.2.0.1.0 - Production on Mon Oct 24 09:25:30 2011 http://dba.stackexchange.com/questions/74365/oracle-error-12154-while-importing-dmp-file Copyright (c) 1982, 2005, Oracle. All rights reserved. IMP-00058: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve the connect identifier specified IMP-00000: Import terminated unsuccessfully D:\> Please help me. Report message to a moderator Re: EXP/IMP Fail [message #528259 is a reply to message #528257] Sun, 23 October 2011 23:23 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior http://www.orafaq.com/forum/t/175836/ Member >IMP-00058: ORACLE error 12560 encountered >ORA-12560: TNS:protocol adapter error >IMP-00000: Import terminated unsuccessfully throwing these errors when attempting to connect to local DB indicates OS/Networking/environment is mis-configured. root cause of problem & fix are external to Oracle when did this last work without error? What changed? Report message to a moderator Re: EXP/IMP Fail [message #528260 is a reply to message #528259] Sun, 23 October 2011 23:39 oracle@learner Messages: 71Registered: October 2011 Member Last time , I have changed the workgroup to domain again then Domain to workgroup again. After tha I was not not able to connect database, but with the help from ORAFAQ,Problem was solved. Now this is the new problem for exp and imp. Report message to a moderator Re: EXP/IMP Fail [message #528261 is a reply to message #528260] Sun, 23 October 2011 23:41 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member so why do you keep changing & breaking thing? Report message to a moderator Re: EXP/IMP Fail [message #528265 is a reply to
SonicWALL User Sorry, we are having issues processing your request. If you own the SonicWALL product requested please confirm that you have registered your product at My https://support.software.dell.com/toad-for-oracle/kb/37195 SonicWALL . If you have already registered your product then please contact Customer Service directly for further assistance at customerservice@software.dell.com. Continue × Support Forms Under Maintenance Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience. Continue Search Sign In Sign In Create Support Account Products ActiveRoles oracle error Boomi Change Auditor Foglight Identity Manager KACE Migration Manager Rapid Recovery Recovery Manager SharePlex SonicWALL Spotlight Statistica Toad View all Products Solutions Application & Data Integration Big Data Analytics Business Intelligence Cloud Management Data Protection Overview Backup and Recovery Deduplication and Compression Database Development and Management Database Replication & Backup Endpoint Management Mobile Workforce Management Overview Desktop Virtualization Enterprise Mobility Management Endpoint Security Network imp-00058 oracle error Security Secure Remote Access Performance Monitoring Security Overview Email Security Endpoint Security Identity & Access Management Network Security Secure Remote Access Virtualization Management Microsoft Platform Management View all Solutions Solutions by Platform Active Directory Exchange Google GroupWise & NDS Hadoop Hyper-V Lotus Notes Skype for Business/Lync Office 365 Oracle SharePoint SQL Server VMware Trials Buy Support By Product Line Enterprise Reporter Foglight KACE Migration Manager Migrator NetVault One Identity Quick Connect Performance Analysis Recovery Manager Shareplex SonicWALL Spotlight SQL Navigator Toad All Products Contact Support Download Software Knowledge Base My Account My Products My Service Requests My Licenses My Groups My Profile Policies & Procedures Professional Services Technical Documentation Training & Certification User Forums Video Tutorials Support Home Communities Partners × Email Share your favorite Support content with a friend. Email To Email From Subject Information from Dell Software Support Message You might be interested in the following information For more information regarding support on your Dell Software Product, please visit www.software.dell.com/support Print Email My Downloads () Support Knowledge Base Toad for Oracle Database Import Utility does not connect to the database and stops (37195) × Return Feedback