Java Code Quality Tool – Spoon

http://spoon.gforge.inria.fr/examples.html

Advertisements

Oracle on Mac

Using docker will minimize Oracle compatibility issues with native Operating System.

Step 1: Install Docker
https://docs.docker.com/docker-for-mac/install/#download-docker-for-mac

Step 2: Install Oracle Image
https://hub.docker.com/r/sath89/oracle-12c/
———-
File: docker-compose.yml
version: ‘3’
services:
oracle:
image: sath89/oracle-12c
volumes:
– “./docker-volume/oracle/data:/u01/app/oracle”
ports:
– “8080:8080”
– “1521:1521”
———–
>docker-compose up

Step 3: Oracle is ready to use.
Follow notes in https://hub.docker.com/r/sath89/oracle-12c/

Step 4: Create separate user

CREATE BIGFILE TABLESPACE tbs_perm_project1
DATAFILE ‘tbs_perm_project1.dat’
SIZE 100M
AUTOEXTEND ON;

CREATE USER user1
IDENTIFIED BY “password”
DEFAULT TABLESPACE tbs_perm_project1;

GRANT create session TO user1;
GRANT create table TO user1;
GRANT create view TO user1;
GRANT create any trigger TO user1;
GRANT create any procedure TO user1;
GRANT create sequence TO user1;
GRANT create synonym TO user1;

GRANT UNLIMITED TABLESPACE TO user1;

————-

Step 5: Manage Oracle Image in Docker container
Use Kitematic
https://kitematic.com/

You need to restart Oracle Container, if there are issues.