Oracle Error 12154 Imp
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
Imp-00000: Import Terminated Unsuccessfully
Us Learn more about Stack Overflow the company Business Learn more about hiring imp-00058 oracle error 12560 encountered developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange
Imp-00058 Oracle Error 1034 Encountered
is a question and 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 imp-00058: oracle error 1950 encountered 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 SQL Developer Release 3.0 (4.0.2.15.21) as the GUI for my database. Question I followed imp-00058: oracle error 3135 encountered 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) (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 sa
23:16 oracle@learner Messages: 71Registered: October 2011 Member I am not able to exp/imp .dmp file. Thanks you
May Be An Data Pump Export Dump File
in advance. Microsoft Windows [Version 6.1.7600] Copyright (c) 2009 Microsoft imp-00058 oracle error 904 encountered Corporation. All rights reserved. C:\Users\Administrator>d: D:\>imp Import: Release 10.2.0.1.0 - Production on Mon Oct 24 08:45:48
Imp-00038
2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Username: tiger Password: IMP-00058: ORACLE error 12560 encountered ORA-12560: TNS:protocol adapter error IMP-00000: Import terminated unsuccessfully http://dba.stackexchange.com/questions/74365/oracle-error-12154-while-importing-dmp-file 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 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 http://www.orafaq.com/forum/t/175836/ 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 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
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 about Stack Overflow http://stackoverflow.com/questions/3470205/unable-to-import-dump-using-imp the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of http://www.dbforums.com/showthread.php?1630896-import-command-on-Oracle-10g 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up unable to import dump using “imp” up vote 0 down vote favorite I am trying to import into oracle error oracle using imp command and the output of the command is as below. invincible:/home/invincible# imp Import: Release 10.2.0.1.0 - Production on Thu Aug 12 22:19:00 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Username: n_data Password: IMP-00058: ORACLE error 1034 encountered ORA-01034: ORACLE not available ORA-27123: unable to attach to shared memory segment Linux Error: 13: Permission denied IMP-00005: all allowable logon attempts failed IMP-00000: Import terminated unsuccessfully invincible:/home/invincible# user name imp-00058 oracle error and password are correct(I am able to connect using sqldeveloper). I have granted dba access to n_data. All the environment variables are set (I ran oracle_env.sh before running env ). So what might be the problem? I am running oracle on debian. oracle oracle10g debian oracleclient ora-01034 share|improve this question edited Mar 19 '11 at 0:47 OMG Ponies 199k37361417 asked Aug 12 '10 at 17:06 hnm 27127 I assume the database is on the same host because you haven't specified a tns alias - is ORACLE_SID set correctly? –dpbradley Aug 12 '10 at 17:22 yes, database is on the same host. ORACLE_SID is set to XE. –hnm Aug 12 '10 at 17:26 Can you run sqlplus from the same prompt and log in? If so, can you run select count(*) from all_objects; and what does that query return? –Adam Musch Aug 12 '10 at 17:33 No I am not able to run sqlplus(that is why I am using sqldeveloper) –hnm Aug 12 '10 at 17:38 5 I know you've said that your environment is set up properly, but if you can't run SQL*Plus then something is wrong. Can you post the values for $PATH, $ORACLE_HOME, $ORACLE_SID from the environment from which you're trying to run imp
to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 12 of 12 Thread: import command on Oracle 10g Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 06-03-08,01:11 #1 ashwin_think View Profile View Forum Posts Registered User Join Date Jun 2008 Posts 4 Unanswered: import command on Oracle 10g Hi, I've installed the Oracle 10g Database on Windows 2000 server and now wants to import the database which I'hd taken from another 10g database. But when I try to import the db using following command I'm getting error, - ---------------------------------------------------------------- import MEDAS_IPCL/medas file=E:\medas_ipcl.dmp buffer=200000 full=y commit=y log=medasipclimport.log IGNORE=YES ---------------------------------------------------------------- Error :- SP2-0754: Unknown command beginning "import MEDAS.." I'm not understanding that why this error getting on SQL plus command prompt. Is import command dose not recognize by the SQL plus or oracle 10g ??? Please guide me if I'm doing anything wrong. Thanks. Ashwin. Reply With Quote 06-03-08,01:15 #2 Littlefoot View Profile View Forum Posts Lost Boy Join Date Jan 2004 Location Croatia, Europe Posts 4,090 Provided Answers: 4 IMPORT utility is to be run at operating system prompt, not SQL*Plus. Reply With Quote 06-03-08,01:56 #3 ashwin_think View Profile View Forum Posts Registered User Join Date Jun 2008 Posts 4 Could you Plz. let me know what's the exact procedure for it? As from which login I've to do this and in which directory. Whenever I want to login from the DB username/password it won't allow me to login. I always have to login by system user. Will it upload the db at right database or will it create new db from the upload db name ? Plz. help me.... BTW Thanks. for the prompt reply. Ashwin. Reply With Quote 06-03-08,03:16 #4 Littlefoot View Profile View Forum Posts Lost Boy Join Date Jan 2004 Location Croatia, Europe Posts 4,090 Provided Answers: 4 This