Hi Anurag,

This is how you create a password file on unix or windows NT from prompt

orapwd file=passwordfile password=urpassword entries=5

The entries parameter is optional the password parameter is what will be ur internal password.Internal user is not desupported still in Oracle 8i.Whenever you assign sysdba or sysoper privilege to any of the user it is also added to the password file on the server and whenever you change password of a user who has been assigned sysdba or sysoper privilege his password is changed in the password file as well as in the database.But you will not be add more then 5 users if the entries = 5 then you will have to delete the password file and recreate it increasing the no of entries so it is better to plan before you create the password file.I will put the step below how to create a password file and assigne a user sysdba privilege

Make sure you have deleted the password file before creating a new one.

1)

c:\> orapwd file=passwordfile password=urpassword entries=5

2) Login as sys into the database

grant sysdba to username;

Now the above user has sysdba privilege he will have permission to shutdown,startup,recover the database.

How to connect as sysdba

1) From prompt

sqlplus /nolog

connect username as sysdba;

Hope this calirifies your doubt.

If you still have any doubt please let us know

Regards