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 03, 2023
Applies to:
Oracle WebCenter Portal - Version 12.2.1.2.0 to 12.2.1.3.0Information 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.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:
- Run the upgrade assistant as follows:
./ua -readiness -logLevel TRACE -logDir /tmp/log12213upg - 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 |