We are facing issue with password encryption when we are migrating to 10g to 11g Database.
We use Oracle table to store application user password in database with "DBMS_OBFUSCATION_TOOLKIT.MD5" encryption function.
We have imported the database from Oracle 10g(10.2.0.3) to Oracle 11g(22.214.171.124.0), after the succesful import when we are trying to access our applicationit says invalid password. All we have to do is resetting the password to access the application.
I request you to expalin us , is this the default behaviour of Oracle or we can avoid this by using any other way.
Thanks in Advance,