Oracle Imp-00058 Error
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 imp-00058 imp-00000 import terminated unsuccessfully About Us Learn more about Stack Overflow the company Business Learn more
Imp-00058 Oracle Error 12154 Encountered
about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss imp-00058 oracle error 12560 encountered Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up IMP-00058: ORACLE error
Imp 00058 Oracle Error 1034 Encountered
1017 encountered up vote 0 down vote favorite I am using Oracle 11g client 32bit on all my servers and i have proceeded with all the dump imports the very same way I am doing here. Firstly I create the user with default tablespace Secondly I alter the user quota unlimited on tablespace Thirdly I grant connect resource dba to the user. Then I exit imp 00058 ora 12154 from Oracle and this is my import command C:\Users\romit.poladiya>imp fajbdummy/fa@dmate file='E:\dump\fajblatest.dmp' full=Y; I have always been doing this and I do not know why I have not been able to import this time. Please assist. Let me know if you require any more information Thanking the team in advance, Romit importerror share|improve this question asked Oct 12 '13 at 19:34 Romit Poladiya 111 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote ORA-01017: invalid username/password; logon denied Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username/password. Cure: Use the correct username & password. Check the system to make sure that the username exists, and set the password if necessary. share|improve this answer answered Oct 12 '13 at 19:39 user1864610 I have already verified all the mentioned above. I can connect the newly created user through sqlplus. I have verified the user name from select username from dba_users and also
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 about Stack Overflow the company Business Learn
Imp-00058 Oracle Error 1950 Encountered
more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges
Imp-00058: Oracle Error 904 Encountered
Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database imp-00058: oracle error 3135 encountered 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 question Anybody can answer The best answers are voted up and rise to http://stackoverflow.com/questions/19338354/imp-00058-oracle-error-1017-encountered the top Oracle 10g dump file into Oracle 11g database up vote 2 down vote favorite I went through this link for my answer to the same question. I was not sure if i could continue in the same link, so created a new question. Oracle 10g dump file push into Oracle 11g database Sorry if I am wrong. When I used imp with the following parameters: file=my.dmp log=my.log fromuser=myuser touser=myuser statistics=none, ignore=y, full=y I got the http://dba.stackexchange.com/questions/34468/oracle-10g-dump-file-into-oracle-11g-database following errors: IMP-00058: ORACLE error 12560 encountered ORA-12560: TNS:protocol adapter error IMP-00000: Import terminated unsuccessfully Also this error message was there the procedure entry point longjmp could not be located in the dynamic link library ORAUTS.DLL The database and devsuite home are installed on Windows in two different drives. I found some references saying I should run the datapump import commands from the 11g home, with this: set ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_1 set ORACLE_SID=ORCL11R1 I am new to this Oracle database. Should this command be run in command prompt, since the installation is done on Windows, is it "set ORACLE_HOME"? Any suggestion on this would be welcomed. oracle import export datapump share|improve this question edited Aug 12 '14 at 13:03 Colin 't Hart 5,02082131 asked Feb 9 '13 at 11:14 lakshminarayan 1112 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote That error is most likely due to incorrect environment settings indeed, probably your PATH is mixed up too. In a command prompt, assuming that your Oracle 11g home is indeed as you posted above, run: set ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_1 set ORACLE_SID=ORCL11R1 set PATH=%ORACLE_HOME%\bin;%PATH% Make sure you can connect with sqlplus, then start imp. (Do consider using the expdp/impdp Data pump tools instead though. imp/exp are essentially deprecated in 11g.) share|improve this answer answered Feb 9 '13 at 11:53 Mat 6,57622234 add a comment| Your Answer draft
Robert Jackson | 7 Comments UPDATE: Although these IMP-00058 errors were encountered when using a 10g http://www.ora00600.com/wordpress/scripts/exportimport/imp-00058/ and 9i client, I believe that it can also apply to other versions of Oracle where there is a mismatch between the client utilities when exporting and importing IMP-00058: ORACLE error 6550 encountered ORA-06550: line 1, column 33: PLS-00302: component ‘SET_NO_OUTLINES' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored IMP-00000: Import terminated unsuccessfully This error was oracle error encountered when exporting from a 9i database using a 10g client, and then importing into a 9i databse using the 10g client. I had to export and import using the 9i client in the end. Setting the Correct Path If you are using Windows, type PATH at the command prompt and see what the values are set to. There 00058 oracle error will most likely be multiple Oracle paths in there. For example, D:\Oracle\Ora92 and D:\Oracle\product\10.2.0\db_1, for a 9i client and a 10g one. The one which appears first will take priority over the others. You can modify which appears first on your command prompt session by copying out the path to a text file, re-arranging it so that either the 9i or 10g one appears first and then copying it back into your command prompt window, with a PATH=D:\Oracle\Ora92…..etc, etc. Making it Permanent You can also modify this parameter for the environment permanently, with the following: Click START -> right click My Computer -> Properties -> Advanced System Settings -> Environment Variables In the "System Variables" box at the bottom there is a PATH variable Click "Edit" and then change the order for which Oracle Home appears first in the list The main image of this post should help you see where you go to when changing the Windows PATH environment variable. Being Explicit If you are still unsure, you can also specify the full path whenever you invoke SQLPlus o