05. 02. 2019.

OpenJDK Mission Control – how to install it properly

If there is one tool that have almost all what is needed for monitoring, troubleshooting and tuning Java apps, that will be OpenJDK Mission Control. There are several reasons why JMC will be hot topic in Java events from now on: More than 95% of all issues related to JVM, application servers, deployed apps and […]

03. 02. 2019.

Starting with Oracle Unit Testing Framework – Part 1

For developers that are using Scrum methodology, it is not important to stress importance of unit tests when developing a new piece of code. Unit tests are important for many reasons like: can find problems in just developed/changed code at the earliest stage (before testing team) are the smallest testable part of application cover just […]

29. 01. 2019.

Putty for Linux copy/paste issue and solution

Putty is probably the most common tool to access Unix/Linux environments on Windows platform by using ssh protocol. Recently I’ve been in situation where I’ve got only Putty generated ppk file to access Unix server. Although I’ve asked if I can get open ssh generated file, that was not possible, as it was assumed that […]

28. 01. 2019.

Easy way to create Virtualbox VM’s internal network

Virtualbox is a very popular hypervisor which allows you to run guest virtual machines like Windows, Linux, BSD, Solaris etc. For various purposes you might want to combine several virtual machines into one network. In this post I’ll describe the easiest way of how to do that, which is good enough for most of the […]

25. 01. 2019.

Installing Oracle JDeveloper on Ubuntu

To complete configuration of Ubuntu machine that I’ll use later for Oracle Development, let’s install JDeveloper, Oracle’s main Java development tool. Although JDeveloper is free, it has never had any significant traction among Java developers. In Java IDE space there are several great competitors, starting with Eclipse, IntelliJ and NetBeans. With such competition it’s difficult […]

24. 01. 2019.

Installing SQL Developer on Ubuntu

Today it is not necessary to introduce SQL Developer, Oracle’s main tool to work with databases. I’ve started to use SQL Developer from the beginning (2015, project Raptor, later renamed into SQL Developer). Before that, the only Oracle tool for working with it’s flagship database was SQL*Plus (and iSQL*Plus later). For that reason, most of […]

23. 01. 2019.

Python & Oracle Instant Client connection setup on Linux – part 2

In the previous article I’ve described how to install Oracle Instant Client and setup cx_Oracle Python driver correctly. You only need Basic package to install: Version Base – one of these packages is required Basic Package – All files required to run OCI, OCCI, and JDBC-OCI applications Download instantclient-basic-linux.x64- (72,794,506 bytes) (cksum – 3435694482) […]

22. 01. 2019.

Python & Oracle Instant Client connection setup on Linux

In the previous post https://www.josip-pojatina.com/en/python-oracle-connection-options/ you can find how to connect to Oracle database by using cx_oracle Python driver, full Oracle Client installation and Red Hat rpm based distribution (Red Hat, CentOS, Oracle Linux, Fedora).  In reality, more than 90% of all Linux servers in a Cloud belongs to Ubuntu (unlike on premise situation where […]

18. 01. 2019.

Python as bash replacement

Even today, on many projects I can still find that many developers are still using bash & Korn shell or even Pro*C as a main tool for developing scripts that will be executed as part of batch job in one of the following ways: Unix/Linux cron Oracle’s dbms_job / dbms_scheduler commercial enterprise job scheduling software […]

04. 01. 2019.

How to efficiently debug PL/SQL code

Almost every day I remember proverb/adage: if you haven’t discovered anything new for a while, it doesn’t mean you know everything and there is nothing left that you can learn. It only means you stop learning. I started with SQL Developer when it was internal and later alpha project inside the Oracle with a code […]