Home » RDBMS Server » Server Administration » Unable to change password via sqlplus ? (10g)
Unable to change password via sqlplus ? [message #376482] Wed, 17 December 2008 09:31 Go to next message
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 #376484 is a reply to message #376482] Wed, 17 December 2008 09:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Metalink Note:550241.1 has something very close.
Is that your case?
Re: Unable to change password via sqlplus ? [message #376493 is a reply to message #376484] Wed, 17 December 2008 10:13 Go to previous message
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
Previous Topic: unable to send email through oracledb
Next Topic: SYS user and RECYCLEBIN/DROP
Goto Forum:
  


Current Time: Fri Dec 02 16:46:03 CST 2016

Total time taken to generate the page: 0.08009 seconds