Disclaimer

Friday, 24 September 2021

orapw file Lowercase and Uppercase and RMAN connection error

Part 1:-
[oracle@rac7 dbs]$ rman target sys/welcome#123@ORCL auxiliary sys/welcome#123@ORCL_DG
Recovery Manager: Release 12.2.0.1.0 - Production on Thu Sep 23 01:20:12 2021
Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
connected to target database: ORCL (DBID=1559919319)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied
[oracle@rac7 dbs]$


There was no password file so getting invalid username/password
=====================================================================

Part 2 :- Password file is created in RAC environment from rac3 node and stored in +DATA diskgroup

[oracle@rac3 ~]$
[oracle@rac3 ~]$ orapwd dbuniquename=orcl file=+DATA/orapworcl format=12 password=welcome#123 force=y entries=10
[oracle@rac3 ~]$
[oracle@rac3 ~]$

Part 3:-
Copying password file from +DATA diskgroup to /tmp location 
[grid@rac3 ~]$ asmcmd
ASMCMD> ls
ARCH/
CRS/
DATA/
ASMCMD> cd D*
ASMCMD> ls -lrt
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'

Type      Redund  Striped  Time             Sys  Name
                                            N    orcl/
PASSWORD  UNPROT  COARSE   SEP 24 11:00:00  N    orapworcl => +DATA/orcl/PASSWORD/pwdorcl.275.1084100635
ASMCMD>
ASMCMD> pwd
+DATA
ASMCMD> pwcopy orapworcl /tmp
copying +DATA/orapworcl -> /tmp/orapworcl

Part 4:- 
Changing the ownership of password file
 
[root@rac3 tmp]#
[root@rac3 tmp]# chown oracle:oinstall orapworcl
[root@rac3 tmp]#


Part 5:- 


copying password file rac3 to rac7 server using scp command 
[oracle@rac3 tmp]$ scp orapworcl oracle@192.168.0.107:/u01/app/oracle/product/12.2.0.1/db_1/dbs/orapworcl_dg
oracle@192.168.0.107's password:
orapworcl                                    100% 2048     2.3MB/s   00:00
[oracle@rac3 tmp]$


Part 5:-  


Again connecting to Primary instance and Auxiliary instance but still getting same error

[oracle@rac7 ~]$ rman target sys/welcome#123@ORCL auxiliary sys/welcome#123@ORCL_DG

Recovery Manager: Release 12.2.0.1.0 - Production on Fri Sep 24 11:27:14 2021

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1559919319)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied

Part 6:-  

Now check below how password file name changed i.e. from orapwdorcl_dg to orapwORCL_DG


[oracle@rac3 tmp]$
[oracle@rac3 tmp]$ scp orapworcl oracle@192.168.0.107:/u01/app/oracle/product/12.2.0.1/db_1/dbs/orapwORCL_DG
oracle@192.168.0.107's password:
orapworcl                      100% 2048     2.1MB/s   00:00
[oracle@rac3 tmp]$


Finally got connection 

[oracle@rac7 ~]$
[oracle@rac7 ~]$ rman target sys/welcome#123@ORCL auxiliary sys/welcome#123@ORCL_DG

Recovery Manager: Release 12.2.0.1.0 - Production on Fri Sep 24 11:27:53 2021

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1559919319)
connected to auxiliary database: ORCL (not mounted)

RMAN>


No comments:

Post a Comment

Understanding SQL Plan Baselines in Oracle Database

  Understanding SQL Plan Baselines in Oracle Database SQL Plan Baseline is the feature in Oracle started from Database 11g that helps to pre...