tnsnames.ora

How to Resolve ORA-00132: syntax error or unresolved network name

by Ed Chen
March 31, 2023March 27, 2023

ORA-00132 Found error ORA-00132 in the alert log, when we're starting up a database. 2023-03-01T22:41:54.802021-05:00 WARNING: Invalid value for listener related parameter MIXED LISTENER 2023-03-01T22:41:54.803545-05:00… Read More »

How to Install Oracle Instant Client 19c on Linux

by Ed Chen
March 1, 2023February 15, 2023

Suppose that you have known the differences between Oracle client and Oracle instant client, and decide to install Oracle instant client for your machine. On… Read More »

How to Run NETCA in Silent Mode

by Ed Chen
February 13, 2023February 18, 2023

By design, we split the entire installation into several clear sections and make the job easy to troubleshoot. Install Oracle Software Only in Silent Mode… Read More »

SQLPlus Connect and Disconnect

by Ed Chen
December 16, 2022February 22, 2023

SQLPlus 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 »

Toad for Oracle - Unable to find RAC connection information for

How to Resolve Toad Error: Unable to find RAC connection information for INST_ID

by Ed Chen
March 28, 2022January 22, 2023

Unable to find RAC connection information for INST_ID A developer tried to run a procedure with debug mode in Toad for Oracle, a database tool… Read More »

Where is Tnsnames.ora Location

by Ed Chen
January 19, 2022November 19, 2022

tnsnames.ora Suppose you have known the usage of TNSNAMES, now let's see where we can find it in this post. In fact, the location of… Read More »

TNSNAMES, How and Why

by Ed Chen
January 18, 2022March 6, 2023

Local Naming = TNSNAMES Whenever we need to connect to the database, we usually provide a connection string like this: SQL> conn username/password@chicago-db-server:1521/ORCL Connected. Or… Read More »

How to Resolve ORA-17629: Cannot connect to the remote database server

by Ed Chen
September 1, 2021April 12, 2022

ORA-17629 ORA-17629 means that it cannot connect to the remote database because of some underlying errors occurred, most likely, there're some error returned. In the… Read More »

How to Resolve ORA-12528: TNS:listener: all appropriate instances are blocking new connections

by Ed Chen
June 14, 2021February 8, 2023
6 Comments

ORA-12528 Tried to connect a NOMOUNT database, but it failed with ORA-12528. C:\Users\ed>sqlplus sys/password@orcl as sysdba ... ERROR: ORA-12528: TNS:listener: all appropriate instances are blocking… Read More »

How to Resolve ORA-12505: TNS:listener does not currently know of SID given in connect

by Ed Chen
March 20, 2021June 30, 2022

ORA-12505 ORA-12505 means that the SID you provided in the connect identifier does not match any SID registered with the listener. Basically, SID means $ORACLE_SID,… Read More »