DB Edition versions

[big]

Hi,
On R12.2.9 DB 19c

There are different versions of database object, Am I correct?

How can we connect to these different versions? I mean other versions than the current.
Thank you.

[ErmanArslansOracleBlog]

We have run edition and patch edition..

For connecting to the patch edition ->

Connect to the patch edition using the EBSapps.env script as follows:

$ source /u01/R122_EBS/EBSapps.env patch
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/R122_EBS/fs2/EBSapps/appl
PATCH File System : /u01/R122_EBS/fs1/EBSapps/appl
Non-Editioned File System : /u01/R122_EBS/fs_ne
DB Host: example.com Service/SID: exzd122x

Sourcing the PATCH File System ...
$ echo $FILE_EDITION
patch
$ sqlplus <apps username>
SQL> select ad_zd.get_edition_type from dual;

GET_EDITION_TYPE
----------------
PATCH

[big]

Hi,
Thanks ERMAN.

Idid:

$ source /u01/R122_EBS/EBSapps.env patch
Sourcing the PATCH File System ...
$ echo $FILE_EDITION
patch
sqlplus apps

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jul 21 13:56:15 2022

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password:
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-20099: E-Business Suite Patch Edition does not exist.
ORA-06512: at line 29

In Doc ID 1611655.1 it says:

This is the expected behavior.  If a database patch edition is not active

Then how to active it?

Following 2360495.1

Idid
SQL> show parameter service_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      mydb, mydb_ebs_patch,d
                                                 mydb_ebs_patch
tnsping mydb_ebs_patch
TNS-03505: Failed to resolve name

In 2378192.1 it is sugessted :

In RUN:
alter trigger ebs_logon disable;
 and then (after work)
x.env patch
sqlplus apps
SQL> select ad_zd.get_edition_type from dual;

GET_EDITION_TYPE
--------------------------------------------------------------------------------
RUN
alter trigger ebs_logon enable;

Any idea?

Regards.

[ErmanArslansOracleBlog]

the concept of patch edition belongs to Online Patching, so start an online patching cycle and then retry that connection.

[big]

Thank you Erman.

I will try it later.

Regards.

[big]

Hi Erman,
Yes I tried it and it worked well.

Regards.