Since 11g, we rely more and more on SCAN Virtual IP to load balance and failover connections among nodes of a cluster, so the original… Read More »How Oracle RAC VIP Failover to Another Node
OS Authentication We usually connect to the database by / AS SYSDBA without providing any password for maintenance works, such as startup, shutdown and backup.… Read More »How to Connect a PDB Directly by OS Authentication
32-bit or 64-bit In some situations, we need to know whether our Oracle client is 32-bit or 64-bit in order to use the right tool… Read More »How to Check Oracle Client Version 32-bit or 64-bit
Connected to an idle instance Actually, Connected to an idle instance is a message rather than an error, it indicates that the database you entered… Read More »How to Resolve "Connected to an idle instance"
ORA-12154 ORA-12154 means that your connection tools including sqlplus cannot use TNSNAMES naming method for some reason. This reminds me that there're same error patterns… Read More »How to Resolve ORA-12154: TNS:could not resolve the connect identifier specified