Create or Alter User failed: ORA-00600: internal error code, arguments: [kzsviver:4]

Error Description

Create user command failed with following error.

SQL>  CREATE USER "ST" IDENTIFIED BY VALUES 'S:E285C80B22886275424125E6A479E3B9CA84

F5FE51932DE4EF028DEA2CBF;D766CF03D5031EDC'    ;

 CREATE USER "ST" IDENTIFIED BY VALUES 'S:E285C80B22886275424125E6A479E3B9CA84

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [kzsviver:4], [], [], [], [], [],

[], [], [], [], [], []

 

SQL> alter user ST IDENTIFIED BY VALUES 'S:E285C80B22886275424125E6A479E3B9CA84

F5FE51932DE4EF028DEA2CBF;D766CF03D5031EDC'    ;

alter user ST IDENTIFIED BY VALUES 'S:E285C80B22886275424125E6A479E3B9CA84

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [kzsviver:4], [], [], [], [], [],

[], [], [], [], [], []

 

Solution Description

The script for user creation I have taken from the existing database with get_ddl (select dbms_metadata.get_ddl('USER','ST') from dual;) command. Unfortunately there was an additional new line character in the encrypted password. This caused the error. I have removed the new line character and executed the command successfully.

SQL> alter  USER "ST" IDENTIFIED BY VALUES 'S:E285C80B22886275424125E6A479E3B9CA84F5FE51932DE4EF028DEA2CBF;D766CF03D5031EDC';

 

User altered.

So make sure your script is proper with no unwanted characters in place. Or you can remove the IDENTIFIED BY VALUES clause and execute with just IDENTIFIED BY clause.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google