Oracle Import Error Imp-00058
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-00058 imp-00000 import terminated unsuccessfully about Stack Overflow the company Business Learn more about hiring developers or posting ads
Imp-00058 Oracle Error 12154 Encountered
with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer
Imp-00058 Oracle Error 12560 Encountered
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 a
Oracle Error 12154 Encountered Import
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 an Oracle imp-00058: oracle error 1034 encountered .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\NETWORK\ADMIN oracle oracle-11g-r2 import share|
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project imp-00058 oracle error 12154 encountered 11g and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web imp-00058 oracle error 904 encountered Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP imp 00058 ora 12154 Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm http://dba.stackexchange.com/questions/74365/oracle-error-12154-while-importing-dmp-file mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/fail-to-import-an-export-file-imp00058-ora12154-453453 Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Fail to import an export file imp-00058 , ora-12154 Mujtaba Khan asked Apr 13, 2004 | Replies (3) hi, actually i do an export on Oracle server configure on windows 2000 server rel 9i .Exported user at windows has a seperate table space named Inventory so i create a table space on another machine IBM RS/6000 Oracle9i named Inventory and try to import using these Pa
ORACLE error 1034 encountered [message #423704] Sat, 26 September 2009 23:06 casttree Messages: 83Registered: August 2008 Member When I tried to create user db_test identified by db_test; GRANT UNLIMITED TABLESPACE http://www.orafaq.com/forum/t/150384/ TO db_test; grant dba to db_test; connect db_test/db_test !imp db_test/db_test file = test.dmp https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:1492331695311 full=yes commit=yes buffer= 1000000 log=/home/imp_test.log; select test from dual; In imp_test.log, there is the error. Quote: IMP-00058: ORACLE error 1034 encountered ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory IMP-00005: all allowable logon attempts failed IMP-00000: Import terminated unsuccessfully From some oracle error posts, looks like it is caused by the oracle DB is not up, but I can get the result for the sql before and after the imp , so I am guessing it may just some configuration issue. Also if I run the above SQL in my local host, it works fine. The error I got is only from a test DB. which also imp-00058 oracle error let me think it is caused by different DB configuration. Is there some part I should check ? or any suggestions for this issue. Thanks, [Updated on: Sat, 26 September 2009 23:10]Report message to a moderator Re: IMP Error IMP-00058: ORACLE error 1034 encountered [message #423705 is a reply to message #423704] Sat, 26 September 2009 23:36 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member >From some posts, looks like it is caused by the oracle DB is not up, For some DB. >but I can get the result for the sql before and after the imp , so I am guessing it may just some configuration issue. For other DB >Also if I run the above SQL in my local host, it works fine. For a DB >The error I got is only from a test DB. which also let me think it is caused by different DB configuration. For other DB >Is there some part I should check ? or any suggestions for this issue. Check environment. Post Guidelines clearly state to specify OS name & version & Oracle DB version; which you ignore. Enjoy yo
2007 - 8:21 pm UTC Category: Database � Version: 8.1.6 Whilst you are here, check out some content from the AskTom team: Tips for Migrating, Indexing, and Using Packaged Procedures Latest Followup You Asked Tom, I export a table that has the following constraints: Primary key Unique key Check Why does an import back into the same schema with ignore=y show errors for unique and check constraints but does not show them for primary key constraints that exist also? IMP-00017: following statement failed with ORACLE error 2261: "ALTER TABLE "TABLE1" ADD CONSTRAINT "TABLE1_UK" UNIQUE ("COLUMN2") USING I" "NDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 24576 NEXT 409600 M" "INEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUP" "S 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" ENABLE " IMP-00003: ORACLE error 2261 encountered ORA-02261: such unique or primary key already exists in the table IMP-00017: following statement failed with ORACLE error 2264: "ALTER TABLE "TABLE1" ADD CONSTRAINT "TABLE1_CK" CHECK (column2 > '') ENABL" "E NOVALIDATE" IMP-00003: ORACLE error 2264 encountered ORA-02264: name already used by an existing constraint About to enable constraints... Import terminated successfully with warnings. Just Curious . Thanks Peter and we said... ignore=y changes the behavior of CREATE statements. If the CREATE statement failed - no data would be imported. Ignore=y says "go ahead, import the data anyway". The failure of the ALTERS affects nothing -- the data is already imported by then, so we just "fail" them (but continue on) Reviews Write a Review ignore=y May 23, 2002 - 11:31 am UTC Reviewer: X Wang from NJ USA I use ignore=y option when I import the data. It only ignore CREATE TABLE command, but failed in CREATE TYPE command. IMP-00015: following statement failed because the object already exists: "CREATE TYPE "MYTYPE_T" TIMESTAMP '2002-02-10:16:24:15' OID 'F4CDB776D6771" "1D3AD090008C7E98428' " How can I ignore create type command? Thank you Followup May 23, 2002 - 3:31 pm UTC it didn't fail, it just keeps on going. ops$tkyte@ORA817DEV.US.ORACLE.COM> drop user a cascade; User dropped. ops$tkyte@ORA817DEV.US.ORACLE.COM> ops$tkyte@ORA81