Static Service Registration

How to Resolve ORA-12526: TNS:listener: all appropriate instances are in restricted mode

by Ed Chen
November 17, 2021June 11, 2022

ORA-12526 When we tried to connect to the database, it failed with ORA-12526 like the following. SQL> conn hr/hr@orcl ERROR: ORA-12526: TNS:listener: all appropriate instances… Read More »

How DGMGRL Switchover to Standby

by Ed Chen
August 28, 2019December 10, 2022

DGMGRL Switchover Suppose that you have configured data guard broker for 19c primary and standby databases, we can test switchover by DGMGRL, an interactive broker… Read More »

Connect-Time Failover to Standby Database

by Ed Chen
May 11, 2019January 29, 2021
8 Comments

We're going to introduce 3 ways that can failover to a standby database at connect-time in this post. Using a Persistent Service Name Using a… Read More »

How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect

by Ed Chen
February 14, 2019December 10, 2022
28 Comments

ORA-12514 ORA-12514 means that the listener cannot find any matched service with yours, so it cannot establish the connection with the database for you. As… Read More »

How to Connect Idle, Nomount or Restricted Database Remotely

by Ed Chen
October 10, 2012December 11, 2022

Connect an Idle, Nomount or Restricted Database Locally Users who belong to OSDBA or OSOPER can access a database in any states including idle, NOMOUNT… Read More »