Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

orapwd and oracle password file

tahaMar 5 2012 — edited May 3 2012
Hi all,

I have to allow remote connetion to an instance as sysdba. on remote server (SunOS, SQL*Plus: Release 10.2.0.1.0) and on oracle database server (SunOS, Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 )
Oracle database server contains many databes instances.

i tried these sql statments:

SQL> show parameter password;

NAME TYPE VALUE

remote_login_passwordfile string EXCLUSIVE



SQL> select * from v$pwfile_users;

no rows selected

i tried searching for this password file (i think it must be in $ORACLE_HOME/dbs directory) i found a weird one pwd$ORACLE_SID ( i thought is should be orapw$ORACLE_SID).
I thought since there is a password file why not trying to grant sysdba privilège to some user ( i just want to see if the password file was used). so on oracle database server (as sysdba) i tried this :
SQL> grant sysdba to XXX;
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled

I have some question about this situation :

1/ if something went wrong when using the orawpd utility, why are we able to (start up/ shut down) this instance whithout problems (well being on oracle server of course), does the password file authentification interfere only with remote authentification as sysdba ? (sorry i don't grasp well this mechanism since i am not a DBA administrator ...)

2/ how can i do to solve this situation :)

Thanks a lot
BR
Taha
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 2 2012
Added on Mar 5 2012
7 comments
16,088 views