Oracle DB Client Setup

SQL Developer

Download Installer file.

• Oracle SQL Developer

VS Code Extension

Open Oracle SQL Developer Extension for VSCode > Install > Add Connections > Save.

Install in Windows

Download and Extract installation file.

Run sqldeveloper/sqldeveloper.exe for installation.

Install in Ubuntu

Use Java 11 and SQL Developer 23

sudo apt install -y openjdk-11-jdk
sudo update-alternatives --config java
# Select java 11

# Update ~/.bashrc and ~/.zshrc
export JAVA_HOME=$(dirname $(dirname $(readlink -f $(which java))))
export PATH=$PATH:$JAVA_HOME/bin

Setup installation file.

unzip sqldeveloper-...no-jre.zip

sudo mv sqldeveloper /opt

Applications menu entry

sudo vi /usr/share/applications/sqldeveloper.desktop

[Desktop Entry]
Name=Oracle SQL Developer
Comment=SQL Developer from Oracle
GenericName=SQL Tool
Exec=/opt/sqldeveloper/sqldeveloper.sh
Icon=/opt/sqldeveloper/icon.png
Type=Application
StartupNotify=true
Categories=Utility;Oracle;Development;SQL;

Connect Oracle Database

1. Open SQL Developer
2. Create a Connection Manually
3. Enter Name: My Oracle DB
4. Username: sys
5. Role: SYSDBA
6. Password: your-password
7. Connection type: Basic
8. Hostname: localhost
9. Port: 1521
10. SID: orcl
11. Test and Connect

SQL Plus

Download Oracle Database Client

Installation guide

Extract Downloaded file

unzip LINUX...._client.zip

Run Installer file with UI

cd client && ./runInstaller

Update path environment variable

export PATH=/u01/app/oracle/product/.../client_1:$PATH

Uninstall SQL Plus

./runInstaller -deinstall -home /u01/app/oracle/product/.../client_1

Useful Commands

Test connection

SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME;

SELECT TABLESPACE_NAME FROM USER_TABLESPACES;

SELECT * FROM dba_pdbs;

SELECT name, con_id, open_mode FROM v$pdbs;

SELECT * FROM V$VERSION;