REP-501: The specified database cannot be connected.

Check for the "TNS_ADMIN" value in the "reports_process.xml" file in the
" /u01/app/oracle/config/domains/mydomain/system_components/ReportsServerComponent/rep_wls_reports_andrew-app/data/nodemanager ".
Change the value as per the tnsnames.ora location as per below.
ie. "/u01/app/oracle/config/domains/mydomain/config/fmwconfig"
Eventually reports_process.xml file shold looks like below.

[oracle@andrew-app nodemanager]$ cat reports_process.xml







[oracle@andrew-app nodemanager]$
[oracle@andrew-app nodemanager]$ cat reports_process.xml # [oracle@andrew-app nodemanager]$

RMAN-06172:

RMAN> restore controlfile from '/home/oracle/dms_mount/RMAN/STB02/stb02control.ctl';

Starting restore at 26-OCT-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6273 instance=dbm02_dg device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 10/26/2022 10:20:18

RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

Solution ->

The controlfile was on shared storage.
It is require to copy the controlfile to a local disk.

cp /home/oracle/dms_mount/RMAN/STB02/stb02control.ctl /tmp/


RMAN> restore controlfile from '/tmp/stb02control.ctl';

Starting restore at 26-OCT-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6900 instance=dbm02_dg device type=DISK
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=3 instance=dbm02_dg device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup

channel ORA_SBT_TAPE_1: skipped, AUTOBACKUP already found
channel ORA_DISK_1: copied control file copy
output file name=+DATA/dbm02_dg/controlfile/dbm02_stby.ctl
output file name=+REDO/dbm02_dg/controlfile/dbm02_stby.ctl
Finished restore at 26-OCT-22

RMAN>