Call Oracle Support.
DAPHNE <daphne.liu_at_mail.pouchen.com.tw> wrote in message
news:388cec95$1_at_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 - 10:02:40 CST
