I think this is an issue with my oracle password file.

In my init.ora file I have the following:

*.remote_login_passwordfile='EXCLUSIVE'

When I go into sqplus and try to grant permissions I get the error below.
How do you tell the database what the location of the orapwd file?

This is the part I am not getting.Is there some parameter in the init.ora that does this? Ie orapwd_file=$ORACLE_HOME/dbs/orapass

Does the password file have to contain the name of the SID init like
the init.ora file?



sqlplus '/ as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 25 07:30:14 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engin
e options

SQL> grant sysdba to system;
grant sysdba to system
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled


SQL>