1. cek ubuntu versi
    agus@server:~$ lsb_release -a
    No LSB modules are available.
    Distributor ID: Ubuntu
    Description: Ubuntu 22.04.1 LTS
    Release: 22.04
    Codename: jammy
  2. cek java
    agus@server:~$ java -version
    openjdk version “1.8.0_342”
    OpenJDK Runtime Environment (build 1.8.0_342-8u342-b07-0ubuntu1~22.04-b07)
    OpenJDK 64-Bit Server VM (build 25.342-b07, mixed mode)
  3. download sqlcl sesuai dengan java nya, misalnya SQLcl 20.2 Downloads
    https://www.oracle.com/tools/downloads/sqlcl-downloads-202.html
  4. unzip di folder tertentu misal sqlcl
    agus@server:~$ unzip sqlcl-20.2.0.174.1557.zip
    agus@server:~$ cd sqlcl/
    agus@server:~$ sudo chmod a+x /home/agus/sqlcl/bin/*
  5. test koneksi
    agus@server:~$ alias sqlcl=’/home/agus/sqlcl/bin/sql’
    agus@server:~$ sqlcl SCOTT/TIGER@192.168.10.15:1521/ubsweb
    SQLcl: Release 20.2 Production on Tue Aug 09 15:45:42 2022
    Copyright (c) 1982, 2022, Oracle. All rights reserved.
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

Leave a comment

Trending