Know How

SOA 12c: When Running the Upgrade Assistant (UA) Readiness Check, Getting the Following Error “UPGAST-00214: Unable to Connect to Database as the Schema User xxxx” During SOA Upgrade to 12.2.14:

Error:

Failed to establish a connection to data source “WLSSchemaDataSource” because of the error “UPGAST-00214: Unable to connect to database as the schema user “xxxx”

STEPS

1. Go to path <FMW_HOME>/oracle_common/upgrade/bin
2. Execute the UA in readiness mode by running the following command
./ua -readiness

Solution:

The issue is caused by the conflicting JDBC resource ‘WLSSchemaDataSource’ in the file <FW_HOME>/soa_domain/config/config.xml 

Please follow the below steps to resolve the issue:

Step 1:    Take the backup of config.xml in the following path
/u01/fw_home/user_projects/domains/soa_domain/config/config.xml

Step 2:    Edit the config.xml and remove the below section in the config.xml and save
<jdbc-system-resource>
<name>xxxxDataSource</name>
<target></target>
<descriptor-file-name>jdbc/xxxxDataSource-jdbc.xml</descriptor-file-name>
</jdbc-system-resource>

Step 3:    Execute the UA in readiness mode.

Let's make something intelligent together