PASSWORD FILE CREATION

show parameter remote_logine_passwordfile
#default value is excluse just change it to NONE.
ALTER SYSTEM SET REMOTE_LOGIN_PASSWORDFILE=NONE SCOPE=SPFILE;
SHUT IMMEDIATE
STARTUP
#THEN GO TO COMMAND PROMPT AND CREATE PASSWORDFILE
C:\> orapwd file=c:\oracle\product\10.2.0\db_1\database\ora01pwdorcl.ora password=nashim entries=5

OR
$orapwd file=/u01/app/oracle/product/10.2.0/db_1/dbs/ora01pwdorcl.ora password=nashim entries=5

#THEN AGAIN ALTER PARAMETE WITH EXCLUSIVE VALUE
ALTER SYSTEM SET REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE SCOPE=SPFILE;
SHUT IMMEDIATE;
STARTUP

#THEN ASSING SAME PASSWORD WHICH IN PASSWORDFILE TO PARTICULAR NORMAL USER LIKE HR AND GIVE APPROPRITE PERMISSION.

ALTER USER HR IDENTIFIED BY NASHIM;
GRANT SYSDBA, SYSOPER TO HR;
#CHECK HR HAVING RIGHT DBA PRIVILLEGE OR NOT
SELECT * FROM V$PWFILE_USERS;

#NOW TRY TO LOGIN AS SYSDBA VIA HR USER AND ALSO TRY TO SHUTDOWN AND STARTUP PROCESS. AND THIS PASSWORD BASICLY USE FOR REMOTE LOGING LIKE EM LOGIN BECOUSE EM ALSO ON WORK AS REMOTE LOGIN SERVER REQUEST...

#IF USER HAVING SYSDBA PRIVILLEGE THEN WHEN WE TRY TO LOGIN ON SQL*PLUS WE CAN USE ANY PASSWORD (IF USING HR AS SYSDBA) ....