We're running EBS 12.2.7 after we upgraded databse 19c (Multi-tenant enabled) we have a problem in the clone
we're following Note 2552208.1
Production is :
instance : CDBTEST
PDB : PROD
Test is:
instance : CDBTEST
PDB : TEST
no RAC in production and test.
we've done all steps successfully till 4.1.6 where we stuck
4.1 Clone and Configure the Target Database
4.1.1 Copy and Uncompress ORACLE_HOME
4.1.3 Create Context File
4.1.3.1 Create the Context File for a Single-Node Database
4.1.4 Configure the Database Technology Stack
4.1.5 Create the listener.ora and tnsnames.ora for the Target Database
4.1.6 Restore and Start the Target Database <<--------------
we restored our production database, and now the restored database is under path:
/oracle/db/apps_st/CDBPROD --> container
/oracle/db/apps_st/data --> prod pdb
Our problem:
-------------
we cannot start or mount the database, because there is no init file in $ORACLE_HOME/dbs
SQL> startup nomount;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/db/tech_st/19.3.0/dbs/initCDBTEST.ora'
SQL>
I reviewed the logs and noticed the following in ApplyDatabase_06301136.log
Error:
File /oracle/db/tech_st/19.3.0/dbs/initTEST.ora of type INSTALL does not exist, will be instantiated in the current pass
AC-00423: Template file: /oracle/db/tech_st/19.3.0/appsutil/template/afinit_db190.ora missing from file system.
Raised by oracle.apps.ad.autoconfig.InstantiateProcess
I checked files in appsutil/template and found the file with name : afinit_db19.ora however the script is looking for afinit_db190.ora
-rw-r--r--. 1 orauser dba 21604 Apr 23 17:08 afinit_db19.ora