TOAD appears to know when an Oracle password is about to expire and
generages a message saying - Your password has expired.
I define a new password and verification it, but i have a message
ORA-01017: invalid username/password; logon denied
How i can to change the password in Toad?
I have the same issue
test case :
- as SYS in sqlplus
alter user scott identified by tiger password expire account unlock;
-
logon in Toad (12.1) with scott/tiger
-
Toad display “your password has expired”
New password : lion
Verification : lion
- ORA-1017 Invalid username/password; logon denied.
[EDIT]
it also reproduces in sqlplus when connecting from 11.2.0.3 client to 11.2.0.2 database
Does you DBA have password verification function defined - which would not allow using the same password again (and many other checks by default plus whatever they add). Also for first post - are you using Oracle 11g? If so ask your DBA what the password settings are for case sensitiivy which can cause lots of issues. In old days passwords were not case sensitive and easy to use. With case sensitive you could run into that error if you use different case than what it is stored as.
thanks bert , I have found the bug and I will open an SR by oracle support
test case :
SQL> select version from v$instance;
VERSION
11.2.0.2.0
SQL> alter user scott identified by tiger account unlock password expire;
User altered.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ sqlplus -v
SQL*Plus: Release 11.2.0.3.0 Production
$ sqlplus scott/tiger@db11202
SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 15 17:05:40 2013
Copyright © 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-28001: the password has expired
Changing password for scott
New password:
Retype new password:
ERROR:
ORA-01017: invalid username/password; logon denied
Password unchanged
Regards
Laurent
This behavior is documented in note 10362008.8 :
The fix should be applied on both client and server, so although it is included
in the 11.2.0.3 client, it also needs to be applied to the pre-11.2.0.3 database.
Thanks for the follow-up explanation. This is a perfect example of why it’s always best to be on the terminal release of the database (e.g. 11.2.0.3) – and
why the toad toad advisor (main menu->help-> toad advisor) checks for and advices being on the terminal release.
From: laurentc.schneider_609 [mailto:bounce-laurentcschneider_609@toadworld.com]
Sent: Friday, August 16, 2013 7:14 AM
Subject: RE: [Toad for Oracle - Discussion Forum] TOAD - Oracle Password is expire
RE: TOAD - Oracle Password is expire
Reply by laurentc.schneider_609
This behavior is documented in note 10362008.8 :
The fix should be applied on both client and server, so although it is included in
the 11.2.0.3 client, it also needs to be applied to the pre-11.2.0.3 database.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Bert,
I hope I am not hijacking this thread, but in Toad 12.0.0.61, the Toad advisor still shows an error even if the DB and the client are on the same version as it shows:
“Client version (11.2.0.3) and server version (11.2.0.3.0) should not be used together according to metalink note 207303.1.”
The current beta (12.1.0.14) also shows this same problem.
Lynn Olpin
From: Bert Scalzo [mailto:bounce-Bert_Scalzo@toadworld.com]
Sent: Friday, August 16, 2013 6:43 AM
To: toadoracle@toadworld.com
Subject: RE: [Toad for Oracle - Discussion Forum] TOAD - Oracle Password is expire
RE: TOAD - Oracle Password is expire
Reply by Bert Scalzo
Thanks for the follow-up explanation. This is a perfect example of why it’s always best to be on the terminal release of the database (e.g. 11.2.0.3) – and why the toad toad advisor (main menu->help-> toad advisor) checks for and advices being on the terminal release.
From: laurentc.schneider_609 [mailto:bounce-laurentcschneider_609@toadworld.com]
Sent: Friday, August 16, 2013 7:14 AM
To: toadoracle@toadworld.com
Subject: RE: [Toad for Oracle - Discussion Forum] TOAD - Oracle Password is expire
RE: TOAD - Oracle Password is expire
Reply by laurentc.schneider_609
This behavior is documented in note 10362008.8 :
The fix should be applied on both client and server, so although it is included in the 11.2.0.3 client, it also needs to be applied to the pre-11.2.0.3 database.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag this post as spam/abuse.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag this post as spam/abuse.
[mention:b4c0b6efa79a406ca7466d13d1b9e341:e9ed411860ed4f2ba0265705b8793d05] it is related to advisor, not to password expiration nor to metalink (does the name metalink still exist?)
[mention:228f8d2504734c859820ea0da5a1084e:e9ed411860ed4f2ba0265705b8793d05] 11.2.0.3 is not a terminal release. 11.2.0.4 is announced for 2013Q3 on Oracle prefered platforms. But even 11.2.0.4 is not declared terminal release yet