RMAN - Loss of the Password File Recovery example

Recovery from Loss of the Password File

• Remove or move password file at OS level

suse1:/u01/app/oracle/product/12.1.0/dbhome_1/dbs # mv orapwplm orapwplm_pwd

• Error during remote connection

oracle@suse1:/u01/app/oracle/product/12.1.0/dbhome_1/dbs> sqlplus sys/test@plm as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon May 25 13:48:35 2020

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

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

• Create password file at OS level.

orapwd file=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwplm password=test entries=5 format=12 

• Login database again remotely

oracle@suse1:/u01/app/oracle/product/12.1.0/dbhome_1/dbs> sqlplus sys/test@plm as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun May 24 11:43:24 2020

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics

and Real Application Testing options

SQL> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE

--------- -------------------- ----------------

PLM       READ WRITE           PRIMARY