Print Thread
Handling of expired Oracle password
#49200 07/10/14 10:39 AM
Joined: Jul 2014
Posts: 11
P
PRice2 Offline OP
Member
OP Offline
Member
P
Joined: Jul 2014
Posts: 11
We have a little glitch in moving from XP to Windows 7. Our practice when a user needs a new password is to give them a password over the phone and immediately expire it.

The problem is that using the DOA dialog results in an ORA-01017 error in Windows 7 after the user enters and verifies their new Oracle password. On XP it works fine.

Delphi XE, DOA 4.1 from 2011, no handling of the password or DOA dialog other than calling Execute. I couldn't find any relevant posts on the forum other than possibly changing fonts from MS Sans Serif, which looks nicer, but didn't solve the problem.

Re: Handling of expired Oracle password
PRice2 #49203 07/11/14 09:10 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
Can you let me know the Oracle Client version on Windows 7?


Marco Kalter
Allround Automations
Re: Handling of expired Oracle password
Marco Kalter #49208 07/11/14 02:32 PM
Joined: Jul 2014
Posts: 11
P
PRice2 Offline OP
Member
OP Offline
Member
P
Joined: Jul 2014
Posts: 11
The client and OCI.dll are 11.2.0.1

Re: Handling of expired Oracle password
PRice2 #49218 07/15/14 03:52 PM
Joined: Jul 2014
Posts: 11
P
PRice2 Offline OP
Member
OP Offline
Member
P
Joined: Jul 2014
Posts: 11
Any luck on identifying the problem? We have the source, but I haven't found anything yet that solves the problem.

If it makes a difference, we've been customers the past ten years, serial number 01.94043.

Re: Handling of expired Oracle password
PRice2 #49220 07/16/14 08:56 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
We have not yet been able to determine what might cause this. If you have the source, can you add the {$D+} directive to the Oracle.inc file, add the source directory to the Delphi search path, and trace the issue? You should be able to see how the expiration is detected, which function is called to set the expired password, and how the ORA-001017 exception is eventually raised.


Marco Kalter
Allround Automations
Re: Handling of expired Oracle password
Marco Kalter #49223 07/16/14 01:45 PM
Joined: Jul 2014
Posts: 11
P
PRice2 Offline OP
Member
OP Offline
Member
P
Joined: Jul 2014
Posts: 11
Okay, thanks, it isn't a DOA problem. It's an Oracle client problem.

Our network admin installed the client from 11.2.0.3 onto Windows 7 when he built the installation image. Although the OCI.dll properties read 11.2.0.1, it isn't backwards compatible when reading from an 11.2 database version before 11.2.0.3.

The search that I ran to eventually find this out was:
problems with Oracle client 11.2.0.1 and Windows 7 and expired password
which includes gems such as;
http://feed.askmaclean.com/archives/11-2-0-3-client-password-expiry-and-ora-1017.html


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.027s Queries: 15 (0.006s) Memory: 2.5181 MB (Peak: 3.0397 MB) Data Comp: Off Server Time: 2024-03-28 23:36:45 UTC
Valid HTML 5 and Valid CSS