R12.1.3 upgrade to R12.2

Posted by satish on Apr 16, 2023; 6:19am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/R12-1-3-upgrade-to-R12-2-tp11789.html

Dear Erman,

Environment:

Database 19.17
Apps R12.1.3

AD/TXL delta 12


ssscdba is CDB
SSSTTEST is PDB


We are upgrading application to R12.2. Not yet started

By default, service_names parameter is set to CDB which is ssscdba in our case as below. Do we need to add patch service name to service_names parameter prior to upgrade?

We are on AD/TXK delta 12. Preupgrade analyser says "Not to modify service_names parameter when using 19c"


SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 SSSTTEST                       READ WRITE NO


SQL> sho parameter service

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      ssscdba

SQL> alter session set container=SSSTTEST;

Session altered.

SQL> sho parameter service

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      ssscdba
SQL>


Active services in PDB

SQL> select NAME,CON_ID from v$services;
 

NAME                                                                 CON_ID
---------------------------------------------------------------- ----------
sssttest                                                                  3
ebs_SSSTTEST                                                              3



From preupgrade analyser:

18. Check Name : Additional Database Initialization Parameters For Oracle E-Business Suite Release 12.2
Refer: Chapter 4: Performing the upgrade => Performing the Upgrade to Release 12.2.0 => See Database Initialization Parameters for Oracle Applications Release 12.2 (Doc ID: 396009.1)

        Initialization parameters required at each stage of an upgrade may vary depending on when you upgrade your database.
        Set the appropriate parameters now.

        The important 12.2 specific parameters are:

        recyclebin = off
        service_names=%s_dbSid%,ebs_patch

        Some of the Additional Database Initialization parameters are not set or not valid. Please set the appropriate parameters now.
        Current set parameters are:
        recyclebin = on
        service_names = ssscdba


        Note:  For Oracle Database 19c with a single tenant (1 CDB:1 PDB) configuration : -
                service_names: The value for this parameter is auto-populated when CDB is created. This parameter should not be modified manually.

Please advice..

Thanks,
SG