Wednesday, April 27, 2016

Adop phase=cutover Errors With "ORA-20099: E-Business Suite Patch Edition Does Not Exist" When Database Is Not Active

Adop phase=cutover Errors With "ORA-20099: E-Business Suite Patch Edition Does Not Exist" When Database Is Not Active

Error:
The adop phase=cutover Errors when the patch edition is not active attempting to connect to the database:

appgnei1@pwerpl5211 erpapp]$ echo $TWO_TASK
gpsgnei1_patch
[appgnei1@pwerpl5211 erpapp]$ tnsping gpsgnei1_patch

TNS Ping Utility for Linux: Version 10.1.0.5.0 - Production on 19-DEC-2013 09:22:53

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
/gpsgnei1/erpapp/fs2/inst/apps/gpsgnei1_pwerpl5211/ora/10.1.2/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=pwerpl5211.cloud.test.com)(PORT=1523)) (CONNECT_DATA= (SERVICE_NAME=ebs_patch) (INSTANCE_NAME=gpsgnei1)))
OK (0 msec)
[appgnei1@pwerpl5211 erpapp]$ sqlplus /nolog

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Dec 19 09:22:56 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn apps/clo#1r2ud

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

Cause:

The database patch edition was not active, where when attempting to connect to the database from the application-tier patch edition environment, it failed.

Solution:

This is the expected behavior.  If a database patch edition is not active, then attempting to connect to the database from the application-tier, the patch edition environment will fail.

The following also helps to find to which File System was connected when executed the environment from the fs1 file system:

[appltest@test ~]$ . /d01oracle/R122/EBSapps.env run
E-Business Suite Environment Information
----------------------------------------
RUN File System : /d01/oracle/R122/fs1/EBSapps/appl
PATCH File System : /d01/oracle/R122/fs2/EBSapps/appl
Non-Editioned File System : /d01/oracle/R122/fs_ne
DB Host: test.ora.com Service/SID: TEST
Sourcing the RUN File System ...
[appltest@test]$ sqlplus apps/<appspwd>
SQL*Plus: Release 10.1.0.5.0 - Production on Tue Oct 22 11:28:31 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select ad_zd.get_edition_type from dual;
GET_EDITION_TYPE
--------------------------------------------------------------------------------
RUN

Reference metalink Doc ID 1611655.1

No comments:

Post a Comment