This error is received if unwanted characters are used in the password when changing the user password. In the following example, the “:” character is used at the end of the hash version of the password. This type of spelling error causes ORA-600 error. This error will not be receive when you fix the character problem in the password.
|
1 2 3 4 5 6 |
SQL> alter user ADURUOZ identified by values 'S:6C67DDC4DA4411AA968EC29AAF79DE:'; alter user ADURUOZ identified by values 'S:6C67DDC4DA4411AA968EC29AAF79DE:' * ERROR at line 1: ORA-00600: internal error code, arguments: [kzsviver:4], [], [], [], [], [], [], [], [], [], [], [] |
You can detect the hash version of the user’s password as follows.
|
1 2 3 4 5 6 7 |
SQL> select dbms_metadata.get_ddl('USER','ADURUOZ') from dual; DBMS_METADATA.GET_DDL('USER','ADURUOZ') -------------------------------------------------------------------------------- CREATE USER "ADURUOZ" IDENTIFIED BY VALUES 'S:6C67DDC4DA 4411AA968EC29AAF79DE |
