Using MLE with VirtualBox

This beta release of Oracle Database MLE comes as pre-built VirtualBox appliance. After downloading the virtual appliance (.ova) file, import it into VirtualBox and boot up the virtual machine. The virtual machine runs Oracle Linux 7.2, and has Oracle Database MLE pre-installed. The database starts during the boot process of the appliance. The main user of the virutal machine is user oracle (password: oracle).

User Setting

The main user of this virtual appliance is user oracle. During the setup step you will also need the user root. Both users have their password set to oracle.

Database Setup

The virtual appliance comes with a pre-configured database with SID DBML. A TCP listener is configured for port 1521. The database starts during the boot process of the appliance. The dba operating system group (which user oracle is a member of) is configured as the database administrator group. Furthermore, user oracle is configured to have the correct environment variables exported in every shell.

The passwords for all database system accounts are set to oracle. The default profile is modified such that passwords don't expire. Note that this setting is highly insecure and should not be used in a publicly available environment.

Shutting Down

To shut down the database, user oracle should run

$ dbmlshut

This command will shut down the database and the listeners. To only shut down the database but keep the listeners running, log into SQL*Plus and execute a shutdown command:

$ sqlplus / as sysdba
SQL> SHUTDOWN IMMEDIATE;

To force shutdown of the database, use SHUTDOWN ABORT instead of SHUTDOWN IMMEDIATE.

Starting

To start the database and the listeners, user oracle uses the shell command

$ dbmlstart

To start only the database (assuming the listeners are already running), log into SQL*Plus as sysdba and execute a startup command:

$ sqlplus / as sysdba
SQL> STARTUP;

Role for the Extension

The role mle_user guards access to and use of the multilingual extension. This role has to be granted to every user who should be able to deploy extension code and run it. The examples here use user scott who already has this role granted.

If you create a new user, say myuser, then you must manually grant the mle_user role to this user:

$ sqlplus / as sysdba
SQL> GRANT mle_user TO myuser;

Database Connection

The connection string to connect to the database via TCP port 1521 is

localhost:1521/DBML

To connect to the database via SQLPlus as user scott*, use

$ sqlplus scott/tiger@localhost:1521/DBML

Operating system user oracle is set up such that you don't need the connection string to log into the database. Thus, if you want to log in as user scott, you can simply use

$ sqlplus scott/tiger

Node.js Installation

The virtual appliance ships with only a minimal installation of Node.js. In particular, it does not include the Node.js Package Manager (npm). If you want to reuse packages from npm, please install Node.js from the official repository.

For this, open a terminal and switch to user root (the password is oracle).

$ su -

For the remaining steps you will need Internet access. If you use a proxy, first export the correct proxy setting:

$ export http_proxy=your.http.proxy.here
$ export https_proxy=your.https.proxy.here

Next, add the Node.js 6.x repository:

$ curl --silent --location https://rpm.nodesource.com/setup_6.x | bash -

Finally, install the Node.js package via yum.

$ yum install nodejs -y

Adding GNU readline Support to SQL*Plus

GNU readline is a library designed to support command prompt history and editing. To add support for GNU readline to SQL*Plus please follow these instructions and adjust the commands used in this document accordingly.