Install SQL*Plus on Ubuntu 16.04

1. First, you need to download Instant Client Downloads.


2. Install alien software.



sudo apt-get install alien



3. Navigate to the folder where the downloaded rpm files are located and execute the following commands:



sudo alien -i oracle-instantclient*-basic*.rpm
sudo alien -i oracle-instantclient*-sqlplus*.rpm
sudo alien -i oracle-instantclient*-devel*.rpm



4. Type following command to install libaio.so



sudo apt-get install libaio1



5. Create an Oracle configuration file:



sudo nano /etc/ld.so.conf.d/oracle.conf



6. Put the following line in the created file:



/usr/lib/oracle/<your oracle version>/client64/lib/



7. Update the configuration by running the following command:



sudo ldconfig



8. Try to connect using the following command:



sqlplus system/oracle@localhost:49161/xe

Installing Oracle XE 11g on Ubuntu

Installing Oracle XE with Docker

Docker is an application container for Linux. It is based on LXC and gives you the ability to package complete application including their dependencies to a self-containing file called an image. These images can be exchanged and run on every Linux machine where Docker is installed.  It is the easiest way to install Oracle XE. Docker images are also shared around the community on https://index.docker.io.

1. First, you need to install Docker on Ubuntu. Follow the instructions given in this doc.


2. Pull the image to your machine using the following command :



docker pull arahman/docker-oracle-xe-11g



3. Run the image using the following command :



docker run -d -p 49160:22 -p 49161:1521 -p 49162:8080 arahman/docker-oracle-xe-11g /sbin/my_init



4. Connect to the database with the following setting:



hostname: localhost
port: 49161
sid: xe
username: system
password: oracle



5. You can connect to the database using SQL*Plus

How to share folders between Ubuntu and Windows running in Virtualbox

Step 1 : Create a directory called “vmsharedfiles”  in Ubuntu.

Step 2: Open up virtualbox instance.

Go to top menu and Click on Devices → Shared Folders → Shared Folders Settings.

If you are getting any error like “The VirtualBox Guest Additions do not appear to be available on this virtual machine, and shared folders cannot be used without them. To use shared folders inside the virtual machine, please install the Guest Additions if they are not installed, or re-install them if they are not working correctly, by selecting Insert Guest Additions CD image from the Devices menu. If they are installed but the machine is not yet fully started then shared folders will be available once it is.”, select the Devices option from VirtualBox's menu bar, and click on the Install Guest Additions CD Image option. Guest Additions installer will start automatically.

Follow the instructions to install.

Step 3 : Click on the green folder icon to Add new shared folder option in the right hand side.

Step 4 : You will prompt to the screen to select the folder you created in step 1. Select that folder and click open. And check “Make Permanent” option.

Step 5 : Go to My computer → computer → Map network drive → Map network drive.

You will see the screen below:

Step 6 : Click on Browse to select the shared folder that is created on step 1. Click OK and Finish.

Step 7 : Then this shared folder will be added to the My computer section.

Step 8 : Now you can access “vmsharedfiles” folder  in Ubuntu from Windows 10 in virtualBox.

How to Install Latest VirtualBox 5.1 on Ubuntu 16.04

VirtualBox is a free and open-source virtualization software. It can run on Linux, Mac, Windows.

If you have already installed VirtualBox from Ubuntu repository, remove it with:

sudo apt remove virtualbox

Next, open /etc/apt/sources.list file:

sudo nano /etc/apt/sources.list

Append the following line at the end of this file.

deb http://download.virtualbox.org/virtualbox/debian xenial contrib

Press Ctrl+O to save the file. Then press Ctrl+X to close the file.

Now fetch the Oracle GPG public key and import it to your Ubuntu 16.04 system with the following command so packages downloaded from Oracle repository can be verified.

wget -q https://www.virtualbox.org/download/oracle_vbox_2016.asc -O- | sudo apt-key add -

Then update local package index and install Virtualbox.

sudo apt update
sudo apt install virtualbox