Toad World® Forums

TOAD - Oracle Password is expire

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 :

  1. as SYS in sqlplus

alter user scott identified by tiger password expire account unlock;

  1. logon in Toad (12.1) with scott/tiger

  2. Toad display “your password has expired”

New password : lion

Verification : lion

  1. 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

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.

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