- 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 - 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) - download sqlcl sesuai dengan java nya, misalnya SQLcl 20.2 Downloads
https://www.oracle.com/tools/downloads/sqlcl-downloads-202.html - 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/* - 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
Install sqlcl di Ubuntu 22.04
cek ubuntu versiagus@server:~$ lsb_release -aNo LSB modules are available.Distributor ID: UbuntuDescription: Ubuntu 22.04.1 LTSRelease: 22.04Codename: jammy cek javaagus@server:~$ java -versionopenjdk 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) download sqlcl sesuai dengan java nya, misalnya SQLcl 20.2 Downloadshttps://www.oracle.com/tools/downloads/sqlcl-downloads-202.html unzip di folder tertentu misal sqlclagus@server:~$ unzip sqlcl-20.2.0.174.1557.zipagus@server:~$ cd sqlcl/agus@server:~$ sudo chmod…
1 minute
Leave a comment