Install Oracle Database
Before you begin
Cisco 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.
Read the security recommendations for the Oracle database in your Oracle documentation.
For information on supported versions, see External Database Setup Requirements.
For Oracle version 11 and earlier, you must configure your Oracle database to use UTF8 character encoding.
As of Oracle version 12, you must configure the Oracle database to use AL32UTF8 character encoding, as UTF8 may lead to unexpected behavior. For example, if you use UTF8 with Oracle 12, chat rooms may be deleted when you restart the Cisco XCP Text Conference Manager service.
To install the Oracle database, refer to your Oracle documentation.
To create tablespace and a database user, connect to the Oracle database as sysdba:
sqlplus / as sysdba
Create a database user.
Grant permissions to the database user.
The following example grants the required permissions and privileges to a database user, which are needed to create or upgrade the schema:
After you have created or upgraded the schema, the following privileges can be revoked if greater access control is required: