| Password problem on Oracle 10g (merged) [message #268670] |
Wed, 19 September 2007 05:57  |
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 |
|
|
|
|
|
| Password problem on Oracle 10g [message #268679 is a reply to message #268670] |
Wed, 19 September 2007 06:18  |
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 |
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 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
