My Oracle Support Banner

SP_CREDSTORE_CHG_ROLE_PWD Throws "ORA-01426: numeric overflow" Error When Changing Role Password (Doc ID 2887390.1)

Last updated on OCTOBER 23, 2023

Applies to:

Oracle Communications MetaSolv Solution - Version 6.3.1 and later
Information in this document applies to any platform.


The SP_CREDSTORE_CHG_ROLE_PWD stored procedure throws an ORA-01426: numeric overflow error when attempting to change the WOTSTWTWWOO role password. The problem was encountered after upgrading from 6.2.1 to 6.3.1 and trying to resolve ORA-01979: missing or invalid password for role 'WOTSTWTWWOO' errors observed in the WebLogic Server logs during startup of the server. The password value entered as the C_PASSWORD variable to call SP_CREDSTORE_CHG_ROLE_PWD began with a number. In fact, it was the same password used to create the WOTSTWTWWOO role from the a_users.sql installation script which is subsequently changed immediately after upgrading.





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.