DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, January 17, 2018

AD Administration error:Connected to db edition other than RUN and PATCH

Issue:

When we try to compile apps schema through adadmin

AD Administration error:
Connected to db edition other than RUN and PATCH:

AD Administration error:
Edition_Name

When tried to change a USER password through FNDCPASS.

The FNDCPASS tool cannot be run against the patch edition

Change :

Recently applied a patch and did the successful cutover.

Solution :

1.
Find the default edition of the database.

SELECT property_value FROM   database_properties WHERE  property_name = 'DEFAULT_EDITION';

SQL> SELECT property_value FROM   database_properties WHERE  property_name = 'DEFAULT_EDITION';

PROPERTY_VALUE
--------------------------------------------------------------------------------
V_20180115_0214

2.
Find service names of the DB

SQL> show parameter service

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      EBSDB, ebs_patch

3.

Find the edition name which is associated with service_name, it should be same as default edition of the database.

select NAME,EDITION from sys.service$ where name = 'EBSDB'


NAME                           EDITION
------------------------------ ------------------------------
EBSDB                          V_20180115_0203

3.
Update sys.service$ table manually to reflect edition to default edition.

update sys.service$
set EDITION = 'V_20180115_0214'
where NAME = 'EBSDB';

1 row updated.

Commit;

Restart DB to reflect this.

Note : We have tried this in one of our development instance, in case if you are trying this in critical production , please raise SR with oracle before updating sys.service$.

No comments: