from primary server, can't login to standby database as sysdba
edited Jan 29, 2019 4:08AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered
Hello,
I just created a phsical standby database, it can sync with primary db automatically without problem. so it is good,
while the problme I have is:
from primary server, I STILL can't connect to physical standby db as sysdba, for example
--in primary server, connect to standby db cat_stby in standby server
>sqlplus sys/xxx@cat_stby as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Dec 12 15:18:19 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
select db_unique_name, database_role from v$database;
DB_UNIQUE_NAME DATABASE_ROLE
------------------------------ ----------------
0