How to solve the error message ORA-00600 problem?

From: DAPHNE <daphne.liu_at_mail.pouchen.com.tw>
Date: 24 Jan 2000 10:22:41 GMT
Message-ID: <388cec95$1@news.twsc.pouchen.com.tw>

Hi,
I created a new user ‘WAITE’ by starting file “install.sql” (see the following***) and also granted the SYSOPER and SYSDBA privileges to him. However,when I queried the users password file (v$pwfile_users), the error message appeared as below:

SQL> select * from v$pwfile_users;
ERROR:
ORA-00600: 傳回內部錯誤代碼, 參數: [KSSRMP1], [], [], [], [], [], [], [] 沒有任何資料列被選取

Any help will be appreciated. Look forward to seeing the solution soon. fm:daphne

Install.sql

---

***

set echo on
create user waite identified by waite
temporary tablespace temp
default tablespace users;

grant dba to waite;
set echo off

---

---

The procedure which I has done is as following: Login by Waite/Waite in SQL*Plus

SQL> @f:\oracle8ht\chapter01\chp1_3.sql;
SQL>
SQL> SELECT segment_name, tablespace_name, initial_extent,
  2         next_extent, min_extents, optsize, rs.status

  3 FROM dba_rollback_segs rs, v$rollstat vs, v$rollname vn   4 WHERE rs.segment_name = vn.name and   5 vn.usn = vs.usn;

SEGMENT_NAME TABLESPACE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS OPTSIZE STATUS
------------ ---------- -------------- ----------- ----------- -------- ---- --
SYSTEM SYSTEM 51200 51200 2 ONLINE

RBS1         RBS                 26624       26624          19   512000

ONLINE

SQL>
SQL> set echo off
SQL> desc v$pwfile_users;
名稱                            空的？    類型
------------------------------- -------- ----
USERNAME                                 VARCHAR2(30)
SYSDBA                                   VARCHAR2(5)
SYSOPER                                  VARCHAR2(5)

SQL> select * from v$pwfile_users;
ERROR:
ORA-00600: 傳回內部錯誤代碼, 參數: [KSSRMP1], [], [], [], [], [], [], []

沒有任何資料列被選取

---

---

Received on Mon Jan 24 2000 - 04:22:41 CST