ROracle in RStudio Server Ubuntu 18.04

Install Oracle Insta Client

Create directory

mkdir /opt/oracle

Unzip the contents of both files

Install AIO

sudo apt install libaio1

Execu script

sudo sh -c "echo /opt/oracle/instantclient_19_3 > \
  sudo ldconfig

Build ROracle

  'ORACLE_HOME' = '/opt/oracle/instantclient_19_8',
  'OCI_LIB64'   = '/opt/oracle/instantclient_19_8'
install.packages("ROracle", type="source")


Test your script

drv <- dbDriver("Oracle")
host <- "localhost"
port <- 1521
service <- "ids"
drv <- dbDriver("Oracle")

connect.string <- paste(
  "(ADDRESS=(PROTOCOL=tcp)(HOST=", host, ")(PORT=", port, "))",
  "(CONNECT_DATA=(SERVICE_NAME=", service, ")))", sep = "")

con <- dbConnect(drv, username = "user", password = "pass", dbname = connect.string)

table_results <- dbGetQuery(con,"select * from table")

Remove old Kernels Ubuntu 18.04

Copy the text, this is one line.

echo $(dpkg --list | grep linux-image | awk '{ print $2 }' | sort -V | sed -n '/'`uname -r`'/q;p') $(dpkg --list | grep linux-headers | awk '{ print $2 }' | sort -V | sed -n '/'"$(uname -r | sed "s/\([0-9.-]*\)-\([^0-9]\+\)/\1/")"'/q;p') | xargs sudo apt-get -y purge

Chromium OS installation step by step

I have been struggling for two day to make the files app work, here is the solution I found, step by step so new users are able to execute it.

Download a fresh image from

I tried October 13 daily build 64 bits.

Load the image into an USB as explained in the page.

Boot chromium from USB and configure the firts run.

Once you are logged in go to the next page.

Follow the instructions to generate your keys.

Then go to the developer console apis list and make sure you have the following apis enabled.

Drive API
Drive SDK.
Google Maps Geolocation API.
Google Now For Chrome API. 

Open a new Crosh screen Ctrl + Alt + T in chromium browser.

Type: shell.

Type : sudo su.

And enter the password usually “password” without quotes.

Mount your system as read write.

Type: mount -o remount,rw /

Type: cd /etc

Type: vi chrome_dev.conf

Go to the first line and insert your keys (fake ones used):




Be careful as VI is very tricky to use, once the data is correct save the file, using ESC wq and enter, if you have issues saving find in google on how to use VI.

Once the file is saved go to the bottom right of the screen and click on your user picture and sign out, once the system ui restart login, it will say that you need to login again in order to update your credentials, once you login again, the system will be able to use the files APP.

After this I usually load the plugins like flash and other unsupported files.

What worked for me is following the instructions in.

The script asks for Keys, but I already saved them in the file, So maybe we can save some of the steps discussed above using the functionality in the script, If someone can try that it will be great as we will avoid the use of the shell.

Please share your experience with the instructions I have provided, Im happy to be able to share something with the community.


Create an upstart script for uTorrent

To create an upstart script for uTorrent, move all the uTorrent files to the /home/yourusername/.utorrent folder, then run the following command:

$sudo nano /etc/init/utorrent.conf

description “utorrent startup script”

start on (local-filesystems and started dbus and stopped udevtrigger)
stop on runlevel [016]
cd /home/yourusername/.utorrent
exec su yourusername -c “/home/yourusername/.utorrent/utserver”
end script



$sudo ln -s /lib/init/upstart-job /etc/init.d/utorrent


WPA Ubuntu 10.04

Install wpa supplicant package:

$ sudo apt-get install wpasupplicant

Configure network ESSID and passphrase.
In this example I use ESSID ‘yantoknuk-singtel’ and passphrase ‘ngumbahkucing’.

$ wpa_passphrase yantoknuk-singtel
# reading passphrase from stdin

After that, type in your passphrase right below the text ‘# reading passphrase from stdin’.

# reading passphrase from stdin

Edit or create /etc/wpa_supplicant.conf:

$ sudo nano /etc/wpa_supplicant.conf

And then type in the following lines which is produced by wpa_passphrase before:


Save and exit nano.
To test the configuration, execute this:

$ sudo wpa_supplicant -iwlan0 -c/etc/wpa_supplicant.conf -Dwext

If it’s successful you should see something like the following:

Trying to associate with 00:ff:00:1e:a7:7d (SSID=’yantoknuk-singtel’ freq=0 MHz)
Associated with 00:ff:00:1e:a7:7d
WPA: Key negotiation completed with 00:ff:00:1e:a7:7d [PTK=TKIP GTK=TKIP]

It’s finish. Your computer is now associated / connected to the access point.
To make it autorun on boot, add in these lines to /etc/network/interfaces:
$ sudo nano /etc/network/interfaces

And add the following lines:

auto wlan0
iface wlan0 inet dhcp
wpa-driver wext
wpa-conf /etc/wpa_supplicant.conf


Headless X11VNC

The answer is actually a combination of two separate solutions, each of which did not work separately. I have 10.04 now working headless on two different servers (different MB, Video…) and both are working great.

Step 1. Create a xorg.conf in /etc/X11 with the following. I tried Step 2 without doing this and it failed exactly as it had before.

Section “Device”
Identifier “VNC Device”
Driver “vesa”

Section “Screen”
Identifier “VNC Screen”
Device “VNC Device”
Monitor “VNC Monitor”
SubSection “Display”
Modes “1024×768”

Section “Monitor”
Identifier “VNC Monitor”
HorizSync 30-70
VertRefresh 50-75

Step 2. Disable KMS for your video card as described here

The jist is to know which video card manufacturer you have and use the command line entry below it to create the appropriate kms.conf file with the line “options…modeset=0” line in it. If you have access to the GUI you could just are easily create/modify the file and put the “options…modeset=0” in as appropriate.

The following are input into the terminal windows as a line command.

# ATI Radeon:
echo options radeon modeset=0 > /etc/modprobe.d/radeon-kms.conf

# Intel:
echo options i915 modeset=0 > /etc/modprobe.d/i915-kms.conf

# Nvidia (this should revert you to using -nv or -vesa):
echo options nouveau modeset=0 > /etc/modprobe.d/nouveau-kms.conf

Step 3. Reboot…Putty In…startx…GTG!


X11VNC Ubuntu 10.04

This is a simple guide on setting up X11VNC on a system running Ubuntu 10.04 in a headless configuration. Good Luck, and YMMV.

1. Terminal > sudo apt-get install x11vnc
OR compile x11vnc from source:

2. Terminal > sudo nano /etc/gdm/Init/Default

2.1. Add on the second last line:
/usr/bin/x11vnc -xkb -rfbauth /etc/x11vnc/passwd -o /etc/x11vnc/log -bg -forever
OR if you compiled from source, add the following line:
/usr/local/bin/x11vnc -xkb -rfbauth /etc/x11vnc/passwd -o /etc/x11vnc/log -bg -forever

2.2. Terminal > sudo mkdir /etc/x11vnc

2.3. Terminal > sudo touch /etc/x11vnc/log

2.4. Terminal > sudo x11vnc -storepasswd /etc/x11vnc/passwd
Follow the commands to store your password. Alternatively, if you do not wish to use a password, do not run this line and remove the -rfbauth /etc/x11vnc/passwd section from /etc/gdm/Init/Default

3. Terminal > sudo restart gdm