Cannot Connect to Database with SYS User with Error "Invalid username/password" When Installing RCU Schema (Doc ID 2949058.1)

Last updated on JANUARY 24, 2024

Applies to:

Symptoms

When attempting to install RCU schema for Fusion Middleware 12.2.1.4 to run Agile Product Lifecycle Management (PLM) 9.3.6, getting below error:

Error

oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: Unable to connect to the DB. Check if DB connection details entered are correct.
  Invalid username/password.

Environmental Details

Oracle Database version: 19.3.0.0
Fusion Middleware version: 12.2.1.4
tnsnames.ora is configured correctly.

What is working

Can login as SYS user through sqlplus using the same password.
RCU installation proceeds if SYSTEM user with NORMAL role is selected during the installation.

Steps

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

1. Install Fusion Middleware (FMW) 12.2.1.4
2. Run rcu.bat under: \Middleware\Oracle_Home\oracle_common\bin
3. Set below information:
   Database Type: Oracle Database
   Connection String Format: Connection Parameters
   Host Name: {FQDN of the Database server}
   Port: {port}
   Service Name: {service name}
4. Enter username: SYS and its password, and select Role: SYSDBA and Next
5. Gets error in the RCU installation wizard.

Changes

Cause

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