Oracle Imp Error 12154
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 imp-00000: import terminated unsuccessfully About 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 imp-00058: oracle error 3135 encountered 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) (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
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
May Be An Data Pump Export Dump File
(c) 2009 Microsoft Corporation. All rights reserved. C:\Users\Administrator>d: D:\>imp Import: Release
Imp-00058 Oracle Error 904 Encountered
10.2.0.1.0 - Production on Mon Oct 24 08:45:48 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. oracle error 12154 Username: tiger Password: IMP-00058: ORACLE error 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 http://dba.stackexchange.com/questions/74365/oracle-error-12154-while-importing-dmp-file - 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 message to a moderator Re: EXP/IMP Fail [message #528259 is a reply to message #528257] Sun, http://www.orafaq.com/forum/t/175836/ 23 October 2011 23:23 BlackSwan Messages: 24960Registered: 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 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: 24960Registered: January 2009 Location: SoCal Senior Member so wh
displayed when users try to start the product or use one of its tools. This appendix gives details of some common error http://download.oracle.com/otn_hosted_doc/designer/des10g_9047/cmnhlp72/rep_insgde/igappc.htm messages. Error Messages for Installation The following table gives details of error http://www.dbforums.com/showthread.php?1630896-import-command-on-Oracle-10g messages that may be displayed during installation of a new repository: Stage CKPREREQ CDR-21244 : This process has been aborted Cause: The previous process has failed or has been terminated. Action: See Information for error CDR-21244 later in this section. IMP-00010: not a valid export file, oracle error header failed verification IMP-00021: operating system error - error code (dec 2, hex 0x2) IMP-00000: Import terminated unsuccessfully Cause: You are using an earlier version of Oracle database Import and Export tools. Action: Make sure you have installed the correct version of the Import and Export tools. You can obtain these by installing the External Dependencies product. Detected imp-00058 oracle error "UNDEFINED" parameter variable(s) Please check the parameter definition(s) for EXECUTE_IMPORT Cause: Oracle database Import and Export tools have not been installed. Action: Rerun the installer and install the External Dependencies product. Stage CKROLGRT RME-02124: Failed to execute SQL statement: grant SELECT on RM_NLS_MESSAGES to CK_ORACLE_REPOS_OWNER ORA-01720: grant option does not exist for '.' Cause: The v$nls_parameters object is a public synonym to the view v_$nls_parameters. So, when you attempt to 'grant select' on the V$ object you will get an 'ORA-2030: can only select from fixed tables/views' error - which means, in turn, the GRANT SELECT on rm_nls_messages fails with an ORA-01720 error. Action: Explicitly grant SELECT on sys.v_$nls_parameters to the repository owner with the grant option. Stage CKGLBWRK RME-02124: Failed to execute SQL statement... against JR_WORKAREA Cause: JR_WORKAREA package is invalid. Action: Explicitly grant SELECT on V_$PARAMETER to the repository owner. Information for error CDR-21244 Error CDR-21244 is a generic message that can be issued for a wide range of reasons during installation, migration or upgrade. If you receive this messag
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 is the Oracle 10g Utilities book; as you are interested in import (and not data pump import), you should pay attention to chapter 19: Original Export and Import. Study what's written in there and you should be able to perform both export and import. If there's still something you don't understand, say so