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