SOA Domain Creation Issue – Schema test failed

If Schema test fails during domain creation, you need to update that particular record in the database table.

connect sys/welcome1 as sysdba;
grant DBA to DEV_MDS;
update schema_version_registry set version=’11.1.1.7.0′ where owner= ‘DEV_MDS’;
update schema_version_registry set version=’11.1.1.7.0′ where owner= ‘DEV_SOAINFRA’;
commit;

Hope this helps!

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s