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

100 Oracle DBA Interview Questions and Answers

  Here are 100 tricky interview questions tailored for a Senior Oracle DBA role. These questions span a wide range of topics, including perf...