Oracle Error 1034 Encountered Imp
Contents |
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 the imp-00058 imp-00000 import terminated unsuccessfully company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions
Imp-00058 Oracle Error 12560 Encountered
Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million imp-00058 oracle error 12154 encountered 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 using imp
Imp-00058 Oracle Error 12154 Encountered 11g
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 and password are correct(I oracle error 12154 encountered import 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? –dpbradley Aug 12 '10 at 18:02 | s
1034 If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before
Imp Command In Oracle
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 8 of 8 Thread: ora 1034 Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-28-2003,09:58 http://stackoverflow.com/questions/3470205/unable-to-import-dump-using-imp AM #1 lgaorcl View Profile View Forum Posts Senior Member Join Date Jun 2000 Posts 315 ora 1034 A user name has set up on a unix system and also in the database. I need the import utility. I set ORACLE_HOME and imp in the .cshrc file. But after I type 'imp', and type username and password, I got error http://www.dbasupport.com/forums/showthread.php?36501-ora-1034 message 'IMP-00058: ORACLE error 1034 encountered ...'. Could anyone tell me what is the problem? Thanks, Lisa Reply With Quote 05-28-2003,10:05 AM #2 jovery View Profile View Forum Posts Visit Homepage Ha Ha Join Date Jan 2002 Location Up s**t creek Posts 1,525 Is the database started? Also is the OS user a member of a group that can access the Oracle instance? HTH Jim Oracle Certified Professional "Build your reputation by helping other people build theirs." "Sarcasm may be the lowest form of wit but its still funny" Click HERE to vist my website! Reply With Quote 05-28-2003,10:18 AM #3 lgaorcl View Profile View Forum Posts Senior Member Join Date Jun 2000 Posts 315 yes, database is up and running. What group the user has to be to access the instance? Reply With Quote 05-28-2003,01:58 PM #4 lgaorcl View Profile View Forum Posts Senior Member Join Date Jun 2000 Posts 315 Can anybody help me with this? Which group the OS user has to be in to access the import and export utility? Thanks, Lisa Reply Wi
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't https://community.oracle.com/community/developer/search.jspa?q=IMP-00005 have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without https://www.experts-exchange.com/questions/22100745/i-am-trying-to-export.html it enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle oracle error University TrainingOracle VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results imp-00058 oracle error by: PlacesSubspace depthSubspace depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJiv
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > i am trying to export Want to Advertise Here? Solved i am trying to export Posted on 2006-12-21 Oracle Database 1 Verified Solution 26 Comments 5,891 Views Last Modified: 2012-05-05 i have a user named scott and there is only one table named tab1 i want to export i say what i did C:\Documents and Settings\Administrator>imp scott/tiger Import: Release 10.2.0.1.0 - Production on Sat Jan 21 09:50:29 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc tion With the Partitioning, OLAP and Data Mining options Import file: EXPDAT.DMP > IMP-00002: failed to open EXPDAT.DMP for read Import file: EXPDAT.DMP > y IMP-00002: failed to open y.DMP for read Import file: EXPDAT.DMP > C:\method1 IMP-00002: failed to open C:\method1.DMP for read Import file: EXPDAT.DMP > tab1 what should i give what is going wrong... 0 Question by:dbaseek Facebook Twitter LinkedIn Google LVL 8 Best Solution bysapnam The error is encountered because the export was done by an Oracle user with role DBA and the import is being done by an user who does not have role DBA. Two ways of doing this 1. Grant DBA privileges Go to Solution 26 Comments Message Author Comment by:dbaseek2006-12-21 Thanks in advance 0 LVL 142 Overall: Level 142 Oracle Database 38 Message Active today Expert Comment by:Guy Hengel [angelIII / a3]2006-12-21 >and there is only one table named tab1 i want to export then you need to use EXP and not IMP exp scott/tiger file=C:\scott.dmp 0 LVL 142 Overall: Level 142 Oracle Database 38 Message Active today Expert Comment by:Guy Hengel [angelIII / a3]2006-12-21 >and there is only one table named tab1 i want to export and more precisely: exp scott/tiger file=C:\scott.dmp tables=(tab1) 0 Message Author Comment by:dbaseek2006-12-21 thanks for that now I have another database named orcl and have user named scott i want to import the exported table tab1 to that db How it is possible? 0 LVL 34 Overall: Level 34 Oracle Database 34 Message Active 6 days ago Expert Comment by:markgeer2006-12-21 You copy the file "scott.dmp" to the other server, then run import there, like this: imp scott/tiger file=[drive and path]scott.dm