OraFAQ Forum: Client Tools » First Login with SQL DEVELOPER

Home » Other » Client Tools » First Login with SQL DEVELOPER (Oracle 10, SQL DEVLOPER 1.5.1, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

First Login with SQL DEVELOPER [message #560351]

Thu, 12 July 2012 05:49

Karlia
Messages: 40
Registered: May 2011
Location: Algiers

Member

Hello every body,

when I create a user with "PASSWORD EXPIRE" option in order to force him to change his password at first login, it has always worked for me when the client tool is SQLPLUS for example, but when it concerns SQL DEVELOPER it gives :

password has expired, unable to reset password, OCI driver not available

and it doesn't give any login window to change password as expected.

Does any one see what's wrong ?

Thanks,

Report message to a moderator

Re: First Login with SQL DEVELOPER [message #560355 is a reply to message #560351]

Thu, 12 July 2012 06:10

wvu1999
Messages: 40
Registered: April 2007

Member

Jdbc doesn't support password reset on login.

In Sql developer, go to preferences and enable option for oci thick driver. Your oracle home oci.dll can then be used to handle the password reset.

Report message to a moderator

Re: First Login with SQL DEVELOPER [message #560359 is a reply to message #560355]

Thu, 12 July 2012 06:27

Karlia
Messages: 40
Registered: May 2011
Location: Algiers

Member

Thanks wvu1999 for reply.

I did it, I have been at :
Tools / preferences / database / advanced parameters,
and let :
USE OCI/THICK DRIVER enabled,

But it stil doesn't work, it gives me :