Adding a standby database to a dataguard configuration fails with ORA-1017 (Doc ID 1072022.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.

Symptoms

Physical standby database works fine, archive logs are transferred and applied successfully.

Creating  a new standby database and adding it to the existing broker configuration with
dgmgrl fails with ORA-1017:

DGMGRL> CREATE CONFIGURATION 'MYXETEPDG' AS
> PRIMARY DATABASE IS 'MYXETEP'
> CONNECT IDENTIFIER IS 'MYXETEP.WORLD;
Configuration "MYXETEPDG" created with primary database "MYXETEP"

DGMGRL> ADD DATABASE 'MYXETEPS'
> AS CONNECT IDENTIEFIER IS MYXETEPS.WORLD;


The drc*.log show fallowing error:

2010-03-04-19:45:27 0 2 975167469 DMON: Entered rfm_get_chief_lock() for ADD_DATABASE, reason 0
DG 2010-03-04-19:45:27 0 2 975167469 DMON: chief lock convert for write op ADD_DATABASE
DG 2010-03-04-19:45:27 0 2 0 Connection to database MYXETEPS returns ORA-01017.
DG 2010-03-04-19:45:27 0 2 0 Please check database MYXETEPS is using a remote password file,
DG 2010-03-04-19:45:27 0 2 0 its remote_login_passwordfile is set to SHARED or EXCLUSIVE,
DG 2010-03-04-19:45:27 0 2 0 and the SYS password is the same as this database.
DG 2010-03-04-19:45:27 0 2 0 DMON: Failed to connect to remote database MYXETEPS. Error is ORA-01017
DG 2010-03-04-19:45:27 0 2 0 DMON: Failed to get properties from remote database MYXETEPS. Error is ORA-01017.
DG 2010-03-04-19:45:27 0 2 975167469 Add site succeeded.
DG 2010-03-04-19:45:27 0 2 975167469 Adding internal resource MYXETEPS pid 2001000 parent_state ONLINE (1) vinst 0
DG 2010-03-04-19:45:27 0 2 975167469 -- default_state OFFLINE (0)
DG 2010-03-04-19:45:27 0 2 975167469 Adding internal resource MYXETEPS pid 2001000 parent_state PRIMARY (3) vinst 1
DG 2010-03-04-19:45:27 0 2 975167469 -- default_state READ-WRITE-XPTON (9)
DG 2010-03-04-19:45:27 0 2 975167469 Adding internal resource MYXETEPS pid 2001000 parent_state STANDBY (4) vinst 2
DG 2010-03-04-19:45:27 0 2 975167469 -- default_state PHYSICAL-APPLY-ON (4)
DG 2010-03-04-19:45:27 0 2 0 Connection to database MYXETEPS returns ORA-01017.
DG 2010-03-04-19:45:27 0 2 0 Please check database MYXETEPS is using a remote password file,
DG 2010-03-04-19:45:27 0 2 0 its remote_login_passwordfile is set to SHARED or EXCLUSIVE,
DG 2010-03-04-19:45:27 0 2 0 and the SYS password is the same as this database.




Changes

This is an enhancement in 11g R1 where we are using strong password authentication. With this feature
the passwords  are case sensitive.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms