This discussion is archived
1 Reply Latest reply: Feb 12, 2013 7:51 AM by moreajays RSS

Issue with PSU 14727315, Oracle wallet and users with SPARE4 passwords only

ltomovski Newbie
Currently Being Moderated
Hi all we have bumped into this problem

Our environment is this

We use an app which uses stored credentials in oracle wallet to connect to database. In our case the wallet is used from 11.1.0.6 and connects via sqlplus to 11.2.0.2 (11.2.0.2.7 - PSU from July 2012). -> sqlplus [XXX]/@ORCL
The user that is used to connect to the database is created like this "create user XXX identified by values 'S:C08BA9F686CF47853A8B0A9989AA7F9419E6AA7466259F38BC62A5C2877E' ". So the password column in the user$ is null for this user .. the value in password_versions column of the dba_users view is 11g. Nobody knows the password of user XXX only values are known

So everything works OK up until yesterday

We decided to patch with latest PSU (11.2.0.2.9 PSU from January 2013). After successful patch we started to get ora-01017 invalid username/password logon denied so I had to rollback the patch .. any idea how we can fix this .. As I can not change the password from that user as lots of ppl got the wallet and would take forever to update the user, update the wallet and distribute that newly created wallet to all clients

Any idea

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points