Enable Non-Oracle User Run SQL*Plus
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 »Enable Non-Oracle User Run SQL*Plus
TNSNAMES
Toad No Valid Oracle Clients Found
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 »Toad No Valid Oracle Clients Found
PL/SQL Developer Initialization error, Oracle Client not properly installed
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 »PL/SQL Developer Initialization error, Oracle Client not properly installed
tnsnames.ora in SQL Developer
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 »tnsnames.ora in SQL Developer
How NETCA Add Net Service Name
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 NETCA Add Net Service Name
How to Resolve ORA-00132: syntax error or unresolved network name
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 Resolve ORA-00132: syntax error or unresolved network name
SQLPlus Connect and Disconnect
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 »SQLPlus Connect and Disconnect
TNSNAMES, How and Why
Local Naming = TNSNAMES Whenever we need to connect to the database, we usually provide a connection string by easy connect like this: SQL> conn… Read More »TNSNAMES, How and Why
How to Resolve ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12154 ORA-12154 means that your connection tools (e.g. 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
SQLPlus Connect without Tnsnames
SQLPlus without Tnsnames We usually connect a database by sqlplus through tnsnames.ora, but sometimes we are not allowable to change or access tnsnames.ora, even worse,… Read More »SQLPlus Connect without Tnsnames