ORA-600 [kzsviver:1] Error On Setting Users’ Passwords [ID 554605.1]
来源:互联网 发布:c语言教程全套 编辑:程序博客网 时间:2024/06/07 20:43
ORA-600 [kzsviver:1] Error On Setting Users’ Passwords [ID 554605.1]
Modified 20-SEP-2010 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Changes
Cause
Solution
References
Applies to:
Oracle Server – Enterprise Edition – Version: 11.1.0.6 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Checked for relevance on 20-Sep-2010
Symptoms
ORA-600 [kzsviver:1] possibly followed by ORA-600 [kks-hash-collision] errors can occur when trying to set a users password via SQL or PL/SQL scripts using the “CREATE/ALTER USER … IDENTIFIED BY VALUES …” command syntax if a null password value, e.g. an empty string ”, is used.
Changes
The code is being executed in Oracle11g, and works successfully in previous releases.
Cause
This is due to unpublished bug:6755379 as identified in bug:6833049, and was deemed as expected behaviour by development due to the use of unsupported command syntax as the use of the ‘IDENTIFIED BY VALUES’ clause on a CREATE/ALTER USER statement is not officially documented, and is intended purely for internal use by the export/import utilities within the Oracle RDBMS. Therefore it was deemed appropriate for this to raise an internal error as opposed to a user error as encountering a null password string would otherwise not be possible.
Additionally the use of export/import for general use is desupported in Oracle11g.
Solution
Ensure that users have none null passwords defined and don’t use the “ALTER USER … IDENTIFIED BY VALUES …” command syntax which is not officially documented and therefore not supported, and may cease to work in a future Oracle RDBMS version.
In 11g, the new hash value is stored in the USER$.SPARE4 column, see note 429465.1, if existing passwords must be migrated, make sure to make no errors in transferring this value to avoid this internal error.
References
BUG:6833049 – ORA-600 [KZSVIVER:1] AND ORA-600 [KKS-HASH-COLLISION] CHANGING PASSWORDS
NOTE:1051962.101 – Restoring a user’s original password
NOTE:429465.1 – 11g R1 New Feature : Case Sensitive Passwords and Strong User Authentication
Show Related Information Related
Products
Oracle Database Products > Oracle Database > Oracle Database > Oracle Server – Enterprise Edition
Keywords
UTILITY; IMPORT UTILITY
Errors
ORA-600[KZSVIVER; 1]; ORA-600[KKS-HASH-COLLISION]
- ORA-600 [kzsviver:1] Error On Setting Users’ Passwords [ID 554605.1]
- ORA-1114 Error Reported on an Unknown File Id
- ORA-01950:no privileges on tablespace 'USERS'
- ORA-01950:no privileges on tablespace 'USERS'
- ORA-01950:no privileges on tablespace 'USERS'
- ORA-01950:no privileges on tablespace 'USERS'
- ORA-01950:no privileges on tablespace 'USERS'
- ORA-01950: no privileges on tablespace 'USERS'
- ORA-600 Lookup Error Categories [ID 175982.1]
- 【DG】ORA-1 Occurring on Logical Standby (文档 ID 257356.1)
- Error setting TTL index on collection : sessions
- ORA-600/ORA-7445/ORA-700 Error Look-up Tool (文档 ID 153788.1)
- ORA-01950: no privileges on tablespace 'USERS'错误
- ORA-01950: no privileges on tablespace 'USERS'错误
- ORA-01950: no privileges on tablespace 'USERS'错误
- Oracle错误:ORA-01950:no privileges on tablespace 'USERS'
- ORA-01950: no privileges on tablespace 'USERS'错误
- ORA-01950: no privileges on tablespace 'USERS'--解决办法
- spring中2种oracle数据源的配置
- CMake使用方法
- 基于S3C2440的Linux-3.6.6移植——解决LCD自动关闭
- 主要基础资料的CSV名字
- jsoncpp的一些使用方法介绍
- ORA-600 [kzsviver:1] Error On Setting Users’ Passwords [ID 554605.1]
- 浅谈协方差矩阵
- JAVA反射突破泛型的约束
- yum 报错Loading mirror speeds from cached hostfile
- Linux cpuinfo 详解
- 如果矩阵中某个元素为0,那么把它所在的行和列都置为0
- spring
- fcntl设置FD_CLOEXEC标志作用
- 大数除法 10494 - If We Were a Child Again