DUPLICATE ERROR

 During the duplicate process I got this error

RMAN-06402: Oracle instance shut down
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 14/11/2022 14:08:33
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '+RECO/DUTS/ARCHIVELOG/2022_11_14/thread_2_seq_45.4262.1023037434'
ORA-10877: error signaled in parallel recovery slave

In alert.log

2022-11-14T14:07:52.556223-06:00
kcrf_decrypt_redokey: wallet is not opened..(err 28365) <<<< wallet is not open
Errors with log +RECO/DUTS/ARCHIVELOG/2022_11_14/thread_2_seq_45.4262.1023037434
2022-11-14T14:07:52.673668-06:00
Media Recovery failed with error 28365
Recovery interrupted!
2022-11-14T14:07:52.851222-06:00
Errors in file /u01/app/oracle/diag/rdbms/duts/DUTS/trace/DUTS_pr00_24026.trc:
ORA-00283: recovery session canceled due to errors
ORA-28365: wallet is not open

Solution

• Copy the wallet file (ewallet.p12) from source database server to clone database server. You can check the wallet file location on source database from sqlnet.ora file of the source database ORACLE_HOME scp oracle@duts1:/u01/app/oracle/admin/DUTS/wallet/ewallet.p12 .

• Modify sqlnet.ora file in clone database ORACLE_HOME to reflect the location of the wallet file:

ENCRYPTION_WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = /u01/app/oracle/admin/DUTS/wallet)
)
)

• Invoke orapki utility on the clone database server to make the wallet auto-login:

orapki wallet create -wallet /u01/app/oracle/admin/DUTS/wallet -pwd "oracle" -auto_login

• If above step is successful, you should find a new file is created in the same directory: cwallet.sso

[oracle@duts2 wallet]$ ll *.sso

-rw-rw-r-- 10 oracle oinstall 2048 Nov 14 16:11 cwallet.sso

• STARTUP NOMOUNT the auxiliary instance and try the duplicate command.

After few minutes the problem fixed.

starting media recovery
media recovery complete, elapsed time: 00:50:00
Finished recover at 14-NOV-22

RMAN>

Change The Repository (RPD) Password in OBIEE

 How To Change The Repository (RPD) Password in OBIEE

We can Change the Oracle BI Repository Password Using the obieerpdpwdchg Utility

Use the following steps to Change The Repository (RPD) Password:

1. Navigate to the obieerpdpwdchg utility, which is located under $BI_DOMAIN_HOME/bitools/bin directory.

Type the following arguments for obieerpdpwdchg:

-I name_and_path_of_existing_repository

-O name_and_path_of_new_repository

2. Then, enter the current (old) password and the new password when prompted. The repository password must be longer than five characters and cannot be empty.

$ obieerpdpwdchg -I my_repos.rpd -O my_changed_repos.rpd

Please enter the repository password:

Please enter a new repository password:

Note that passwords are masked on the command line unless you include the -C option in the command to disable masking.

3. Use the uploadrpd command to upload the repository to Oracle BI Server.

Please see this link to - OBIEE 12c: Download and Upload Repository(RPD) Commands