AYON KARMAKAR

Posted on Dec 28, 2023

Setting Up PL/SQL on Linux Ubuntu/WSL

#database #wsl #plsql #ubuntu

0. Basic Requirements

🔁[sudo apt update && sudo apt upgrade]
update java[sudo apt install openjdk-11-jdk] 
Oracle SQL Developer(Tool installation) -optional [can use VSCode extension + Oracle Express Edition(wsl)]

PL/SQL Configuration

Oracle SQL Developer comes with PL/SQL support 😋. You can create and run PL/SQL scripts directly within the tool.

Install Oracle SQL Developer on 🐧 Ubuntu

1. Download Oracle SQL Developer

Go to the Oracle SQL Developer download page and download the Linux RPM file.

2. Extract the downloaded file to a folder of your choice.

if you don't have unzip installed, install it using the following command:
  sudo apt-get install unzip

Once the download is complete, extract the archive to a location of your choice.

  -- unzip sqldeveloper-*-no-jre.zip (for any version)
  unzip sqldeveloper-20.4.1.407.0006-no-jre.zip

3. Install Required Packages

Oracle SQL Developer requires some additional packages. Install them using the following commands:

    sudo apt-get install libc6-i386 lib32ncurses5 lib32z1 lib32stdc++6

4. Run Oracle SQL Developer

Navigate to the sqldeveloper folder and run the sqldeveloper.sh script.

  cd sqldeveloper
  ./sqldeveloper.sh

The first time you run Oracle SQL Developer, it will prompt you to locate the Java executable. Provide the path to your JDK installation.

5. Configure Oracle Database Connection

Open Oracle SQL Developer.
Click on "View" in the menu and select "Connections" to open the Connections tab.
Right-click on "Connections" and choose "New Connection."
Enter the connection details such as Connection Name, Username, Password, and SID/Service Name.

Note: If you followed the steps then no need to install Oracle Express Edition(wsl) as it comes with Oracle SQL Developer.

🪟 Windows Subsystem for Linux (WSL)

Download the Linux RPM
make sure to move the downloaded file to the WSL filesystem
Install the RPM package using the following command:

  sudo rpm -i sqldeveloper-20.4.1.407.0006-20.4.1-407.0006.noarch.rpm

- Navigate to the sqldeveloper folder and run the sqldeveloper.sh script.

  cd sqldeveloper
  ./sqldeveloper.sh

If you want to create a desktop shortcut, right-click on the sqldeveloper.sh script and select Create Shortcut. You can then copy the shortcut to your desktop.

To set up PL/SQL on Linux Ubuntu, you'll need to install Oracle Database Express Edition (Oracle XE), which includes the Oracle SQL*Plus and PL/SQL components. Here are the general steps to set up PL/SQL on Linux Ubuntu:

1. Install Required Packages

Oracle Database Express Edition requires some additional packages. Install them using the following commands:

  sudo apt-get install alien libaio1 unixodbc

2. Download or Install Oracle Database Express Edition (Oracle XE):

A. Download

Go to the Oracle website and download the Oracle Database Express Edition for Linux. Make sure to accept the license agreement.

Oracle Database Express Edition 21c Express Edition for Linux x64
Extract the downloaded file to a folder of your choice.

  unzip oracle-database-xe-*.rpm.zip

B. Install

Install the RPM package using the following command:

  sudo alien --scripts -d oracle-database-xe-*.rpm

Install the Oracle Database Express Edition using the following command:

  sudo dpkg --install oracle-database-xe-*.deb

3. Configure Oracle Database Express Edition using the following command:

  sudo /etc/init.d/oracle-xe-21c configure

The configuration script will prompt you to set a password for the SYS and SYSTEM users. Make sure to remember the password you set for these users.
The configuration script will also prompt you to set the HTTP port for Oracle Application Express (APEX). The default port is 8080(or any other if already port is occupied). ## 4. Start the Oracle Database Express Edition using the following command:

  sudo service oracle-xe-21c start

5. Add the following lines to the end of the /etc/bash.bashrc file:

  export ORACLE_HOME=/opt/oracle/product/21c/dbhomeXE
  export ORACLE_SID=XE
  export PATH=$ORACLE_HOME/bin:$PATH

6. Load the new environment variables using the following command:

  source /etc/bash.bashrc

7. More Configuration

Connect to the Oracle Database Express Edition using the following command:

  sqlplus sys as sysdba

Enter the password you set for the SYS user when you configured the Oracle Database Express Edition.
Run the following command to unlock the HR user:

  ALTER USER hr ACCOUNT UNLOCK;

Run the following command to change the password for the HR user:

  ALTER USER hr IDENTIFIED BY hr;

Connect to the Oracle Database Express Edition using the following command:

  sqlplus hr/hr

Stop the Oracle Database Express Edition using the following command:

  sudo service oracle-xe-21c stop

Run the following command to exit SQL*Plus:

  exit

DEV Community