Ameer Khan

Convert database to physical standby command errored with ORA-01017: invalid username/password; logon denied

So during execution of convert to physical standby using dgbroker utility , an error of ORA-01017: invalid username/password; logon denied is observed.

[oracle@server1]$ dgmgrl / DGMGRL for Linux: Release 19.0.0.0.0 – Production on Thu Jan 19 02:11:48 2023 Version 19.16.0.0.0   Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.   Welcome to DGMGRL, type “help” for information. Connected to “PROD” Connected as SYSDG. DGMGRL> connect sys@PROD Password: Connected to “PROD” Connected as SYSDBA. DGMGRL> CONVERT DATABASE sbdb to PHYSICAL STANDBY; Converting database “sbdb” to a Physical Standby database, please wait… Operation requires shut down of instance “PROD” on database “sbdb” Shutting down instance “PROD”… ORA-01017: invalid username/password; logon denied

Solution:-

There could be a few possibilities.

1.       Make sure the sys user password you are using is correct.

2.       The password file in both primary and standby database is same and valid.

3.       Sometimes error can be observed if case sensitive parameter is different between primary and standby

However after making sure all the above points , we were still failing to convert the snapshot standby database into physical standby.

To resolve this, we need to connect to dgmgrl utility as sys user and then perform the conversion.

[oracle@az-pspddb2 flashback]$ dgmgrl / DGMGRL for Linux: Release 19.0.0.0.0 – Production on Thu Jan 19 02:11:48 2023 Version 19.16.0.0.0   Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.   Welcome to DGMGRL, type “help” for information. Connected to “PROD” Connected as SYSDG. DGMGRL> connect sys@PROD Password:<Provide sys password> Connected to “PROD” Connected as SYSDBA.               DGMGRL> CONVERT DATABASE sbdb to PHYSICAL STANDBY;               Converting database “sbdb” to a Physical Standby database, please wait… Operation requires shut down of instance “PROD” on database “sbdb”               Shutting down instance “PROD”…              Connected to “SBDB”              Database closed. Database dismounted. ORACLE instance shut down. Operation requires start up of instance “PROD” on database “sbdb”               Starting instance “PROD”…              Connected to an idle instance. ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0               ORACLE instance started.             Connected to “SBDB”              Database mounted.