To install the Oracle database, refer to your Oracle documentation.
In compliance with XMPP specifications, the IM and Presence Service node uses UTF8 character encoding. This allows the node to operate using many languages simultaneously and to display special
language characters correctly in the client interface. If you want to use Oracle with the node, you must configure it to support
To create tablespace and a database user, connect to the Oracle database as sysdba:
sqlplus / as sysdba
keyword of the
TABLESPACE command tells Oracle where to put the tablespace's
the following command:
CREATE TABLESPACEtablespace_nameDATAFILE 'absolute_path_to_oracle_installation\oradata\database_name\datafile.dbf' SIZE 100M AUTOEXTEND
ON NEXT 1M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE
tablespace_name with the tablespace name.
absolute_path_to_oracle_installation with the absolute path
to where Oracle is installed. The entire path, including
datafile.dbf, is enclosed in single quotation marks.
database_name with the name of your database folder.
datafile.dbf must be created in a folder under
in this case the
datafile.dbf with the datafile name you want to create.
CREATE USERuser_nameIDENTIFIED BY "new_user's_password"
TABLESPACEtablespace_nameTEMPORARY TABLESPACE "TEMP" QUOTA UNLIMITED ON
user_name with the new user's user name.
CREATE USERuser_name without double quotes will default to
upper case and with quotes it will maintain the case
"new_user's_password" with the new user's password.
new_user's_password within double quotation marks makes the
variable case-sensitive. By default SQL identifiers are not case-sensitive.
tablespace_name with the tablespace name.
permissions to the database user.
following example grants all permissions to a database user:
GRANT DBA TOuser_name;
following examples grant limited permissions to the database user:
GRANT CREATE ANY VIEW
GRANT "CONNECT" TOuser_name;
GRANT "RESOURCE" TOuser_name;
Create New Database Instance
Enter the command dbca
The Database Configuration Assistant wizard opens.
The Operations window appears.
Click the Create a Database radio button and then click Next.
The Database Templates window appears.
Click the General Purpose or Transaction Processing radio button and then click Next.
The Database Identification window appears.
Enter a unique Global Database Name on this screen and also a unique Oracle System Identifier (SID) for the database and click
Take note of the SID because it is needed in Step 15.
The Management Options window appears.
Under the Enterprise Manager tab the required settings are enabled by default but you can configure optional backups and
alert notifications. Click Next.
The Database Credentials window appears.
The window has two options to set up password authentication for database users, choose one and click Next.
The Database File Locations window appears.
The Storage Type drop-down list should be the same as your Oracle Installation. Click the Use Oracle-Managed Files radio button and click Next.
This creates the new database instance in the same folder as your other database instances.
The Recovery Configuration window appears.
Leave the default values and click Next.
The Database Content window appears.
[Optional] Check the check box if you want to enable Sample Schemas and click Next.
The Initialization Parameters window appears.
Under the Memory tab the default value is for a database instance with 4GB of memory. This can be set higher or lower as needed.
The amount of memory used should not be configured too high as this starves other database instances of memory.
Under the Character Sets tab click the Use Unicode radio button and click Next.
The Database Storage window appears.
Leave the default settings as they are and click Next.
The Create Options window appears.
Check the Create Database check box and click Finish.
Once a new database instance is created, you must temporarily change the ORACLE_SID environment variable (from Step 5) on
your Unix system by running the command:
export ORACLE_SID=new_oracle_db_instance_sid. This will change the SID so when you login using sqlplus, it will use the new instance and not the old one; you can then
repeat the steps in Install Oracle Database.
Once these steps are completed you can change the ORACLE_SID environment variable by sourcing the bash profile(assuming the
old SID is in the bash profile) or by running the export command (Step 15) but changing the SID back to its original value.