Oracle Pawword file

[ggnanaraj]

Originally posted by hamhey
Soldb SQL>select * from v$pwfile_users;
ERROR:
ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], []

Use a order by clause in your above query.

Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

Input truncated to 31 characters
BLAZE: SYS> select * from v$pwfile_users order by 1;

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
INTERNAL                       TRUE  TRUE
SYS                            TRUE  TRUE

BLAZE: SYS> grant sysdba to rgg;

Grant succeeded.

BLAZE: SYS>  select * from v$pwfile_users order by 1;

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
INTERNAL                       TRUE  TRUE
RGG                            TRUE  FALSE
SYS                            TRUE  TRUE

BLAZE: SYS> 

BLAZE: SYS>  select * from v$pwfile_users;
ERROR:
ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], []



no rows selected

BLAZE: SYS>