Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem to change user password

mcoradiniFeb 27 2013 — edited Feb 28 2013
Hi,

I'm with some problems when trying to alter a oracle user password. After using the alter command, it gives the message "User altered", but when i try to connect with it throws the ORA-01017 error...
The strange part is... it works just fine on my XE 11g !

Someone have an idea on this issue? :)

Thanks.

================

oracle@arc02:~> sqlplus mybase/mypass@myinstance

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jan 15 11:52:48 2013

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
With the Real Application Clusters option

SQL> alter user z48829 identified by Telemar$0n;

User altered.

SQL> quit
Disconnected from Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
With the Real Application Clusters option
oracle@dtcdbarc02:~> sqlplus z48829/Telemar$0n@myinstance

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jan 15 11:53:14 2013

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
This post has been answered by moreajays on Feb 28 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2013
Added on Feb 27 2013
11 comments
709 views