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

    Cloning EBS with CDB Database 19c


      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 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'




      I reviewed the logs and noticed the following in ApplyDatabase_06301136.log




      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