Re: R12.1.3 upgrade to R12.2

Posted by satish on Apr 17, 2023; 8:10am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/R12-1-3-upgrade-to-R12-2-tp11789p11797.html

Dear Erman,

So,can we start upgrade from R12.1.3 to R12.2 without adding patch service ebs_patch to service_names parameter?

Before your update,i have added like

SQL>  alter system set service_names='ssscdba','ebs_patch' scope=both ;

System altered.

-bash-4.2$ lsnrctl status ssscdba

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 17-APR-2023 13:38:52

Copyright (c) 1991, 2022, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=abc.dummy.org)(PORT=1111)))
STATUS of the LISTENER
------------------------
Alias                     ssscdba
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                16-APR-2023 16:08:44
Uptime                    0 days 21 hr. 30 min. 8 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u02/CRP/db/19chome/network/admin/listener.ora
Listener Log File         /u02/CRP/db/19chome/log/diag/tnslsnr/sssterpdev1/ssscdba/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=abc.dummy.org)(PORT=****)))
Services Summary...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
  Instance "ssscdba", status READY, has 1 handler(s) for this service...
Service "ebs_SSSTTEST" has 1 instance(s).
  Instance "ssscdba", status READY, has 1 handler(s) for this service...
Service "ebs_patch" has 1 instance(s).
  Instance "ssscdba", status READY, has 1 handler(s) for this service...
Service "f9355dee6dfab2bfe0530905000a3c6b" has 1 instance(s).
  Instance "ssscdba", status READY, has 1 handler(s) for this service...
Service "ssscdba" has 1 instance(s).
  Instance "ssscdba", status READY, has 1 handler(s) for this service...
Service "ssscdbaXDB" has 1 instance(s).
  Instance "ssscdba", status READY, has 1 handler(s) for this service...
Service "sssttest" has 1 instance(s).
  Instance "ssscdba", status READY, has 1 handler(s) for this service...
The command completed successfully
-bash-4.2$

Please correct me,if i need to revert back service_names parameter to ssscdba.

Thanks,
Satish