My Oracle Support Banner

The Upgrade Assistant (UA) Fails To Connect to the Portal Schema in the Database when Upgrading to 12.2.1.3: "Unable to connect to database as the schema user "XXX_PORTAL" " (Doc ID 2469499.1)

Last updated on JULY 10, 2020

Applies to:

Oracle WebCenter Portal - Version 12.2.1.2.0 to 12.2.1.3.0
Information in this document applies to any platform.

Symptoms

The Upgrade Assistant (UA) Fails To Connect to the Portal Schema in the Database When Upgrading to 12.2.1.3.

The upgrade assistant log file will show the following errors:



ERROR

[2018-11-01T09:20:12.606-04:00] [simplefan] [ERROR] [] [oracle.simplefan.FanManager] [tid: <TID>] [ecid: <ECID>] attempt to configure ONS in FanManager failed with oracle.ons.NoServersAvailable: Subscription time out
[2018-11-01T09:20:12.607-04:00] [Framework] [ERROR] [] [upgrade.Framework] [tid: <TID>] [ecid:<ECID>] java.lang.IllegalArgumentException: ONS configuration failed
[2018-11-01T09:20:12.608-04:00] [Framework] [ERROR] [] [upgrade.Framework] [tid: <TID>] [ecid: <ECID>] oracle.ons.NoServersAvailable: Subscription time out
[2018-11-01T09:20:12.608-04:00] [Framework] [ERROR] [UPGAST-00214] [upgrade.Framework] [tid: <TID>] [ecid: <ECID>] Unable to connect to database as the schema user "XXX_PORTAL".
[2018-11-01T09:20:12.608-04:00] [Framework] [ERROR] [] [upgrade.Framework] [tid: <TID>] [ecid: <ECID>] Cause: The database connection failed for the specified reason.
[2018-11-01T09:20:12.608-04:00] [Framework] [ERROR] [] [upgrade.Framework] [tid: <TID>] [ecid: <ECID>] Action: See the secondary error message for additional details.
[2018-11-01T09:20:12.609-04:00] [Framework] [ERROR] [] [upgrade.Framework] [tid: <TID>] [ecid: <ECID>] [[
java.lang.IllegalArgumentException: ONS configuration failed
   at oracle.simplefan.impl.FanManager.configure(FanManager.java:108)
   at oracle.jdbc.driver.HAManager.configure(HAManager.java:147)
   at oracle.jdbc.driver.HAManager.<init>(HAManager.java:123)
   at oracle.jdbc.driver.HAManager.getInstance(HAManager.java:127)
   at oracle.jdbc.driver.HAManager.enableHAIfNecessary(HAManager.java:726)
   at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:864)
   at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:40)
   at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:704)
   at java.sql.DriverManager.getConnection(DriverManager.java:664)
   at java.sql.DriverManager.getConnection(DriverManager.java:208)
   at oracle.ias.update.plan.SchemaConnection.getJdbcConnection(SchemaConnection.java:514)
   at oracle.ias.update.plan.SchemaConnection.<init>(SchemaConnection.java:148)
   at oracle.ias.update.plugin.DataSource.getConnection(DataSource.java:341)
...

Caused by: oracle.ons.NoServersAvailable: Subscription time out
   at oracle.ons.NotificationNetwork.waitUntilOnline(NotificationNetwork.java:96)
   at oracle.ons.ONS.init(ONS.java:96)
   at oracle.ons.ONS.<init>(ONS.java:154)
   at oracle.simplefan.impl.FanManager$1.run(FanManager.java:102)
   at oracle.simplefan.impl.FanManager$1.run(FanManager.java:100)
   at java.security.AccessController.doPrivileged(Native Method)
   at oracle.simplefan.impl.FanManager.configure(FanManager.java:100)
   ... 33 more

[2018-11-01T09:20:12.612-04:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: <TID>] [ecid: <ECID>] The auto-datasource mode is ignoring data source XXX_PORTAL because the connection failed with the error: UPGAST-00214: Unable to connect to database as the schema user "XXX_PORTAL".
...

[2018-11-01T09:20:15.227-04:00] [Framework] [INCIDENT_ERROR] [UPGAST-00180] [upgrade.Framework] [tid: <TID>] [ecid: <ECID>] error loading upgrade plug-in for MDS.SCHEMA_UPGRADE
[2018-11-01T09:20:15.227-04:00] [Framework] [INCIDENT_ERROR] [] [upgrade.Framework] [tid: <TID>] [ecid: <ECID>] Cause: An unexpected error occurred loading an upgrade plug-in.
[2018-11-01T09:20:15.228-04:00] [Framework] [INCIDENT_ERROR] [] [upgrade.Framework] [tid: <TID>] [ecid: <ECID>] Action: Contact My Oracle Support. See the secondary error message for additional details.

[2018-11-01T09:20:15.228-04:00] [Framework] [INCIDENT_ERROR] [] [upgrade.Framework] [tid: <TID>] [ecid: <ECID>] [[
oracle.ias.update.exception.AutoDataSourceException: Failed to establish a connection to data source "XXX_PORTAL" because of the error "UPGAST-00214: Unable to connect to database as the schema user "XXX_PORTAL"."
   at oracle.ias.update.wls.WLSEnvironment.autoDiscoverDASU(WLSEnvironment.java:1137)
   at oracle.ias.update.wls.WLSEnvironment.isComponentConfiguredInDomain(WLSEnvironment.java:905)
   at oracle.ias.update.wls.WLSEnvironment.handleComponentInDomain(WLSEnvironment.java:845)
   at oracle.ias.update.wls.WLSEnvironment.enableConfiguredApps(WLSEnvironment.java:795)
   at oracle.ias.update.gui.UAPreviewPage.finishPrepareData(UAPreviewPage.java:311)
   at oracle.ias.update.gui.UAPreviewPage.access$100(UAPreviewPage.java:177)

[2018-11-01T09:20:15.236-04:00] [Framework] [ERROR] [] [upgrade.Framework] [tid: <TID>] [ecid: <ECID>] Failed to establish a connection to data source "XXX_PORTAL" because of the error "UPGAST-00214: Unable to connect to database as the schema user "XXX_PORTAL"."

[2018-11-01T09:20:15.236-04:00] [Framework] [TRACE] [] [upgrade.Framework] [tid: <TID>] [ecid: <ECID>] Failed to establish a connection to data source "XXX_PORTAL" because of the error "UPGAST-00214: Unable to connect to database as the schema user "XXX_PORTAL"."




STEPS

The issue can be reproduced at will with the following steps:

  1. Run the upgrade assistant as follows:

    ./ua -readiness -logLevel TRACE -logDir /tmp/log12213upg

  2. The error will be shown in the upgrade assistant log.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.