Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find the password file?
hi
if you have no rows in v$pwfile_users it's because you
don't create a pasword file:
cd $ORACLE_HOME/dbs if you have one you can see it here.
if you want create a sysdba access:
orapwd file=orapw<SID> password=your_password entries=10
shutdown your database.
add in the init<SID>.ora file :
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE.
startup your database.
start svrmgrl
connect sys/sys_password
create an user with grant connect,resource,sysdba;
after you can see your user in v$pwfile_users