ORA-00600: internal error code, arguments: [kzsrgpw]问题解决

原创

vast2006 2013-11-21 19:53:37 博主文章分类：Database ©著作权

文章标签 oracle 数据库 ORA-00600 文章分类 Oracle 数据库

©著作权归作者所有：来自51CTO博客作者vast2006的原创作品，请联系作者获取转载授权，否则将追究法律责任

打开EM 提示sys等帐号信息过期如下图：

到网上查了资料oracle 11g 存在密码过期问题：修改下oracle默认的密码期限；

18:51:42 sys@PORTALDB> SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180

Elapsed: 00:00:00.01
18:52:43 sys@PORTALDB> alter profile default limit PASSWORD_LIFE_TIME unlimited;

Profile altered.

Elapsed: 00:00:00.02
18:52:50 sys@PORTALDB> SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED

Elapsed: 00:00:00.01

sys@PORTALDB> alter user sys identified by values 'oracle';（错误的做法）

User altered.

Elapsed: 00:00:00.12
sys@PORTALDB> alter user system identified by values 'oracle';(错误的做法）

User altered.

Elapsed: 00:00:00.02
18:55:01 sys@PORTALDB> show user;
USER is "SYS"
18:56:23 sys@PORTALDB> conn system/oracle
ERROR:
ORA-01017: invalid username/password; logon denied
问题就出现在粗体颜色标注的地方；我原本的设想是还是使用原来的密码，修改密码没有期限限制后还是使用原来的密码；错就错在自己不理解

alter user system identified by values 'xxx';

与

alter user system identified by oracle ;

两者的区别。

打开EM 登录提示帐号和密码不对；日志报错：

Thu Nov 21 18:55:15 2013
Errors in file /oracle/diag/rdbms/portaldb/portaldb1/trace/portaldb1_ora_28377326.trc (incident=481025):
ORA-00600: internal error code, arguments: [kzsrgpw], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/portaldb/portaldb1/incident/incdir_481025/portaldb1_ora_28377326_i481025.trc
Thu Nov 21 18:55:17 2013
Dumping diagnostic data in directory=[cdmp_20131121185517], requested by (instance=1, osid=28377326), summary=[incident=481025].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Nov 21 18:55:19 2013
Sweep [inc][481025]: completed
Sweep [inc2][481025]: completed
Thu Nov 21 18:55:25 2013

查看trc文件，内容ORA-00600: internal error code, arguments: [kzsrgpw]等；

修改如下

sys@PORTALDB> alter user sys identified by oracle;

sys@PORTALDB> alter user system identified by oracle;

正常登录；valuses 后面是跟‘密文’保持和原来的密码一致；

如：

19:21:47 sys@PORTALDB> select NAME,PASSWORD FROM user$ where name in ('SYSMAN','MGMT_VIEW','DBSNMP');

NAME PASSWORD
------------------------------ ------------------------------
DBSNMP FFF45BB2C0C327EC
MGMT_VIEW B959D5AE1F152B1A
SYSMAN 2CA614501F09FCCC

alter user SYSMAN identified by values '2CA614501F09FCCC'; 这么做就能和原来的密码保持一致；注意点是如果知道了密码的即为明文就用普通的方法修改，如果不知道明文，查找出来密文，就用valuse ‘密文’方式来保持和原来的一样；

参考文章：http://soft.chinabyte.com/database/43/11835543.shtml

测试如下：

SQL> select name,password from user$ where name in('SYSTEM')
2 ;

NAME PASSWORD
------------------------------ ------------------------------
SYSTEM 970BAA5B81930A40

SQL>
SQL>
SQL>
SQL> alter user system identified by values '970BAA5B81930A40';

User altered.

SQL> conn system/system
Connected.