# Stash Latest : Connecting Stash to Oracle

This page last changed on Aug 14, 2012 by dfabretti.

This page describes how to connect Stash to a Oracle database. The overall process for using a Oracle database with Stash is: Install Oracle where it is accessible to Stash. Create a database and user on the Oracle server for Stash to use. Install Stash on Windows, or on Linux or Mac. Either: at Stash install time, run the Setup Wizard to connect Stash to the Oracle database, or at a later time, migrate Stash to the Oracle database. It is assumed here that you already have Oracle installed and running. For information about installing Oracle and creating Oracle databases, see the Oracle documentation pages. For the versions of Oracle supported by Stash see Supported platforms. | On this page: 1. Prerequisites 2. Connect Stash to the Oracle database Related pages: Connecting Stash to an external database Connecting Stash to MySQL Connecting Stash to PostgreSQL Connecting Stash to SQL Server

### 1. Prerequisites

#### Backup

If you are migrating your data from the internal Stash database, back up the Stash home directory.

If you are migrating your Stash data from a different external database, back up that database by following the instructions provided by the database vendor before proceeding with these instructions.

See Data recovery and backups.

#### Create the Oracle schema for Stash

Before you can use Stash with Oracle, you must set up Oracle as follows:

- Ensure that you have a database instance available for Stash (either create a new one or use an existing one)
  The character set of the database must be set to either `AL32UTF8` or `UTF8`, to support storage of Unicode data as per the Oracle documentation.
  Note that it is important to the proper operation of Stash that the database store its data in a case-sensitive manner. By changing the values of the NLS_COMP and/or NLS_SORT variables, it is possible to cause Oracle to perform its searches in a case-insensitive manner. We therefore strongly recommend that those variables be left at their default values.
- Create a user that Stash will connect as (e.g. `stash`).
  Remember the database user name; it will be used to configure Stash's connection to the database in subsequent steps.
  When you create a user in Oracle, a schema is automatically created.
  It is strongly recommended that you create a new database user for use by Stash rather than sharing one that is used by other applications or people.
- Grant the Stash user privileges to create sessions and tables on the schema that is automatically created for you.

The format of the command to create a user in Oracle is:

    CREATE USER <user>
    	IDENTIFIED BY <password>
        DEFAULT TABLESPACE <tablespace>
        QUOTE UNLIMITED ON <tablespace>;

Here is a simple example, using SQL*Plus, of how one might create a user called `stash` with password `jdHyd6Sn21` in tablespace `users`, and grant the user a minimal set of privileges. When you run the command on your machine, remember to replace the user name, password and tablespace names with your own values.

    CREATE USER stash
        IDENTIFIED BY jdHyd6Sn21
        DEFAULT TABLESPACE users
        QUOTA UNLIMITED ON users;

    GRANT CREATE SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE TRIGGER to stash;

This creates an empty Oracle schema with the name `stash`, and a user that can log in from the host that Stash is running on and who has full access to the newly created schema. In particular, the user is allowed to create sessions and tables.

Note that Stash will generally require about 25–30 connections to the database.

### 2. Connect Stash to the Oracle database

You can now connect Stash to the Oracle database, either:

- when you run the Setup Wizard, at install time,
- when you wish to migrate to Oracle, either from the embedded Stash database or from another external database.

When running the Setup Wizard at install time:

1. Select External at the 'Database' step.
2. Select Oracle for Database Type.
3. Complete the form. See the table below for details.
4. Click Next, and follow the instructions in the Stash Setup Wizard.

When migrating to Oracle:

1. Click Administration and then Database (under 'Settings').
2. Click Migrate database.
3. Select Oracle for Database Type.
4. Complete the form. See the table below for details.
5. Click Start Migration.

Hostname | The host name or IP address of the computer running the Oracle server.
Port | The TCP port with which Stash can connect to the database server. The default value is the default port that Oracle runs against. You can change that if you know the port that your Oracle instance is using.
SID | The system identifier of the Oracle instance that Stash should connect to.
Username | The username that Stash should use to access the database.
Password | The password that Stash should use to access the database.

## Attachments:

Stash_012_oracle.png (image/png)