The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.
This chapter provides information about installing and setting up an Oracle database.
Cisco recommends that an Oracle DBA install the Oracle server.
Read the security recommendations for the Oracle database in your Oracle documentation.
IM and Presence Service supports Oracle 9i, 10G, and 11G.
To install the Oracle database, refer to your Oracle documentation.
Note | 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 UTF8. |
To create tablespace and a database user, connect to the Oracle database as sysdba:
sqlplus / as sysdbaStep 1 | Enter the command dbca The Database Configuration Assistant wizard opens. | ||
Step 2 | Click Next. The Operations window appears. | ||
Step 3 | Click the Create a Database radio button and then click Next. The Database Templates window appears. | ||
Step 4 | Click the General Purpose or Transaction Processing radio button and then click Next. The Database Identification window appears. | ||
Step 5 | Enter a unique Global Database Name on this screen and also a unique Oracle System Identifier (SID) for the database and click Next.
| ||
Step 6 | 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. | ||
Step 7 | The window has two options to set up password authentication for database users, choose one and click Next. The Database File Locations window appears. | ||
Step 8 | 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.
| ||
Step 9 | Leave the default values and click Next. The Database Content window appears. | ||
Step 10 | [Optional] Check the check box if you want to enable Sample Schemas and click Next. The Initialization Parameters window appears. | ||
Step 11 | 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.
| ||
Step 12 | Under the Character Sets tab click the Use Unicode radio button and click Next. The Database Storage window appears. | ||
Step 13 | Leave the default settings as they are and click Next. The Create Options window appears. | ||
Step 14 | Check the Create Database check box and click Finish. | ||
Step 15 | 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.