Oracle中出现ORA-00600[KZSRGPW]错误怎么办

ORA-600 [KZSRGPW] When Connecting AS SYSDBA
 Using The Passwordfile (文档 ID 1073283.1)

In this Document

SymptomsCauseSolutionReferences

SYMPTOMS

The following error is reported in the alert.log and
 associated trace file when logging in to the database AS SYSDBA using
 passwordfile authentication:

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kzsrgpw]

Function List (call stack trace):

kzsrgpw <- kzia3a <- kpolna <- kpogsk <- opiodr

SOLUTION

Recreate the passwordfile:

– list users currently granted sysdba and/or sysoper privileges:

select * from v$pwfile_users;

(note this may fail for the same reason)

– stop the database

– recreate the passwordfile:

On Unix/Linux systems:

orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=syspassword entries=16

On Windows systems:

orapwd file=%ORACLE_HOME/database/PWD%ORACLE_SID%.ora password=syspassword
 entries=16

– restart the database and grant sysdba / sysoper privileges to the users
 listed from the first step

<1span style="font-size:12.0pt;font-family:" color:white;"="">REFERENCES

NOTE:274115.1 – Quick Checklist for User Authentication