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

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

In this Document

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