1 Reply Latest reply on Jul 3, 2020 9:26 AM by mdtaylor

    Cloning EBS with CDB Database 19c

    Moh.Sayed

      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