Page 1 of 1

ORA-01017 with torasession.changepassword

Posted: Mon 12 Aug 2013 10:32
by mreichert
Hello
I write a utility which is used to change expired passwords
with the changepassword function of torasession
I have 4 Oracle Homes installed on the server
11.2.0.3/10.2.1/9.2/Forms6 As default the 11.2.0.3 client is selected
I’m using Delphi 2010 with ODAC 9.0.2 on Windows 7 SP1
If I try to change the password I receive a ora-01017

According to Doc 1426233.1 of support.oracle.com there is a problem to change the password with that function
if the database is lower than 11.2.0.3. The workaround is to use a client lower than 11.2.0.3

I tried to use an instant client with a level of 11.2.0.1 and set the oracall.ocidll to the oci.dll of the instant client.
I’m not allowed to change the registry.
I start the program with the following cmd file
set PATH=c:\Workarea\PWC
cd /d c:\Workarea\PWC
set TNS_ADMIN=C:\Program Files\DL\Oracle
set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
set ORACLE_HOME=c:\Workarea\PWC
set ORACLE_HOME_NAME=inst
PWChanger.exe

The instant client is installed in c:\Workarea\PWC
How can I force the client to use the instant client without changing the registry

thanks and regards
markus

Re: ORA-01017 with torasession.changepassword

Posted: Mon 12 Aug 2013 11:59
by AlexP
Hello,

If you have already Oracle clients installed and information about them is in the registry, to use instant client (without changes in the registry), you should specify the correct path in Oci.Dll in the OCIDLL global variable declared in the OraCall class.

Code: Select all

uses ..., Oracall;
...
  OCIDLL := 'c:\Workarea\PWC\Oci.dll';

Re: ORA-01017 with torasession.changepassword

Posted: Mon 12 Aug 2013 12:43
by mreichert
Hello alex,

thank you very much that solved my problem.

regards markus

Re: ORA-01017 with torasession.changepassword

Posted: Mon 12 Aug 2013 13:07
by AlexP
Hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.