| orapwd errors [message #163029] |
Tue, 14 March 2006 11:32  |
Zakkhalid
Messages: 47
Registered: April 2005
|
Member |
|
|
Dear All,
I've created a oracle password file as so:-
[oracle@zog]/data/oracle/10g/dbs>orapwd file=zogpwd password=oracle entries=50;
[oracle@zog]/data/oracle/10g/dbs>ls -ltr zogpwd
-rw-r----- 1 oracle dba 7680 Mar 14 17:13 zogpwd
SQL> show parameter remote_login_passwordfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
BUT I get the following error!!!
SQL> GRANT sysdba TO backup_admin
2 /
GRANT sysdba TO backup_admin
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
any ideas anyone?
|
|
|
|
| Re: orapwd errors [message #163179 is a reply to message #163029] |
Wed, 15 March 2006 06:23  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Your file= name is wrong. The password file's name should be orapw$ORACLE_SID on Unix and PWD%ORACLE_SID%.ora on Windows. Try:
orapwd file=/data/oracle/10g/dbs/orapwzog password=oracle entries=50 |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
