Oracle Installation and Setup
This chapter provides information about installing and setting up
an Oracle database.
Before You Begin
recommends that an Oracle DBA install the Oracle server.
You need to update the patch for the known Oracle defect: ORA-22275. If this is not done persistent chat rooms will not work properly.
the security recommendations for the Oracle database in your Oracle
For information on supported versions, see External Database Setup Requirements.
IM and Presence Service supports an SSL connection to
Oracle Database Enterprise Edition only.
the Oracle database, refer to your Oracle documentation.
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 UTF8.
tablespace and a database user, connect to the Oracle database as sysdba:
sqlplus / as
keyword of the
TABLESPACE command tells Oracle where to put the tablespace's
the following command:
DATAFILE '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.
IDENTIFIED BY "new_user's_password"
TEMPORARY TABLESPACE "TEMP" QUOTA UNLIMITED ON
permissions to the database user.
following example grants all permissions to a database user:
GRANT DBA TO
following examples grant limited permissions to the database user:
GRANT CREATE ANY VIEW
GRANT "CONNECT" TO
GRANT "RESOURCE" TO
Create New Database Instance
||Enter the command dbca The Database Configuration Assistant wizard opens.|
||Click Next. 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 Next. |
The Management Options window appears.
|| Take note of the SID because it is needed in Step 15.|
|| 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. |
The Recovery Configuration window appears.
||This creates the new database instance in the same folder as your other database instances.|
||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.