Re: DB Edition versions

Posted by big on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/DB-Edition-versions-tp10984p10995.html

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.