Oracle Error 1017
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 company Business Learn
Oracle Error 1017 Encountered Import
more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags imp-00058 oracle error 12154 encountered Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you,
Imp-00058 Oracle Error 12560 Encountered
helping each other. Join them; it only takes a minute: Sign up IMP-00058: ORACLE error 1017 encountered up vote 0 down vote favorite I am using Oracle 11g client 32bit on all my servers and i have imp 00058 imp 00000 import terminated unsuccessfully 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 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. ora-1017 invalid username/password logon denied 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 altered to a new password and re-connected with sqlplus. But cannot import dump –Romit Poladiya Oct 13 '13 at 6:32 add a comment| Did you find this question interesting? Try our newsletter Sign up for our newsletter and get our top new questions delivered to your inbox (see an example). Subscribed! Success! Please click the link in the confirmation email to activate your subscription. up vote 0 down
von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen
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 https://www.experts-exchange.com/questions/22126477/IMP-00058-ORACLE-error-1017-when-trying-to-import-under-a-different-user-than-ORACLE-account-HPUX-platform.html Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > IMP-00058: ORACLE error 1017 when trying to import under a different user than "ORACLE" account (HPUX platform) Want to Advertise Here? Solved IMP-00058: ORACLE error 1017 when trying to import under a different user than "ORACLE" account (HPUX platform) Posted on 2007-01-17 Oracle Database 2 Verified Solutions 21 Comments 12,253 oracle error Views Last Modified: 2008-01-09 Hello. I've always had trouble whenever trying to import into an Oracle 9i DB while logged in as a different user than the local ORACLE account. If I'm "Oracle", I have no problem. But I created a second test database called TESTDB, and created an owner account by the same name. The testdb user is in the DBA group, and is using practically the same environment profile as "oracle". I oracle error 1017 am able to control the DB no problem as "testdb", but if I try to import into it, I get: [/ORACLE_STAGE/TESTDB]: testdb@LACOAPS1$imp system/ocpdba9i file=pipe2 ignore=y show=y fromuser=finprod touser=finprod Import: Release 9.2.0.6.0 - Production on Wed Jan 17 14:34:23 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. IMP-00058: ORACLE error 1017 encountered [/ORACLE_STAGE/TESTDB]:name/password; logon deniedUsername: testdb@LACOAPS1$ I don't think it's a user account problem, because I use the "system" account to log into the testdb database. I also tried it using the "sys" account. Any ideas would be appreciated. Thanks, Damian 0 Question by:Damian_Gardner Facebook Twitter LinkedIn Google LVL 6 Best Solution byPradeepgv03 Ok I understand it is a test database... SO if possible try the following.. sqlplus "system/ocpdba9i as sysdba" ( And for your informatin whatever userid/password you give this will connect). Go to Solution 20 Comments Message Author Comment by:Damian_Gardner2007-01-17 Well, to my surprise, I just got denied as "oracle" too. This is strange. 0 LVL 76 Overall: Level 76 Oracle Database 74 Message Active today Expert Comment by:slightwv (䄆 Netminder)2007-01-17 I'm assuming that ORACLE_SID is set to testdb. Do you have an environment variable set called TWO_TASK? If so, unset it and try again. 0 Message Author Comment by:Damian_Gardner2007-01-17 Hi slightwv. No two_task variable is set. Yes - I double-checked the o