Oracle Access Manager (OAM) Upgrade Assistant -(UA) Readiness Check Fails "UPGAST-00214: Unable to connect to database as the schema user ... Invalid connection string format, a valid format is: host:port:sid"
(Doc ID 2874515.1)
Last updated on OCTOBER 18, 2023
Applies to:
Oracle Access Manager - Version 11.1.2.3.0 and laterInformation in this document applies to any platform.
Symptoms
Running ua -readiness fails UPGAST-00214
- Planing to upgrade Oracle Access Manager (OAM) from 11.1.2.3.0 to 12.2.1.3.0
Steps To Reproduce
1. Log in to Oracle Fusion Middleware as a WebLogic Install user.
2. Enter:
4. At the Welcome dialog box, click Next.
5. At the Schemas and Configurations dialog box, select Domain Based.
6. At the Domain Directory field, click Browse to browse to the domain directory and click Next.
7. Enter DBA account information and select “Connect” …
Note this is where the issue is at. In the section “Database Connect String filed, which is grayed out, it has <FQDN>Host:<SQL_PORT>/<SERVICE_NAME>. This fails and the error seen is
| Error: UPGAST-00214: Unable to connect to database as the schema user "<PREFIX>_OPSS". |
| Cause: The database connection failed for the specified reason. |
|
Action: See the secondary error message for additional details. IO Error: Invalid connection string format, a valid format is: "host:port:sid" |
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |