Hi.
There is a known bug in Oracle when u try to query against v$pwfile_users.

In order to see the contents of v$pwfile_users fire the following query.Login in svrmgr or sqlplus as sys as sysdba and enter the following query

svrmgr> select * from v$pwfile_users order by 1;

U can see whether password is present by looking in dbs directory.Oracle creates a password file in $ORACLE_HOME/dbs directory with the name passwd.ora

If u want to create a password file use the follwoing syntax.
In UNIX
$orapwd file= password= entries=n

In Windows NT
c:\>orapwd80 file=
password= entries=n max users having sysdba and sysoper roles>


If u have already have a password file remove it and then create a new one using the above give command.




Regards,
ROhit Nirkhe,Oracle DBA,OCP 8i
[email protected]