Oracle中出現(xiàn)ORA-00600[KZSRGPW]錯(cuò)誤怎么辦

發(fā)布時(shí)間：2021-11-20 16:23:45 來(lái)源：億速云閱讀：137 作者：小新欄目：關(guān)系型數(shù)據(jù)庫(kù)

這篇文章主要介紹了Oracle中出現(xiàn)ORA-00600[KZSRGPW]錯(cuò)誤怎么辦，具有一定借鑒價(jià)值，感興趣的朋友可以參考下，希望大家閱讀完這篇文章之后大有收獲，下面讓小編帶著大家一起了解一下。

環(huán)境：

DB：Oracle 11.2.0.1.0

OS：Windows Server 2012

問(wèn)題：

數(shù)據(jù)庫(kù)服務(wù)器異常斷電重啟后，在數(shù)據(jù)庫(kù)服務(wù)器本地，通過(guò)sqlplus連接sys用戶登錄數(shù)據(jù)庫(kù)，報(bào)錯(cuò)ORA-600[KZSRGPW]

問(wèn)題原因：

懷疑是passwordfile文件損壞；

解決方案：

orapwd命令重新創(chuàng)建口令文件；

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

修改時(shí)間:2017-11-21類型:PROBLEM

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

感謝你能夠認(rèn)真閱讀完這篇文章，希望小編分享的“Oracle中出現(xiàn)ORA-00600[KZSRGPW]錯(cuò)誤怎么辦”這篇文章對(duì)大家有幫助，同時(shí)也希望大家多多支持億速云，關(guān)注億速云行業(yè)資訊頻道，更多相關(guān)知識(shí)等著你來(lái)學(xué)習(xí)!

向AI問(wèn)一下細(xì)節(jié)

Oracle中出現(xiàn)ORA-00600[KZSRGPW]錯(cuò)誤怎么辦

猜你喜歡

最新資訊

相關(guān)推薦

相關(guān)標(biāo)簽