Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 |
