tnsnames.ora

How to Revert Read-Only Oracle Home 21c Linux

by Ed Chen
July 10, 2023August 31, 2023

Read-Only Oracle Home After installing Oracle database 21c on Linux, we found that some features are different from our sense. That's because Read-Only ORACLE_HOME is… Read More »

Enable Non-Oracle User Run SQL*Plus

by Ed Chen
June 29, 2023September 6, 2023

Let's see how we enable an user other than the owner of Oracle product to run SQL*Plus. Windows In Windows platform, once oracle database has… Read More »

Toad No Valid Oracle Clients Found

by Ed Chen
June 9, 2023June 29, 2023

At the first time startup of Toad for Oracle, you may want to new a connection to start to use the tool. But sometimes, you… Read More »

PL/SQL Developer Initialization error, Oracle Client not properly installed

by Ed Chen
June 8, 2023June 29, 2023

At the first time startup of PL/SQL developer, you may want to new a connection to start to use the tool. But sometimes, you might… Read More »

tnsnames.ora in SQL Developer

by Ed Chen
June 7, 2023June 29, 2023

At the first time startup of SQL developer, you may want to new a connection to start to use the tool. But sometimes, you might… Read More »

How NETCA Add Net Service Name

by Ed Chen
April 12, 2023April 6, 2023

Usually, we copy, paste and modify the block of a TNS entry in tnsnames.ora to create a new net service name for local naming. For… Read More »

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, 2023June 6, 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, 2022July 2, 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 »

JavaScript is not enabled. Please enable it and reload the page.