Home » Infrastructure » Windows » ODP Method OpenWithNewPassword not working (ODP 12c Release 4 on Microsoft Windows 10 Professional)
ODP Method OpenWithNewPassword not working [message #659918] Fri, 03 February 2017 15:23 Go to next message
mabelair
Messages: 4
Registered: February 2017
Junior Member
I am trying to change an Expired Oracle password using the ODP.Net method OpenWithNewPassword in C# under Visual Studio 2015. I have created a connection string where I supply the current Password in Password= and when I execute the OracleConnection.Open() method I catch the "Password has Expired!" exception and then try to run the OpenWithNewPassword method supplying the new password as the only parameter. Even though I know that the OracleConnection is in the Closed state and the existing password is correct, I always get "ORA-01017: invalid username/password; login denied". I'm assuming that error is referring to the existing password being incorrect. Anyone have any ideas what's up?

Thanks,

Mike
Re: ODP Method OpenWithNewPassword not working [message #659919 is a reply to message #659918] Fri, 03 February 2017 15:54 Go to previous messageGo to next message
BlackSwan
Messages: 25751
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

ORA-01017 says what it means & means what it says.
I have never seen where ORA-01017 was incorrectly thrown.

Starting with V11, Oracle passwords are CaSeSenSitiVe
Re: ODP Method OpenWithNewPassword not working [message #659920 is a reply to message #659918] Sat, 04 February 2017 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 65256
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I'm assuming that error is referring to the existing password being incorrect.
Or account name.

Re: ODP Method OpenWithNewPassword not working [message #659921 is a reply to message #659920] Sat, 04 February 2017 09:10 Go to previous messageGo to next message
Littlefoot
Messages: 21268
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Mind letter case; passWORD <> password.

[EDIT] Ah, sorry, BlackSwan, I'm repeating what you've already said.

[Updated on: Sat, 04 February 2017 16:32]

Report message to a moderator

Re: ODP Method OpenWithNewPassword not working [message #659936 is a reply to message #659921] Sun, 05 February 2017 20:20 Go to previous messageGo to next message
mabelair
Messages: 4
Registered: February 2017
Junior Member
Say what you want, but I can use the exact same Connection string to connect and run multiple queries without issue (if I have my DBA unexpired my account). Once I have the DBA mark the account as Expired I use the exact same connection string ( complete with hard-coded username and password - same as before that worked) and I catch the exception that tells me that my password has expired and then, without fail, I get the ORA-01017 when I issue the OpenWithNewPassword method. I'm 99.99999999999999% sure this is a bug. Have any of you actually run this method in Visual C# on an account that is expired???????

Thanks,

Mike
Re: ODP Method OpenWithNewPassword not working [message #659937 is a reply to message #659936] Sun, 05 February 2017 21:51 Go to previous messageGo to next message
BlackSwan
Messages: 25751
Registered: January 2009
Location: SoCal
Senior Member
mabelair wrote on Sun, 05 February 2017 18:20

I'm 99.99999999999999% sure this is a bug.

So proceed to submit Bug Report, because nobody here can change how Oracle responds for you.
Re: ODP Method OpenWithNewPassword not working [message #659938 is a reply to message #659937] Sun, 05 February 2017 21:55 Go to previous messageGo to next message
mabelair
Messages: 4
Registered: February 2017
Junior Member
Ok, I will! I was just hoping that someone might have tried this or would be willing to.

Thanks,

Mike
Re: ODP Method OpenWithNewPassword not working [message #659939 is a reply to message #659938] Sun, 05 February 2017 22:23 Go to previous messageGo to next message
BlackSwan
Messages: 25751
Registered: January 2009
Location: SoCal
Senior Member
BTW - We have NO idea what version or Edition of Oracle DB that you have.
It may be a bug that is already fixed in a later version.

Thanks for not reading the Posting Guidelines or ignoring them.
Re: ODP Method OpenWithNewPassword not working [message #659940 is a reply to message #659939] Sun, 05 February 2017 22:50 Go to previous message
mabelair
Messages: 4
Registered: February 2017
Junior Member
BlackSwan,

Sorry, I am using the latest version of the ODP.NET library for C#.Net, 12c Release 4. I am running the Community version of Visual Studio 2015 with all current patches applied. My version of Windows is 10 professional Anniversary addition with all current patches applied. I have tried the same call in the last 4 versions of the ODP.Net library with the same results. The database I am connecting to is an Oracle 12c database with all current patches applied. I am asking if any of you have tried this call with an expired account and had it work anywhere on any version at any time. If so I'd love to know the version of the library you are using.

Thanks,

Mike
Previous Topic: Upgrading XP to Win 7
Next Topic: Error in writing to directory
Goto Forum:
  


Current Time: Mon Dec 18 01:29:06 CST 2017

Total time taken to generate the page: 0.04719 seconds