My Oracle Support Banner

Fleet Maintenance: UPDATE DB Command Fails With ORA-01017: Invalid Username/password; Logon Denied (Doc ID 2665730.1)

Last updated on JANUARY 18, 2023

Applies to:

Enterprise Manager for Oracle Database - Version 13.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Applying Patch on 12c standalone database using fleet maintenance.
Submitted UPDATE DB command to perform switch operation:

emcli db_software_maintenance -performOperation -name="Update DB" -purpose=UPDATE_DB -target_type=oracle_database -target_list="<target db>" -normal_credential="ORACLE:SYSMAN" -privilege_credential="ROOT:SYSMAN"

Failed with the below error while trying to start database from new Oracle home:

Running: /oracle/patches/JOB_A3F87301E1E44B6FE053594519AC4351/startDBInstance.pl
Argument count: 31
Perl version: 5.028001
Hostname: <hostname>
Operating system: linux
Time: <date & timestamp>

Thu Apr 23 18:47:05 2020 - Target DB Version is 11.2 or above

Thu Apr 23 18:47:05 2020 - SET UP LISTENER : db_listeners = migrate_status =

Thu Apr 23 18:47:05 2020 - Finding current state of database [<DB_ORACLE_HOME_PATH> (OH), <SID> (SID)] ...

Thu Apr 23 18:47:07 2020 -
 SQL*Plus: Release 12.2.0.1.0 Production on Thu Apr 23 18:47:05 2020
 
 Copyright (c) 1982, 2016, Oracle. All rights reserved.
 
 SQL> SQL> ERROR:
 ORA-01017: invalid username/password; logon denied

Connecting to Database using sqlplus failed with the same error:

[oracle@hostname ~]\ [SID]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 29 16:41:57 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: ^C


[oracle@hostname ~]\ [SID]$ sqlplus /

SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 29 16:42:05 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied

 

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


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