Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find the password file?

Re: How to find the password file?

From: christian <cdNOcdSPAM_at_nctech.fr.invalid>
Date: Tue, 08 Feb 2000 03:22:59 -0800
Message-ID: <1cb3e3d0.0f21f6eb@usw-ex0109-069.remarq.com>


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

Received on Tue Feb 08 2000 - 05:22:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US