Ora 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 ora-1017 invalid username/password logon denied Learn more about Stack Overflow the company Business Learn more about hiring developers
Ora-01017 Oracle 12c
or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack ora-01017 invalid username/password logon denied 11g 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 1017 encountered up vote
Ora 01017 Invalid Username Password Logon Denied Sap
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 from Oracle and this is my ora-01017 sql developer 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 altered to a new password and re-connected with sqlplus. But cannot import dump –Romit
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type
Ora-28000
your message and try again. More discussions in ODP.NET All PlacesDatabaseDatabase Application DevelopmentWindows and
Ocisessionbegin(oci_default) Failed With Sql Error 1017
.NETODP.NET This discussion is archived 5 Replies Latest reply on May 2, 2014 11:59 PM by jgarry Remotely: Error 1017 username/password; login ora 01017 invalid username password logon denied database link denied. Locally: Login works with username/password d6739753-447c-40ba-a181-df7dbd3679f7 May 2, 2014 10:20 PM First let me explain that the system I am talking about is on a seperate network with no access to the public internet so http://stackoverflow.com/questions/19338354/imp-00058-oracle-error-1017-encountered posting log files and the such will be out of the question, but I can type whatever needed information.I had an Native OLE DB\Microsoft OLE DB Provider for Oracle connection set up in SSIS to pull data from an Oracle 11g database and everything was working fine and then it stopped. Now when I test the connection I get "Test Connection failed because on an error initializing provider. ORA-01017: invalid username/password; login https://community.oracle.com/thread/3555003 denied". I have also tried it with a .Net Provider\OracleClient Data Provider with the same result.The people at the site of the Oracle server tried logging in with my username/password and were able to login. They say it is a problem on my end, even though I did not change anything. I say it is a problem on their end since I am obviously hitting the Oracle server with a 1017 error, but they say they did not change anything.I am not an Oracle person, but this is very strange to me how they are able to login and I am not with the same account information. Not to mention that it was working and now it is not. I imagine that a firewall or port issue would give me a different error. Could a policy have been implimented that put some sort of wrapper on my login information when it is transmitted? The network and policy people are always implimenting thing without our awareness. Given the error and situation, where would be a logicall place to start looking for the problem on my end (A) or theirs (B)? And if it is on B then what do I tell them to look at, the listener.ora file? Does anyone have any direction or suggestions?I ha
GoogleВойтиСкрытые поляПоиск групп или сообщений