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).
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.
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.
To shut down the database, user oracle should run
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
To start the database and the listeners, user oracle uses the shell command
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;
The connection string to connect to the database via TCP port 1521 is
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
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.