Hello,
While trying to access a database remotely through RMAN, I got a set of errors whose cause were the fact that, the database I was trying to access didn't have password file authentication configured...that was true. I then decided to use a password file on that database and to grant the sysdba privilege to the user I was connecting remotely with. Unfortunately, Oracle threw the ORA 01994 error, GRANT Failed:Password file missing or disabled.
I ran a search on the net and all the solutions I got were saying, I should create a password file, and set the remote_login_passwordfile parameter to exclusive. I did, just that, but the error persists.
Below is how I created the password file:
orapwd file='/u01/app/oracle/product/10.2.0/db_1/dbs/orapwdSECOND' password=amore entries=5 force=y
I added the parameter "force" because there was already a file named orapwsecond on that location.
Besides, when I ran the following
show parameter password
, the value was "EXCLUSIVE". I did try adding the extension .ora to the password file, but nothing. I also restarted the instance, I changed the parameter "remote_login_passwordfile" manually but nothing.
My database is running on RHEL4. I tried to compare with Windows and I realize on windows, the passwordfile is located in the \%ORA_HOME\database directory but on RHEL4, it's located in the %/ORA_HOME/dbs directory and in addition, there is no database directory on RHEL4. Is it normal? What am I doing wrong? I did exactely what the solutions I got from the net suggested but the error remains. Any tips?
Thanks in advance.