High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

dgmgrl dg_admin username/password invalid even though right password is used

We are using dg_admin for our observer setup for fast start failover but even though we are using dg_admin correct password still we are getting the below error

ORA-01017: invalid username/password; logon denied


Please find the below output


udbenp1 SQL> SELECT USERNAME FROM V$PWFILE_USERS WHERE USERNAME != 'SYS' AND SYSDG='TRUE';


USERNAME

--------------------------------------------------------------------------------

DG_ADMIN


$ sqlplus dg_admin/XXXXXX@UDBENP_ENV1_OBSRV


SQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 6 09:35:47 2020

Version 19.7.0.0.0


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


Last Successful login time: Mon Oct 05 2020 11:35:14 +00:00


Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.7.0.0.0


UDBENP_ENV1_OBSRV SQL> exit

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center