SQLPlus Connect and Disconnectby Ed ChenDecember 16, 2022February 22, 2023SQLPlus Connect To connect a database, we usually use sqlplus, a text-based connection tool provided by Oracle to facilitate clients to connect to a running… Read More »SQLPlus Connect and Disconnect
Connect-Time Failover to Standby Databaseby Ed ChenMay 11, 2019January 29, 20218 CommentsWe'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 »Connect-Time Failover to Standby Database
How to Resolve TNS-03505: Failed to resolve nameby Ed ChenFebruary 9, 2019December 10, 20222 CommentsTNS-03505 Failing to resolve TNS names could involve any one of the network configuration files, such as tnsnames.ora or sqlnet.ora. There're several possible causes may… Read More »How to Resolve TNS-03505: Failed to resolve name
How to Install Oracle Instant Client 19c on Windowsby Ed ChenMay 21, 2016April 25, 2023The term "install" may be a little improper for Oracle Instant Client, because the packages are all zipped and portable, there's no need to actually… Read More »How to Install Oracle Instant Client 19c on Windows
How to Set Client-Side Transparent Application Failover (TAF)by Ed ChenOctober 21, 2012December 11, 2022Transparent Application Failover (TAF) Besides connect-time failover to the standby database, there is a function called Transparent Application Failover (TAF) can do run-time failover to… Read More »How to Set Client-Side Transparent Application Failover (TAF)