DGMGRL Error : ORA-01017: invalid username/password; logon denied
DGMGRL> switchover to india_stby;
Performing switchover NOW, please wait...
Operation requires a connection to database "india_stby"
Connecting ...
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
connect to instance "india_stby" of database "india_stby"
we have to provide sys user credentials (username/password pair) to connect to database in DGMGRL also check sec_case_sensitive_logon database parameter .
In order to resolve ORA-01017 this error , we have to connect to dgmgrl utility using below method :
[oracle@ip-10-0-1-12 ~]$ dgmgrl
DGMGRL for Linux: Release 12.2.0.1.0 - Production on Tue May 25 14:02:07 2021
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys@india
Password:
Connected to "india"
Connected as SYSDBA.
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration;
Configuration - india
Protection Mode: MaxPerformance
Members:
india - Primary database
india_stby - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 48 seconds ago)
DGMGRL>
DGMGRL>
DGMGRL> switchover to india_stby
Performing switchover NOW, please wait...
Operation requires a connection to database "india_stby"
Connecting ...
Connected to "india_stby"
Connected as SYSDBA.
New primary database "india_stby" is opening...
Operation requires start up of instance "india" on database "india"
Starting instance "india"...
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Database mounted.
Database opened.
Connected to "india"
Switchover succeeded, new primary is "india_stby"
DGMGRL>
No comments:
Post a Comment