Tool

How to Resolve ORA-12162: TNS:net service name is incorrectly specified

by Ed Chen
March 29, 2023March 20, 2023

ORA-12162 To know how to solve ORA-12162 depends on where the database is. A local database? or an external database? Local Database A local database… 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 SQL Developer Monitor SQL

by Ed Chen
January 13, 2023December 22, 2022

Real Time SQL Monitor Select Connection Then select which database you want to connect to and monitor. SQL List DBA Panel In fact, the "Real… Read More »

SQL Developer Monitor and Kill Sessions

by Ed Chen
January 12, 2023March 24, 2023

Monitor Sessions To monitor sessions in SQL developer, you may find the entry in the function menu of "Tools". Select Connection Then select which database… Read More »

SQL Developer Create Table Partition

by Ed Chen
January 2, 2023November 29, 2022

Since the create a table partitioning syntax is hard to keep in mind, we'd better use GUI tools to facilitate us to create. Here we… 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 »

How to Resolve ORA-0131: insufficient privileges in PL/SQL Developer

by Ed Chen
August 9, 2022October 6, 2022
2 Comments

ORA-0131 A developer reported a weird error ORA-0131 when he connected to the database in PL/SQL developer. In fact, there's no ORA-0131 such error in… Read More »

Garbled Text in PL/SQL Developer

by Ed Chen
June 8, 2022March 20, 2023

Garbled Text We saw unreadable result in PL/SQL Developer after we INSERT INTO 3 rows and SELECT the table. We checked the language of this… Read More »

$Unable to launch the Java Virtual Machine Located at path sqldeveloper\jdk\jre\bin\server\jvm.dll$

How to Resolve Unable to launch the Java Virtual Machine Located at path

by Ed Chen
May 31, 2022March 20, 2023
2 Comments

Unable to launch the Java Virtual Machine Saw an error dialog when I launch SQL Developer for the first time. Unable to launch the Java… Read More »

How to Resolve SP2-0547: size option out of range

by Ed Chen
May 27, 2022September 26, 2022

SP2-0547 Saw error SP2-0547 when we tried to set the buffer size of server output in SQL*Plus. SQL> set serveroutput on size 1000; SP2-0547: size… Read More »