Posted by Sundaravel Ramasubbu
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
4. 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$.
