Home » RDBMS Server » Security » Password problem on Oracle 10g (merged)
Password problem on Oracle 10g (merged) [message #268670] Wed, 19 September 2007 05:57 Go to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hi Friends,

i have an oracle 9 database (solaris eight) which i exported to an oracle 10g database (solaris 10). I used the imp and exp utilities .

The problem is that in oracle 9 i can decrypt the password but when i decrypt the password in oracle 10g i get garbage characters.

Due to this problem, I cant login in my application.

Is there a way to use the decrypted password from oracle 9 and encrypt it again in oracle 10g.


Thank you,
Dirish

[Updated on: Wed, 19 September 2007 05:58]

Report message to a moderator

Re: passwords in oracle 9 and 10 [message #268674 is a reply to message #268670] Wed, 19 September 2007 06:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
The problem is that in oracle 9 i can decrypt the password

If you call about Oracle passwords, this is wrong you can't decrypt them (above all because they are not crypted but hashed).

Regards
Michel
Password problem on Oracle 10g [message #268679 is a reply to message #268670] Wed, 19 September 2007 06:18 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi all,

I have a Sun server with oracle 9i installed and an application server on SUN server. Both SUN servers have solaris 9 installed.

i have import the database from oracle 9i to oracle 10g on solaris 10 using the imp utility.

Now i am logging on my application server and i am getting a password problem.
Logon denied.

After testing our configuration we have decrypted the password on oracle 9i and oracle 10g on sqlplus, both passwords were not similar.

So, is there any way where i can decrypt the password on oracle 10g.
Re: passwords in oracle 9 and 10 [message #268680 is a reply to message #268674] Wed, 19 September 2007 06:18 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hi Michel,

Thanks for the previous solution you provided (imp and export/ create tablespace, etc). It worked.

In fact I did a test on oracle 9, e.g for user dirish, I can read the password which is pass123 but for the same user, on oracle 10g, when i decrypt the password, i have garbage characters.

In fact as i told you earlier, i did a full export from oracle9 and did a full import in oracle10g.


Thank you,
Dirish
Re: passwords in oracle 9 and 10 [message #268688 is a reply to message #268680] Wed, 19 September 2007 06:38 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
In fact I did a test on oracle 9, e.g for user dirish, I can read the password which is pass123 but for the same user, on oracle 10g, when i decrypt the password, i have garbage characters.

Once again you can't decrypt Oracle password.
Post exactly what you did (copy and paste your screen).

Regards
Michel
Previous Topic: Why does ORACLE calls VPD function twice on every DML?
Next Topic: ROLES & PRIVILEGES
Goto Forum:
  


Current Time: Thu Mar 28 05:15:48 CDT 2024