Error with rapidwiz at 12%

[satish]

HI Erman,

We are installing EBS R12.2 in RHEL 8. We are facing errors as below

Phase 3 Rename Database

Executing command: sh -c "ORACLE_SID=ORCLVIS;export ORACLE_SID;ORACLE_HOME=/u02/vis/db/12.1.0;export ORACLE_HOME; /u02/vis/db/12.1.0/bin/rman target / nocatalog @/u02/vis/db/12.1.0/appsutil/out/VIS_visionerp/restore-rac3.rman > /u02/vis/db/12.1.0/appsutil/out/VIS_visionerp/restore-rac3.log"

Unable to rename database

    RW-50010: Error: - script has returned an error:   1
RW-50004: Error code received when running external process.  Check log file for details.
Error while running Database Install Driver for VIS instance
[root@visionerp u03]#

Log:
-----

[root@visionerp u03]# cat restore-rac3.log

Recovery Manager: Release 12.1.0.2.0 - Production on Sat Dec 3 09:40:02 2022

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

connected to target database: ORCLVIS (DBID=1616072412, not open)
using target database control file instead of recovery catalog

RMAN> #
2> # $Header: restore-rac3.rman 120.6 2013/03/15 16:42:00 rledezma noship $
3> #
4> # This shell script was originally built to reset the first node of
5> # a RAC database in Rapid Clone in 12.1 after an RMAN database restore
6> # procedure.  RI evolved to restore a single instance from an RMAN backup
7> # as well, so now it's used here too.
8> #
9> #
10> host "echo 'In the above output, if RMAN-03002 and RMAN-06054 errors are present, they can be safely ignored.' >> /u02/vis/db/12.1.0/appsutil/out/VIS_visionerp/restore-single2.log";
11> alter database open resetlogs;
12> shutdown normal
13> startup mount pfile=/u02/vis/db/12.1.0/dbs/RMANinit.ora
14> exit
host command complete

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 12/03/2022 09:40:03
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/u01/R122_EBS/data/sys1.dbf'

Recovery Manager complete.
[root@visionerp u03]#

[satish]

Dear Erman,

Datafiles are restored in below location by rapidwiz

[root@visionerp data]# pwd
/u02/vis/db/data
[root@visionerp data]# ls
archive1.dbf dm_olaptrain_arc.dbf owb1.dbf summary6.dbf sys8.dbf system19.dbf tx_data18.dbf tx_data3.dbf tx_idx14.dbf tx_idx3.dbf
a_ref03.dbf media1.dbf queues1.dbf summary7.dbf sys9.dbf system20.dbf tx_data19.dbf tx_data4.dbf tx_idx15.dbf tx_idx4.dbf
a_ref04.dbf media2.dbf queues2.dbf sys10.dbf sysaux01.dbf tx_data10.dbf tx_data1.dbf tx_data5.dbf tx_idx16.dbf tx_idx5.dbf
a_ref05.dbf media3.dbf reference1.dbf sys11.dbf sysaux02.dbf tx_data11.dbf tx_data21.dbf tx_data6.dbf tx_idx17.dbf tx_idx7.dbf
cntrl01.dbf nologging1.dbf reference2.dbf sys1.dbf system12.dbf tx_data12.dbf tx_data22.dbf tx_data7.dbf tx_idx19.dbf tx_idx8.dbf
cntrl02.dbf nologging3.dbf summary1.dbf sys2.dbf system13.dbf tx_data13.dbf tx_data23.dbf tx_data9.dbf tx_idx1.dbf tx_idx9.dbf
cntrl03.dbf odm.dbf summary3.dbf sys4.dbf system15.dbf tx_data15.dbf tx_data24.dbf tx_idx10.dbf tx_idx20.dbf undotbs001.dbf
ctx1.dbf omo1.dbf summary4.dbf sys5.dbf system16.dbf tx_data16.dbf tx_data25.dbf tx_idx11.dbf tx_idx21.dbf undotbs002.dbf
dcm.dbf opmtr01.dbf summary5.dbf sys6.dbf system17.dbf tx_data17.dbf tx_data27.dbf tx_idx13.dbf tx_idx2.dbf xdb01.dbf
[root@visionerp data]#

But it is trying to find in different location which is not existing
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/u01/R122_EBS/data/sys1.dbf'----------->

[root@visionerp u03]# ls -ld /u01/R122_EBS/
ls: cannot access '/u01/R122_EBS/': No such file or directory
[root@visionerp u03]#

Need your support

Thanks,
Satish

[satish]

Dear erman ,

Issue with stage area.We downloaded again using wget.sh and it went smooth.

Installation of vision instance is completed.Do we have to update to latest version R12.2.12 for vision instance as well?
Thank you

[ErmanArslansOracleBlog]

Good. The issue resolved then. (stage area invalid)
About your EBS vision question; It depends on what you will do with it. If you will just have a quick look, run some processes for DEMO, then you can just use the default installed one. But if you will do deep dives, run ERP processes like a good demo, then yes, you should upgrade that vision.