| Unable to change password via sqlplus ? [message #376482] |
Wed, 17 December 2008 09:31  |
Orna
Messages: 62
Registered: November 2008
|
Member |
|
|
Hi
I tried the below in several databases, from 10.1 to 10.2.4
All the same - no matter the password ( all letters, letters/numbers ) - I get the same ORA-06502 error :
prvnyc021>aqrp:>sqlplus oweisman/oldpass
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 17 15:29:48 2008
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-28001: the password has expired
Changing password for oweisman
New password:
Retype new password:
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 11
Password unchanged
Enter user-name:
Anyone has any idea ?? Could not find anything on metalink
thanks
Orna
|
|
|
|
|
|
| Re: Unable to change password via sqlplus ? [message #376493 is a reply to message #376484] |
Wed, 17 December 2008 10:13  |
Orna
Messages: 62
Registered: November 2008
|
Member |
|
|
Hi
YES !!
this is exactly my case.
I have a DDL trigger that writes the sql text into an audit table.
Disabling the trigger solved the problem
I am going to change my trigger so it will not cause this problem in the future.
thanks a lot
Orna
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
