How to restore a password file in oracle database?

Question

Solved907 views16/07/2022Oracle Database

0

Ezana886 05/02/2022 0 Comments

What are the steps to restore a password file ( PWDsid.ora) in Oracle database 12c?

Question is closed for new answers.

meda Changed status to publish 16/07/2022

score 0 · Answer 1 · 2022-02-13T19:16:29+00:00

We don’t restore password file from backup.

We simply re-create the password file using the password utility orapwd.

C:\Windows\system32>orapwd file='D:\app\Admin\virtual\virtual\product\12.2.0\dbhome_1\database\PWDprimary.ora' password=orcl entries=5;
 created.

Besides we have to set the initialization parameter REMOTE_LOGIN_PASSWORDFILE to exclusive or shared:

SQL> ALTER SYSTEM SET REMOTE_LOGIN_PASSWORDFILE=’EXCLUSIVE’ SCOPE=SPFILE;

System altered.

SQL>